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

Article Id: 52741
Status: Published
Updated On: 14-02-2018 06:43
Legacy Id: TEC504050
Products:
CA RC Compare for DB2 for z/OS , CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA Subsystem Analyzer for DB2 for z/OS , CA Database Analyzer for DB2 for z/OS , CA Fast Unload for DB2 for z/OS , CA Fast Check for DB2 for z/OS , CA Fast Index for DB2 for z/OS , CA Fast Load for DB2 for z/OS , CA 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