Why a Sysview for Db2 hierarchical probe requests paused
search cancel

Why a Sysview for Db2 hierarchical probe requests paused

book

Article ID: 108918

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

While running a Sysview Performance Management Option for Db2 for z/OS (IDB2) hierarchical probe request receiving the following message:

DBG04005I 11:01:45 PAUSE SUCCESSFUL FOR REQUEST HPRSTLST.

There are same message for other requests. How to run the probe to completion?

Resolution

Assuming the PAUSE has nothing to do with the TIME and DURATION, this what needs to be done to keep the traces running longer:

1-Increase the NEVENTS value and specifying NOWRAP=NO in the HPRSTDTL, HPRSTLST and HPRSTSML requests in hlq.CDBATREQ library.
The max value for NEVENTS is 65535. The changes to the above requests will require you to
increase the address space region size for the data collector to all for the increase storage usage.

2-Issue the SHOW display in DIAGNOSTIC mode to see how much storage each started request is using.

Also, if the probe is paused due to time or records, there should be the DBGPRINT telling why the requests were paused.