When I run NSIGHTRW with multiple Requests as input I get message DBG70013W. What should I do to resolve this?

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Problem: 

Running the Insight Report Writer program (NSIGHTRW), and specifying multiple Requests (EG: ARCIACS, ARCISTS, ARCISTSB) for my DBGIN DD the job encounters the warning message:

DBG70013W  RECORDS ENCOUNTERED OUT OF CHRONOLOGICAL ORDER

My 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 new SMFSORT job found in the Insight r17 or later .SOURCE library will alleviate the DBG70013W Out of Chronological Order condition.  The new 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.  

Environment

Release:
Component: CIDB