Relational Database Design Provides Good DB2 Performance

Relational Database Design Provides Good DB2 Performance

2006 DB2 Magazine article shows the importance of adhering to best relational database design practices and understanding DB2 in order to save time and effort on DB2 performance tuning efforts.

IDUG Abuzz With DB2 UDB 8.2

IDUG Abuzz With DB2 UDB 8.2

2004 DB2 Magazine article describes improvements to DB2 UDB 8.2 that support improved DB2 UDB database design with DB2 stored procedure and DB2 trigger enhancements, as well as changes to DB2 Net.

Taking Advantage of Relational Technology Part 4

Once you have reviewed the overall system for the aspects that we have discussed over the last few months, it’s time to drill down into your more critical transactions and processes. Critical transactions are those frequently executed transactions that are using excessive CPU or I/O resources. For this analysis using a performance monitor is necessary . . . → Read More: Taking Advantage of Relational Technology Part 4

Tablespace Savings in DB2

Last time I wrote about DB2 Checkpoint and index definitions over your busiest tables. This week I will discuss the old style of tablespace definitions and their potential performance impact.

Tablespaces Need to Be Reorganized

The first thing to look at is the current state of the database tables and indexes. Usually I find that . . . → Read More: Tablespace Savings in DB2

DB2 Case Study Introduction: DB2 Performance and Throughput

Every client is different and working in a variety of different environments helps me understand different systems, applications and DB2 database design performance aspects and what works and doesn’t work. Over the next few weeks, I’ll be highlighting for you how to improve the DB2 performance . . . → Read More: DB2 Case Study Introduction: DB2 Performance and Throughput