Special Guest: Steve Rees, Performance Specialist, IBM Canada
Top DB2 LUW Performance FAQs, Part 2
100% of our studio audience learned something! Steve talked about monitor table functions and admin views, strange numbers in the monitors, literals versus parameter markers in dynamic SQL, the Statement Concentrator (STMT_CONC) - when to use it and when not to use it, improving performance of LOBs, temporary tables, virtualizing DB2 workloads, tips for large partitions, and much more!!! Watch and learn...
Show Host Scott Hayes Commentary
Steve Rees has been with IBM for over 22 years and has worked on DB2 for LUW performance for the past 15 of those years. I was taking notes as fast as I could, and I'll be watching this replay! You can't watch this replay and NOT learn something! I was particularly impressed by discussion of monreport.dbsummary, monreport.pkgcache, monreport.currentsql, monreport.connection, monreport.lockwait, and monreport.currentapps. Also, Steve's insights on when to use, and when NOT to use, the DB2 Statement Concentrator (STMT_CONC) were quite insightful.
Join The DB2Night Show™ LinkedIn Group
The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. 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!
The Corporate Sponsor of The DB2Night Show:
During DBI's quick sponsor commercial break, DBI ran this short, 3 minute video and we received LOTS of positive feedback! Can't see the flash video? Watch it on YouTube!
for Breakthrough DB2 Performance Solutions
that Deliver Invaluable Results
for Organizations having the most Demanding Requirements
and Discriminating Preferences
Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!
Get the Download Replays
To download a recorded replay of Episode #91 in WMV format, right click on
the link below and choose "Save As..."
Episode #91, 21 September 2012, DB2 LUW Performance FAQs, Part 2, with Steve Rees, IBM
Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!
During the show, Steve shared with us his "magic" SQL for listing all of the available monitor table functions and administrative views from DB2's catalog. Here's the SQL:
substr(P.ROUTINENAME,1,32) as ROUTINENAME,
substr(P.SPECIFICNAME,1,32) as SPECIFICNAME,
case when P.ROWTYPE in ('B','O','P') then CHAR('IN',3)
else CHAR('OUT',3) end as IN_OUT,
cast(p.ORDINAL as char(3)) as ORD,
substr(P.PARMNAME,1,40) as PARMNAME,
substr(P.TYPENAME,1,16) as TYPE
from sysibm.sysroutines r, sysibm.sysroutineparms p
and substr(r.ROUTINENAME,1,4) in ('SNAP','MON_','ENV_')
order by P.ROUTINESCHEMA,
Did you learn something from this show?See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS!
Share a great show with your friends and followers: