Activity summaries - fields (ISPF)
The fields at the top of the activity summary panels show information about the selected interval and the navigational sequence you took to view the data.
- QM Subsystem / DB2 DS Group
- The active Query Monitor Subsystem ID or data sharing group.
- Interval Start Date / Time
- The date (MM/DD/YYYY) and time (HH:MM:SS) that the displayed interval started.
- Interval End Date / Time
- The date (MM/DD/YYYY) and time (HH:MM:SS) that the displayed interval ended. A value of CURRENT denotes the display interval has not yet ended.
- Filters Enabled
- Indicates whether or not filters are enabled for the display.
- NAVI
- The navigational path used to access the panel. The path might
include the following:
- Accel
- The name of the accelerator where the SQL activity ran.
- Authid
- The Db2 authorization ID.
- Bufpool
- The bufferpool name.
- Call
- The SQL call.
- Collection
- The collection ID.
- ConnName
- The connection name.
- ConnType
- The connection type.
- ConToken
- The connection token.
- CorrID
- The correlation ID.
- CorrName
- The correlation ID adjusted by conventions used by IMS and CICS®.
- CorrNum
- The correlation number.
- Db2
- The Db2 subsystem on which the displayed activity occurred.
- DBname
- The database name.
- Jobname
- The job name.
- Pageset
- The pageset name.
- Parallel
- Indicates whether or not the query was formulated using Db2 query parallelism.
- Plan
- The plan name.
- Pgm
- The name of the program.
- Schema
- The current schema.
- Section
- The section.
- SP_Creat
- The creator of the stored procedure.
- SP_Name
- The name of the stored procedure.
- Stmt_Type
- The SQL call type (such as PREPARE, OPEN, etc.).
- TBCreator
- The table creator.
- TBName
- The table name.
- WSName
- The name of the workstation.
- WSTran
- The workstation transaction.
- WSUser
- The workstation user ID.