Executing Sysview for Db2 NSIGHTRW with multiple requests as input and receive message DBG70013W.
search cancel

Executing Sysview for Db2 NSIGHTRW with multiple requests as input and receive message DBG70013W.

book

Article ID: 36126

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Executing the Sysview for Db2 for z/OS (IDB2) Report Writer program (NSIGHTRW) and specifying multiple
Requests (EG: ARCIACS, ARCISTS, ARCISTSB) for DBGIN DD the job encounters the warning message:

DBG70013W  RECORDS ENCOUNTERED OUT OF CHRONOLOGICAL ORDER

The DB2DDN Archive GDG inputs are specified in the order they were archived.
Also, the warning message does not occur when only one Request is specified.

Resolution

Performing a sort (prior to the NSIGHTRW step) using the SMFSORT job found in hlq.SOURCE library will alleviate
the DBG70013W Out of Chronological Order condition.  The sort process will take the multiple GDG files and sort them
into one GDG file using exits that perform a more granular sort using the STCK value in the data.  
This will allow the NSIGHTRW job to run without impact with multiple requests.  

Powered by Wolken Software