To download a recorded replay of Episode #18, right click on the link below and choose "Save As..."
Episode 18, 2010 May 7, The Top 10 DB2 LUW Mistakes that People Make with Klaas Brant, KBCE
During this show, we talked about a SQL Snapshot command that would generate REORG commands for tables that need to be reorganized WITHOUT having to run the REORGCHK utility. Please watch this show replay so that you fully understand the problems with REORGCHK and why this SQL Snapshot may be a much better choice for your organization!
Here is the SQL Snapshot Command:
select ‘REORG TABLE ’ || TABSCHEMA || ‘.’ || TABNAME || ‘ INPLACE ALLOW WRITE ACCESS;’
where (ROWS_READ > 999)
AND (((OVERFLOW_ACCESSES * 100) / (ROWS_READ + 1) > 3)
You can modify this to run offline REORGS if you prefer. If you do online REORGS, remember to reorganize indexes as a second, separate step. Why did IBM make index REORGS a separate step? Good question.
During the show we also reminded people to REORG some of the DB2 Catalog Tables. We focus on our database tables but often forget basic maintenance to the DB2 Catalog. There are 3 tables in particular that you should pay attention to and REORG as necessary! Watch the show!
Join The DB2Night Show™ LinkedIn GroupThe DB2Night Show™ now has a LinkedIn Group. The group is an open group. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!
Our Shameless Marketing MomentDuring this show, we shared a customer success story. You'll see how a DBI customer measurably improved database transaction response times and substantially reduced database processing costs in just a few days.
DBI's comprehensive performance and configuration repository with the industry's best trend graphs enable you to monitor and manage your databases with confidence, improve stability, and achieve scalability with existing hardware. Hint: Use our performance trend charts on your next performance review to earn high praise from management.