Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #18: The Top 10 DB2 LUW Mistakes People Make, Klaas Brant

May 7, 2010, 6:28 pm
Posted by Scott in DB2 LUW
In our 18th show, Klaas Brant, IBM DB2 GOLD Consultant and Owner KBCE, Netherlands, shared with us his Top 10 DB2 LUW Mistakes that People Make. I think it was one of our best shows ever! The discussion was lively, and many tips were shared during the conversation! Are you making any of the Top 10 Mistakes? Watch this episode and find out...
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;’
from sysibmadm.snaptab
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! icon_biggrin

Join The DB2Night Show™ LinkedIn Group

The 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 Moment

During 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. icon_wink

Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

Printer friendly