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

New DB2 9 for z/OS Utilities

Within the IBM Z Summit road show that was recently in Washington DC, the DB2 presentations highlighted a number of DB2 utilities improvements. All of these DB2 utilities improvements are integrated into the new DB2 10 but there were many that can be incorporated into . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 18

Performance Features in DB2 V9 for z/OS -- Part 4

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

One of the important new changes is Utilities Improvements which helps your . . . → Read More: Performance Features in DB2 V9 for z/OS — Part 4

The Effect of Indexes on DB2 Performance

The trail for the hunter of performance problems leads from the DB2 table to its indexes. As I went deeper into this DB2 performance jungle, I discovered more interesting artifacts.

DB2 Index

Since the table I talked about in the last post was typical of other tables in other applications in the company, it made . . . → Read More: The Effect of Indexes on DB2 Performance