PI13491: ADD SYNTAX FOR LOAD WITH REPLACE STATISTICS TABLE(ALL) IN THE DB2OFFLOAD JOB FOR THE CQM32_SQLCODES REPOSITORY TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The LOAD with REPLACE STATISTICS TABLE(ALL) is correctly
  generated for all of the other DB2 repository tables except
  CQM32_SQLCODES and this APAR will correct the omitted syntax.
  
  Add syntax for LOAD with REPLACE STATISTICS TABLE(ALL) in the
  DB2 offload job for the CQM32_SQLCODES repository table.
  
  
  When LOAD(REPLACE,STATISTICS) is specified on the CQMLOADP input
  parameter file to CQM@WDB2, this generates the LOAD command
  syntax in the LOADCARD input file for the DB2 LOAD Utility with
  REPLACE STATISTICS TABLE(ALL).
  

Local fix

• The DB2 offload job steps can be separated into 2 jobs (CQM@WDB2
  as the 1st job, followed with the remaining steps as the 2nd
  job), and the LOADCARD input file for the DB2 LOAD utility can
  be edited to add REPLACE STATISTICS TABLE(ALL) for the
  CQM32_SQLCODES table, prior to executing the remaining job steps
  in the 2nd job.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The LOAD with REPLACE STATISTICS        *
  *                      TABLE(ALL) is correctly generated for   *
  *                      all of the other DB2 repository tables  *
  *                      except CQM32_SQLCODES and this APAR     *
  *                      will correct the omitted syntax. Add    *
  *                      syntax for LOAD with REPLACE            *
  *                      STATISTICS TABLE(ALL) in the DB2        *
  *                      offload job for the CQM32_SQLCODES      *
  *                      repository table.  When                 *
  *                      LOAD(REPLACE,STATISTICS) is specified   *
  *                      on the CQMLOADP input parameter file    *
  *                      to CQM@WDB2, this generates the LOAD    *
  *                      command syntax in the LOADCARD input    *
  *                      file for the DB2 LOAD Utility with      *
  *                      REPLACE STATISTICS TABLE(ALL).          *
  ****************************************************************
  * 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:

Modules/Macros

• CQM@WDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R310 PSY UI17246

     UP14/04/26 P F404

• R320 PSY UI17247

     UP14/04/26 P F404

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.