PH62339: APPLICATION CLONING SOURCE JOB WITH RECREATE-OBJECTS(M) CREATES DDL FOR AN EXISTING TARGET TABLE THAT DOES NOT REQUIRE RE-CREATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 application cloning source job with RECREATE-OBJECTS(M)
  might generate CREATE statements for an existing target table
  and its primary key that do not require re-creation. This might
  occur if a source or target table was created on Db2 v7 or
  earlier, or there are trailing spaces in the table creator or
  name.
  

Local fix

• Set RECREATE-OBJECTS to A or N or to completely disable DDL
  generation
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 application cloning source job with *
  *                      RECREATE-OBJECTS(M) might generate      *
  *                      CREATE statements for an existing       *
  *                      target table and its primary key that   *
  *                      do not require re-creation. This might  *
  *                      occur if a source or target table was   *
  *                      created on a Db2 v7 or earlier          *
  *                      subsystem, or if there are trailing     *
  *                      spaces in the table creator or name.    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Db2 application cloning source job with RECREATE-OBJECTS(M)
  might generate CREATE statements for an existing target table
  and its primary key that do not require re-creation. This might
  occur if a source or target table was created on a Db2 v7 or
  earlier subsystem, or if there are trailing spaces in the table
  creator or name.
  

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:

  UI98272

Modules/Macros

• CKZ00541
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI98272

     UP24/09/06 P F409

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.