DB2 Performance Maintenance - Avoid Database Reorgs

Adjust Your FREEPAGE and PCTFREE for Growth

The proper free space settings along with the appropriate allocations detailed last week can help you avoid any DB2 reorgs and improve DB2 performance for a long time while your database grows. Properly setting your free space is . . . → Read More: DB2 Performance Maintenance — Avoid Database Reorgs

DB2 Performance Maintenance - Saving Resources and CPU with the Correct Setting

Last week I talked about the basics of evaluating DB2 for z/OS and LUW compression. DB2 compression saves a huge amount of disk storage space and improves performance by eliminating I/O within your system. This week we talk about the performance implications of some other table space settings. If your database tables suffer performance problems, have bad SQL access paths and need constant reorgs, there are a number of table space settings that can help you avoid reorgs, minimize outages and help your . . . → Read More: DB2 Performance Maintenance – Saving Resources and CPU with the Correct Setting

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