DB2 LUW 11.1 product documentation available in PDF format

For a period of time the DB2 LUW 11.1 documentation was only available online. The good news is it's now available in PDF format and can be downloaded to read through . To download the documentation visit the Db2 Version 11.1 for Linux, UNIX, and Windows English Manuals Read more →

DB2 Archived Log Compression

Question: Can I compress DB2 LUW archived logs? How can I configure a DB2 database to apply compression to the archived logs automatically? Answer: It is possible to configure a DB2 LUW database to compress Archived Logs. The two primary database configurables are to use Primary log archive compression (logarchcompr1) and secondary log archive compression (logarchcompr2). By simply changing the default value of NO to YES , does not automatically mean there will be archival logging compression. LOGARCHMETH1 must be set to either DISK, TSM, or VENDOR. If these values are not used there will be no compression of archivedlog... Read more →

DB2 Archived Log Compression

Question: Can I compress DB2 LUW archived logs? How can I configure a DB2 database to apply compression to the archived logs automatically? Answer: It is possible to configure a DB2 LUW database to compress Archived Logs. The two primary database configurables are to use Primary log archive compression (logarchcompr1) and secondary log archive compression (logarchcompr2). By simply changing the default value of NO to YES , does not automatically mean there will be archival logging compression. LOGARCHMETH1 must be set to either DISK, TSM, or VENDOR. If these values are not used there will be no compression of archivedlog... Read more →

How to troubleshoot DB2 lock waits

Monitoring lock waits is a great way of measuring query performance slowdown. Lock waits are a normal part query processing but when the lock waits start taking longer than normal , it’s a sign of trouble. According to the DB2 LUW documentation a lock wait is defined as “A lock wait occurs when one transaction (composed of one or more SQL statements) tries to acquire a lock whose mode conflicts with a lock held by another transaction” Common symptoms of lock waits taking longer than normal are: Applications are not completing tasks SQL query performance slowdown Lock escalations. A small... Read more →

Database Self-Tuning

To get my head back into gear and focused for the New Year , I want to outline some notes on the topic of Database Self Tuning. Database Tuning is all about ensuring service level agreements being met . Database tuning is essential as data sets get bigger with increasing a larger set of access paths to the data. Following on from my blog post – The future of the SQL Server Performance Tuning Expert , I’ve compiled some notes on Database Self Tuning Focus is on two aspects 1) What is the current state of Database Self Tuning? 2)... Read more →