Dave Beulke

Make sure that you are using the correct database design

Use partitioning for robust tables that play central parts in the processing to help ease locking and encourage parallelism. Also leverage database partition for large tables (over 500,000 rows) which might benefit from spreading out the I/O to different partitions and different devices.
Use database compression for [...]

Over the last four months, we have examined in-depth the DB2 performance problems that might be found in a typical DB2 installation. My purpose in doing this was to show you how A methodical review can help you discover ways to reduce system costs. Good application review and positive changes can even save substantial investment [...]

Getting back to one of the client’s main tables, we then researched the SQL that was being executed against it on a daily basis by analyzing the DB2 access methods.  The DB2 access methods are captured at compile and bind time through the Explain process. Its output is available in the Plan_Table.  By joining the [...]

Another place to look for performance results is to research the use of compression.
Using DB2 Compression
Researching another aspect of one of the main tables showed that the table was not leveraging DB2 compression.  Since it has almost a million rows, a long record length and was probably referenced more for retrieval than update or insert [...]