Sysview for Db2 option to list selective intervals
search cancel

Sysview for Db2 option to list selective intervals

book

Article ID: 97237

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

In Sysview Performance Management Option for Db2 for z/OS (IDB2), there is an option to list the time intervals in 30 minutes to view the metrics,
however for active session; the snapshot shows the metrics for only 30 Seconds. Is there any option to look at the metrics for the interval that
was not part of history interval? Looking for the active time, since the snapshot provides for 30 seconds. It takes 30 Min to add to history intervals. 
Looking for an option to list the data from the end of history interval to the current time like in Detector for Db2 for z/OS (PDT).
Otherwise we have to wait for 30 Min to get the Metrics.

Resolution

IDB2 cannot do exactly what is being asked, but lowering the HISTORY-STATS-TIME value from 30 minutes to some value that makes more sense
for the current need would provide the desired outcome. HISTORY-STATS-TIME default value of 30 minutes can be reduced from 30 to as low as 1 minute.