PI94675: TREAT SQLCODE = 162 AS A WARNING AND NOT AS AN ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer has encountered a situation where the DDL generator
  added a referential constraint to an already existing and
  populated child table. Execution of this statement resulted in
  SQLCODE=162 (TABLE table name HAS BEEN PLACED IN CHECK PENDING).
  While this situation can indicate possible problems with cloned
  objects, it should not be treated as error.
  

Local fix

• Drop child table on target Db2 and clone it from source Db2
  along with its parent table.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Customer has encountered a situation    *
  *                      where the DDL generator added a         *
  *                      referential constraint to an already    *
  *                      existing and populated child table.     *
  *                      Execution of this statement resulted    *
  *                      in SQLCODE=162 (TABLE table name HAS    *
  *                      BEEN PLACED IN CHECK PENDING). While    *
  *                      this situation can indicate possible    *
  *                      problems with cloned objects, it        *
  *                      should not be treated as error.         *
  ****************************************************************
  * 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

•    CKZBTS
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI55393

     UP18/04/25 P F804

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.