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

The DB2Night Show #33: 2nd Annual SQL Snapshot Potluck Party

Useful SQL Snapshots and Catalog Queries

Learn how DBAs in Croatia, France, and USA use SQL Snaps

In episode #33, Scott Hayes hosted The DB2Night Show's 2nd Annual SQL Snapshot Potluck Party. Members of the DB2 LUW community were invited to share their favorite SQL Snapshot commands that help them do their jobs well. Contributors will be receiving electronic copies of all SQL Snapshot commands submitted. Watch this episode and learn how your DB2 LUW peers:

  • "find log hogs and PIDs"
  • "monitor space utilization"
  • "learn intimate details about tables"
  • "monitor and resolve locks"
  • "avoid running reorgchk"
  • "find indexes that are harmful to ETL performance, cause lock problems, and burn up excessive CPU"
Also be sure to check out future scheduled episodes at!

[ more .. ]
by Scott in DB2 LUW
Page :  1