The customer would like to run a variety of different Accounting reports using the NSIGHTRW job for 1 plan. How can this be accomplished?

Products

• RC Compare for DB2 for z/OS
• 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
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

This document describes how the customer can run a variety of different Accounting reports using the NSIGHTRW job for 1 plan.

Solution:

You can run a number of different Accounting reports for 1 Plan in your NSIGHTRW job by doing the following:

1. If the DBGIN DD statement in your NSIGHTRW job currently points to a dataset(s) like in the case below:
   
   //DBGIN DD DISP=SHR,DSN=Your.Qualifier.TGTREQ(BTACTSML)
   // DD DISP=SHR,DSN=Your.Qualifier.TGTREQ(BTACTSMS)
   // DD DISP=SHR,DSN=Your.Qualifier.TGTREQ(BTACTTRL)
   
   
2. Change your DBGIN statement to accept instream data:
   
   //DBGIN DD *
   
   
3. Add a GLOBALS statement, followed by a WHERE statement specifying the name of the Plan you want to generate Accounting reports for:
   
   GLOBALS
   WHERE PLAN-NAME = 'PLAN1'
   
   
4. Lastly, concatenate your Accounting report IQL members into your DBGIN stream. The end result should appear as follows:
   
   //DBGIN DD *
   GLOBALS
   WHERE PLAN-NAME = 'PLAN1'
   ;
   
   // DD DISP=SHR,DSN=Your.Qualifier.TGTREQ(BTACTSML)
   // DD DISP=SHR,DSN=Your.Qualifier.TGTREQ(BTACTSMS)
   // DD DISP=SHR,DSN=Your.Qualifier.TGTREQ(BTACTTRL)

Environment

Release:
Component: IDB2