PH61409: THE SUBSYSTEM CLONING DB2SCHEMA-UPDATE COMMAND ENDS WITH RC=8 AND CKZ28040E ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The subsystem cloning DB2SCHEMA-UPDATE command can end with RC=8
  and issue the following error message: "CKZ00900 UNEXPECTED
  RESULTS; TOO MANY VARIABLES RETURNED". The workaround is to
  remove the IGNORE-SQL-WARNINGS parameter from the JCL.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The subsystem cloning DB2SCHEMA-UPDATE  *
  *                      command might end with RC=8 and issue   *
  *                      the following error message: "CKZ00900  *
  *                      UNEXPECTED RESULTS; TOO MANY VARIABLES  *
  *                      RETURNED". The workaround is to remove  *
  *                      the IGNORE-SQL-WARNINGS parameter from  *
  *                      the JCL.                                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  The subsystem cloning DB2SCHEMA-UPDATE command might end with
  RC=8 and issue the following error message: "CKZ00900 UNEXPECTED
  RESULTS; TOO MANY VARIABLES RETURNED". The workaround is to
  remove the IGNORE-SQL-WARNINGS parameter from the JCL.
  

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

• CKZ00020 CKZ00111 CKZ00112 CKZ00113 CKZ00114 CKZ00280 CKZ00480
  CKZ00510 CKZ00560 CKZ00564 CKZ00567 CKZ00900 CKZ00902
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI97075

     UP24/05/31 P F405

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.