Using the -DISPLAY THREAD(*) command to determine what DB2 is doing leaves a lot to be desired. DB2MON is a fast, low overhead and inexpensive way to do a better job. DB2MON can provide you with an interactive display of each active thread within your DB2 sub-system and what each thread is doing. DB2MON executes under TSO, uses the standard TSO terminal I/O macros and the standard DB2 Instrumentation Facility Interface (IFI). DB2MON is invoked via a TSO clist and will normally display information on your terminal. If you desire, it will optionally write the IFI data to a dataset for later analysis.
DB2MON was written to display the following information for each active thread, from IFCIDs 124, 148 and 150:
CONNECTION NAME, CORRELATION ID, AUTH ID, PLAN NAME, CPU TIME, I/O WAIT TIME, NUMBER OF GETPAGES, NUMBER OF SYNCRONOUS READS, NUMBER OF SEQUENTIAL PREFETCH READS, NUMBER OF PAGERS UPDATED, NUMBER OR LOCKS HELD, NUMBER OF SELECTS, NUMBER OF INSERTS, NUMBER OF UPDATES, NUMBER OF DELETES, NUMBER OF OPEN CURSORS, NUMBER OF CLOSE CURSORS, NUMBER OF FETCHES, the actual SQL commands being processed, the type of locks being held, EDM pool and buffer pool statistics plus various DSNZPARM values.
DB2MON is simple to use. There are no complex menus to traverse. Simply invoke its clist from any TSO session and return right where you left off. DBAs will use it to debug response time problems and check DSNZPARM settings. Programmers will use it to debug database lock contention as well as long running processes.
Call or email for more information. Free 30 day trial available.
SOFTRON-DB - email: firstname.lastname@example.org