PK63505: ADD A NEW PARM TO THE OFFLOAD PROGRAM CQM@WDB2 TO PREVENT DUPLICATE RECORDS FROM BEING LOADED IN THE DB2 OFFLOAD TABLES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• A new CQMLOADP parameter DISALLOW_DUPLICATE_INTERVAL is being
  added to SCQMSAMP member CQM@LDB2 to provide the capability of
  preventing duplicate records from being loaded in the DB2
  offload tables.  Specifying DISALLOW_DUPLICATE_INTERVAL(Y) will
  cause the offload program CQM@WDB2 to fail with a -803 SQL code
  if duplicate records are detected during the unload. The default
  for this parameter will be to continue normal processing.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: A new CQMLOADP parameter                *
  *                      DISALLOW_DUPLICATE_INTERVAL is being    *
  *                      added to SCQMSAMP member CQM@LDB2 to    *
  *                      provide the capability of preventing    *
  *                      duplicate records from being loaded in  *
  *                      the DB2 offload tables.  Specifying     *
  *                      DISALLOW_DUPLICATE_INTERVAL(Y) will     *
  *                      cause the offload program CQM@WDB2 to   *
  *                      fail with a -803 SQL code if duplicate  *
  *                      records are detected during the unload. *
  *                      The default for this parameter will be  *
  *                      to continue normal processing.          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UK38094 UK38095

Modules/Macros

•    CQM@ITXT CQM@WDB2 CQMCOMM
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK38094

     UP08/07/19 P F807

• R221 PSY UK38095

     UP08/07/19 P F807

• R230 PSY UK38096

     UP08/07/22 P F807

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.