Posted on 11/5/2010
Useful SQL Snapshots and Catalog QueriesLearn 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 www.DB2NightShow.com!
To download a recorded replay of Episode #33, right click on the link below and choose "Save As... "
Episode 33, 5 November 2010, 2nd Annual SQL Snapshot Potluck Party. 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 MomentDBI is offering a free educational webinar "TEN SQL Snapshots you MUST run TODAY " on Friday, 21 January, 2pm Central (3pm Eastern, 1pm Mountain, 12pm Pacific, 8pm GMT). Attendees will receive the SOURCE CODE for the SQL Snapshots! For details and the registration link to this free event, visit DBI's EVENTS page. How do the DBI Performance Tools for DB2 LUW compare to IBM Optim Performance Manager? Watch this show and find out! Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs. |