Current activity - line commands (ISPF)

Use the line commands that are available on the various current activity panels to display more information about an activity.

Current SQL activity - line commands

The following line commands are valid on the Current SQL Activity panel:

9. O - Objects
Show object information.
12. C - Calls
Show statistics for SQL calls.
16. S - SQL
Show 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
Show delay events, counts, and delay times.
20. L - Locks
Show lock events and counts.
21. Q - Misc Stats
Show additional statistics.
22. B - Buffer Pool Stats
Show buffer pool usage statistics.
28. P - Parallel Activity
Show parallel activity information.
37. H - Host Variables
Show host variable information.
38. E - Cancel
Cancels the thread executing an SQL statement.
40. SF - Formatted SQL
Shows 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 SQL statement.
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 SQL statement.
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 SQL statement.
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

The following line commands are valid for the Call Level Statistics panel:

16. S - Call Text
Show the call text.
19. D - Delays
Show delay events, counts, and delay times.
20. L - Locks
Show lock events and counts.
21. Q - Misc Stats
Show additional statistics.
22. B - Buffer Pool Stats
Show buffer pool usage statistics.
37. H - Host Variables
Show host variable information.
39. C - SQLCA
Show the SQL communication area for the selected line item. If an SQL statement has not yet completed, the SQLCA displays initial values because Db2 has not yet updated the SQLCA for that statement.
40. SF - Call Text Format
Show the formatted call text.

Parallel task statistics - line commands

The following line commands are valid for the Parallel Task Statistics panel:

9. O - Objects
Show objects information.
12. C - Calls
Show statistics for SQL calls.
19. D - Delays
Show delay events, counts, and delay times.
20. L - Locks
Show lock events and counts.
21. Q - Misc Statistics
Show additional statistics.
22. B - Buffers Pool Stats
Show buffer pool usage statistics.
38. E - Cancel
Cancel the thread that is executing the SQL statement.