PI23322: BIND JOB GENERATED IN TCZ CUSTOMIZATION FOR THE BATCH REPORTS RECEIVES ERROR MESSAGE DSNT230I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Bind job generated in TCZ customization for the batch reports
  receives error messages DSNT230I ...BIND DBRM-MEMBER-NAME
  ERROR... MEMBER name NOT FOUND IN PDS SEARCH ORDER.
  
  This APAR addresses the following:
  
  1. Incorrect package names generated in job CQMRBIAA, which
  performs the bind for the batch reports (for example: BIND
  PACKAGEs = CQMDBT31, 32, 33, 34, 35, 36, 37 ).
  
  2. Incorrect program names generated in job CQMVRUAA, which
  creates the 7 batch report members (for example: PGM = CQMDBT31,
  32, 33, 34, 35, 36, 37).
  

Local fix

• Customers will need to update 2 jobs.
  1. In TCz, job CQMRBIAA (which performs the Bind for the batch
     reports):
   .
   Where the member names referenced in the BIND PACKAGEs =
   CQMDBT31, 32, 33, 34, 35, 36, 37, these values should be
   replaced with the following value(s) respectively:
    .
    CQMDSC - Dynamic SQL CPU (replace CQMDBT31)
    CQMDSE - Dynamic SQL Elapsed (replace CQMDBT32)
    CQMDSG - Dynamic SQL Getpages (replace CQMDBT33)
    CQMSSC - Static SQL CPU (replace CQMDBT34)
    CQMSSE - Static SQL Elapsed (replace CQMDBT35)
    CQMSSG - Static SQL Getpages (replace CQMDBT36)
    CQMSSO - Summary of Objects (replace CQMDBT37)
    .
   NOTE: The bind job should point to the SCQMDBRM library.
  .
  2) In TCz, job CQMVRUAA (which is the job that creates the 7
     batch report members):
   .
   Change the PGM= from CQMDBT31 to CQMDSC respectively (see
   above).
   .
   NOTE: The report job should point to the SCQMLOAD library where
         the CQMxxx programs are found.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Bind job generated in TCZ customization *
  *                      for the batch reports receives error    *
  *                      messages DSNT230I ...BIND               *
  *                      DBRM-MEMBER-NAME ERROR... MEMBER name   *
  *                      NOT FOUND IN PDS SEARCH ORDER.          *
  *                      This APAR addresses the following:      *
  *                      1. Incorrect package names generated    *
  *                      in job CQMRBIAA, which performs the     *
  *                      bind for the batch reports (for         *
  *                      example: BIND PACKAGEs = CQMDBT31, 32,  *
  *                      33, 34, 35, 36, 37 ).                   *
  *                      2. Incorrect program names generated    *
  *                      in job CQMVRUAA, which creates the 7    *
  *                      batch report members (for example:      *
  *                      PGM = CQMDBT31, 32, 33, 34, 35, 36,     *
  *                      37).                                    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI20927

Modules/Macros

• CQM@NRPB CQM@NRPT CQMRBIND CQMVRUN
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI20927

     UP14/09/04 P F409

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.