SYSVIEW Performance Management Option for DB2 for z/OS
Database Management for DB2 for z/OS - Performance Suite
Insight Performance Monitor for DB2 UDB for z/OS
Problem summary: low getpage and high CPU reported for
server threads – unable to identify a thread with this CPU time.
NOTE: the issue clears within 10 mins.
- Example emails below
- Attaching the Insight
Thread History data attached for the last 2 DB03 issues.
- DB2B group has had no
SERVERET alerts since Jan 2019. Now we have had several in the past
2 days, but no thread showing the high CPU.
Release : 19.0
Component : CA Insight Database Performance Monitor for DB for z/OS
is it possible to modify the IQL, leave it running and report the DC output with WTOs, when the high CPU will be reached again?
'WARN IQL D(N) GETPAGE=' TOT-GET (PF=N9)
'DB2 CPU =' DECL-CPU-DB2-TOTAL
* 'TOKEN=' THREAD-TOKEN (PF=N8)
* 'USER=' REC-ENDUSER-USERID (PF=A8)
* 'WKSTN=' REC-ENDUSER-WORKSTATION (PF=A16)
WHERE CONN-NAME='SERVER' AND
(DECL-CPU-DB2-TOTAL > 2 HOUR OR
TOT-GET > 1000000000 ) AND
OWNING-PROG-NAME(,6,1) NE 'FBSPMG'