Posted on 9/24/2012
 | Special Guest: Steve Rees, Performance Specialist, IBM CanadaTop DB2 LUW Performance FAQs, Part 2100% 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 CommentarySteve 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 GroupThe DB2Night Show™ has a LinkedIn Group. The "closed " group is open to any LinkedIn member. Join to receive LinkedIn group updates includingfuture 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:
DBI SoftwareDuring 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! DBI is Your Trusted Partner
for Breakthrough DB2 Performance Solutions
that Deliver Invaluable Results
for Organizations having the most Demanding Requirements
and Discriminating PreferencesOur #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. Get the Download ReplaysWMV FormatTo 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 MP4 FormatHave an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format! BONUS MATERIAL!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: select
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
where p.routineschema=r.routineschema
and p.routinename=r.routinename
and p.specificname=r.specificname
and r.function_type='T'
and substr(r.ROUTINENAME,1,4) in ('SNAP','MON_','ENV_')
order by P.ROUTINESCHEMA,
P.ROUTINENAME,
P.SPECIFICNAME,
IN_OUT,
P.ORDINAL
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:
|