Use the Db2 Key Performance Indicators panel (KDPKPI1) to view key
information about thread related Key Performance Indicators (KPIs) for a Db2 subsystem including
connections, transactions, and locking KPIs.
Procedure
-
Select the Db2 tab on the OMEGAMON Products panel
to show the All Active Db2 Subsystems workspace.
- Type a / in the line command field next to the Db2 subsystem of interest and press
Enter.
- In the option menu, select option 8 (K Key Performance Indicators)
and press Enter.
The
DB2 Key Performance Indicators panel
(KDPKPI1) shows the following tabs:
- Thread KPI (KDPKPI1)
- View information about thread related Key Performance Indicators (KPIs) for a Db2 subsystem
including connections, transactions, and locking KPIs.
- Pools & Storage KPI (KDPKPI2)
- View information about pool and storage related KPIs for a Db2 subsystem including Db2
pools, storage, buffer pools, sorting and group buffer pools KPIs.
- Miscellaneous KPI (KDPKPI3)
- View statistics about miscellaneous KPIs for a Db2 subsystem including monitoring, logging,
stored procedures, user defined functions, and query parallelism KPIs.
- System States (KDPKPI4)
- View statistics about Db2 system and thread related performance data including thread,
stored procedures, user defined functions, triggers, locks, and open data sets.