PH64558: DB2SCHEMA-UPDATE COMMAND IGNORES OBJECTS WITH TRAILING SPACES IN SCHEMA NAMES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The subsystem cloning DB2SCHEMA-UPDATE command does not generate
  DROP and CREATE statements and does not call Db2 CATMAINT
  utility for objects that have trailing spaces in their schema
  name.
  

Local fix

• Specify a percent sign at the end of the affected schema names
  in the SCHEMA-MASKS keyword
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The subsystem cloning DB2SCHEMA-UPDATE  *
  *                      command does not generate DROP and      *
  *                      CREATE statements and does not call Db2 *
  *                      CATMAINT utility for objects that have  *
  *                      trailing spaces in their schema name.   *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  The subsystem cloning DB2SCHEMA-UPDATE command does not generate
  DROP and CREATE statements and does not call Db2 CATMAINT
  utility for objects that have trailing spaces in their schema
  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:

Modules/Macros

• CKZ00281 CKZ00600 CKZCALNC CKZCAQNC CKZCCTNC CKZCDTNC CKZCFNNC
  CKZCIXNC CKZCMTNC CKZCSNNC CKZCSPNC CKZCSQNC CKZCTBNC CKZCTRNC
  CKZCVANC CKZCVTNC
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI99846

     UP25/02/04 P F502

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.