ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 52741

calendar_today

Updated On:

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 Fast Load 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
Powered by Wolken Software