Exceptions - line commands (ISPF)

Use the line commands on the exceptions panel to view more information about an exception.

Display exceptions - line commands

9. O - Objects
Display object information.
12. C - Calls
Display statistics for SQL calls.
16. S - SQL
Display individual SQL statements.
18. A - Analyze
Export SQL text to a data set member that can then be analyzed by IBM® Db2® SQL Performance Analyzer for z/OS®. When creating the export data set to hold the exported SQL text, Db2 Query Monitor uses your TSO PREFIX as the high-level qualifier for the data set. You can use your USERID as the high-level qualifier by setting your TSO PREFIX to null by issuing the command TSO PREFIX NOPREFIX from ISPF.
19. D - Delays
Display delay events, counts, and delay times.
20. L - Locks
Display lock events and counts.
21. Q - Misc Stats
Display additional statistics.
22. B - Buffer Pool Stats
Display buffer pool usage statistics.
28. P - Parallel Activity
Display parallel activity information.
37. H - Host Variables
Display host variable information.
40. SF - Formatted SQL
Display individual formatted SQL statement.
41. AP - ADB Plan
Launch Db2 Administration Tool by plan. Db2 Administration Tool displays the system catalog panel for the plan that is associated with the exception.
Tip: For the AP, AK, and AL line commands, you can specify the plan to use when invoking Db2 Administration Tool in the Db2 Admin Tool Plan Name field on the Query Monitor Dialog Options panel; see Setting ISPF dialog options. Otherwise, you will be prompted to enter the plan name after issuing the line command.
42. AK - ADB Program
Launch Db2 Administration Tool by program. Db2 Administration Tool displays the system catalog panel for the package that is associated with the exception.
43. AL - ADB Collid
Launch Db2 Administration Tool by collection ID. Db2 Administration Tool displays the system catalog panel for the collection ID that is associated with the exception.
49. AQ-ADB SP
Launch Db2 Administration Tool by stored procedure. Db2 Administration Tool displays the stored procedure catalog panel for the SSID.

Call level statistics - line commands

16. S - Call Text
Display the call text.
19. D - Delays
Display delay events, counts, and delay times.
20. L - Locks
Display lock events and counts.
21. Q - Misc Stat
Display additional statistics.
22. B - Buffer Pool Stats
Display buffer pool usage statistics.
37. H - Host Variables
Display host variable information. If no input host variables are present for the call or the monitoring profile stated not to collect them, one of the following messages is displayed:
  • CQM104I No host variables. Db2 Query Monitor found no input host variables present for this call or the monitoring profile stated not to collect them.
  • CQM103I Host variables not gathered. Db2 Query Monitor does not collect host variables for this call type.
39. C - SQLCA
Display the SQL communication area.
40. SF - Call Text Format
Display the formatted call text