DB2 Performance Features in DB2 V9 for z/OS – Part 17

New APARs Bring Features into V8 and V9 NOW!

Some of the new tablespace partitioning choices and features in DB2 Version 8 and now DB2 Version 9 for z/OS that I talked about last week are getting extra enhancements. During the recent IBM System Z Summit road show that was in . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 17

DB2 Performance Features in DB2 V9 for z/OS – Part 16

DB2 V9 Tablespace and Partitioning Choices

Some of the new tablespace partitioning choices and features in DB2 Version 8 and Version 9 for z/OS are making everyone realize there are a number of table design choices to fit any application access type.

In DB2 V8, the first of the . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 16

DB2 Performance Features in DB2 V9 for z/OS – Part 14

CLONE Tables

As I have talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new DB2 performance features. Many of these features can really benefit your standard application performance; improve application response time and overall availability of your systems and data.

Another one of the great features . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 14

DB2 Performance Features in DB2 V9 for z/OS – Part 7

As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new DB2 performance features. Many of these features can really benefit your standard DBA operations; improve application performance and overall availability of your systems and data.

Another one of the enhancements with DB2 Version 9 for z/OS that . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 7

DB2 Performance Summary Part 3

Make sure that the interface with CICS works well to improve performance:

Validate the settings between your DB2 CICS transaction configurations. Make sure the maximum workload from one TOR, AOR or DOR is not overwhelming another CICS processing partner. If your system is heavily dependent on CICS transactions: Make sure that you are reviewing the . . . → Read More: DB2 Performance Summary Part 3

DB2 Performance Summary Part 2

Make sure that you are using the correct database design to improve DB2 performance:

Use partitioning for robust tables that play central parts in the processing to help ease locking and encourage parallelism. Also leverage database partitioning for large tables (over 500,000 rows) which might benefit from spreading out the I/O to different partitions . . . → Read More: DB2 Performance Summary Part 2

Taking Advantage of Relational Technology Part 2

Avoid Inappropriate Tablespace Scans

There are many DB2 access paths available. The most expensive of these is a tablespace scan because it causes DB2 to scan all the entries of a table to retrieve the rows desired by the application. Within most of the system and application performance reviews done at one recent client’s review, . . . → Read More: Taking Advantage of Relational Technology Part 2

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