PI73851: STATISTICS TABLE(ALL) KEYWORD INCORRECTLY ADDED FOR SOME TABLES IN GENERATED LOADCARD CONTROL FILE IN DB2 OFFLOAD JOB CQM@LDB2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following issues are addressed:
  
  1. When specifying RESUME on the CQMLOADP input file, the
  STATISTICS TABLE(ALL) keyword is being incorrectly added for
  some tables in the generated LOADCARD control file.
  2. Offload --- Column DB2_GROUP_NAME is filled with incorrect
  data from tables EXCP_TEXT and SQLCODE_TEXT when load sql text
  > 32K .
  3. Incorrect DB2 version for DB2 V12 in offload table INTERVAL
  in columns DB2_VERSION and DB2_VERSION_LONG.
  

Local fix

• Edit the generated LOADCARD file and remove the incorrect
  STATISTICS TABLE(ALL) keyword.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following issues are addressed:     *
  *                      1. When specifying RESUME on the        *
  *                       CQMLOADP input file, the STATISTICS    *
  *                       TABLE(ALL) keyword is being            *
  *                       incorrectly added for some tables in   *
  *                       the generated LOADCARD control file.   *
  *                      2. Offload --- Column DB2_GROUP_NAME    *
  *                       is filled with incorrect data from     *
  *                       tables EXCP_TEXT and SQLCODE_TEXT      *
  *                       when load sql text > 32K .             *
  *                      3. Incorrect DB2 version for DB2 V12    *
  *                       in offload table INTERVAL in columns   *
  *                       DB2_VERSION and DB2_VERSION_LONG.      *
  ****************************************************************
  * 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:

  UI44200

Modules/Macros

• CQM@ITXT CQM@WDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI44200

     UP17/01/30 P F701

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.