Archive for February, 2009

25 Feb

DB2 Performance Summary Part 2

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 [...]

18 Feb

DB2 Performance Summary Part 1

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 [...]

12 Feb

Discovering DB2 Access

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 [...]

05 Feb

Effects of Compression on DB2 Performance

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 [...]

© 2010 Dave Beulke

Designed by NET-TEC Webspace -- Made free by Einladungskarten | Wintergarten | Ratenkredit
SEO Powered by Platinum SEO from Techblissonline