Activity summaries - line commands (ISPF)

The line commands that are available on the activity summary panels allow you to refine your view of query information. The line commands that are available vary based on your drill-down path.

1. P - Plan
Display the plans for the SQL activity.
2. 2 - DB2 (Op)
Display the Db2 subsystems for the SQL activity (operational summaries).
3. R - Pgm
Display the programs for the SQL activity.
4. U - Auth
Display the Db2authorization IDs for the SQL activity.
5. 5 - DB2 (St)
Display the Db2subsystems for the SQL activity (structural summaries).
6. J - DBase
Display the databases for the SQL activity.
7. F - Buff
Display the buffer pools for the SQL activity.
8. G - PSet
Display the page sets for the SQL activity.
9. O - Objs
Display the objects for the SQL activity.
10. I - Corr
Display the correlation IDs for the SQL activity.
11. T - Sect
Display the sections for the SQL activity.
12. C - Call
Display the SQL calls for the SQL activity.
13. W - WSUs
Display the workstation user ID for the SQL activity.
14. M - WSNm
Display the workstation name for the SQL activity.
15. N - WSTr
Display the workstation transaction for the SQL activity.
16. S - SQL
Display the individual SQL statements for the SQL activity.
17. V - View
View the SQLCODE messages for the SQL activity.
18. PA - Analyze
Analyze the SQL statement.
19. D - Delay
Display a list of delay events, delay counts, and delay times for the SQL activity.
20. L - Lock
Display a list of lock events and lock counts for the SQL activity.
21. Q - Misc
Display additional statistics for the SQL activity.
22. B - BStat
Display buffer pool usage statistics for the SQL activity.
23. E - Excp
Display exception information for the SQL activity.
24. A - CAct
Display current SQL activity information.
25. Z - Accel
Display the name of the accelerator where the SQL activity ran. For more information, see Displaying IBM Db2 Analytics Accelerator for z/OS information.
26. CL - Collection
Display the collection ID for the SQL activity.
27. JN - Jobname
Display the job name for the SQL activity.
28. PR - Parallel
Display whether or not the SQL activity was formulated using Db2 query parallelism.
29. K - ConnName
Display the connection name for the SQL activity.
30. Y - ConnType
Display the connection type for the SQL activity.
31. SC-Schema
Display the current schema for the SQL activity.
32. CN - CorrNum
Display the correlation number for the SQL activity.
33. SP - StoredProc
Display the name of the stored procedures for the SQL activity.
34. CT - ConToken
Display the connection token for the SQL activity.
35. CR - CorrName
Display the correlation ID adjusted by conventions used by IMS and CICS for the SQL activity.
36. X - Usage
Display the usage for the SQL activity.
Start of change40. VF - ViewFormatEnd of change
Start of changeView the full formatted SQL statement.End of change
Start of change41. AP - ADB PlanEnd of change
Start of changeLaunch Db2 Admin Tool by plan.End of change
Start of change 42. AK - ADB ProgramEnd of change
Start of changeLaunch Db2 Admin Tool by program.End of change
Start of change43. AL - ADB CollidEnd of change
Start of changeLaunch Db2 Admin Tool by collection ID.End of change
Start of change44. AD - ADB DatabaseEnd of change
Start of changeLaunch Db2 Admin Tool by database name.End of change
Start of change45. AS - ADB SpaceEnd of change
Start of changeLaunch Db2 Admin Tool by table space or index space name.End of change
Start of change46. AO-ADB ObjectEnd of change
Start of changeLaunch Db2 Admin Tool by object (table or index) name.End of change