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.
Start of change40. SF - Formatted SQLEnd of change
Start of changeShows individual formatted SQL statement.End of change
Start of change41. AP - ADB Plan End of change
Start of changeLaunch 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.
End of change
Start of change42. AK - ADB ProgramEnd of change
Start of changeLaunch Db2 Administration Tool by program. Db2 Administration Tool displays the system catalog panel for the package that is associated with the SQL statement. End of change
Start of change43. AL - ADB CollidEnd of change
Start of changeLaunch 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. End of change

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.
Start of change40. SF - Call Text FormatEnd of change
Start of changeShow the formatted call text.End of change

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.