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

The DB2Night Show #91: Top DB2 LUW Performance FAQs with Steve Rees, Part 2

September 23, 2012, 10:33 pm
Posted by Scott in DB2 LUW
Steve Rees, IBM

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:
DBI Software

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!

DBI is Your Trusted Partner
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!

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

Get the Download Replays

WMV Format

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

MP4 Format

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:

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_')

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:

Printer friendly