PI99144: DB2UPDATE IS USED TO RENAME STORAGE GRPS WITH TRAILING SPACES IN ITS NAME, COMMAND ENDS WITH RC=8 AND CKZ22460E MSG IS ISSUED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If the source Db2 subsystem has a storage group with trailing
  spaces in its name, and this storage group is renamed during
  the clone using the STOGROUPS keyword in the DB2UPDATE command,
  DB2UPDATE might end with RC=8 and issue message CKZ22460E.
  With this fix applied, storage groups with trailing spaces in
  their names can be successfully renamed using the DB2UPDATE
  command if the source and target storage group names have the
  same length (excluding trailing spaces).
  

Local fix

• Specify a target stogroup name with the same length as the
  source stogroup name, including trailing spaces.
  If this suggestion does not help, remove the rule for the
  offending source storage group from the STOGROUPS keyword.
  Db2 Cloning Tool will still perform VCAT and VOLSERs
  translation for this storage group, so it will be usable at
  the completion of the process.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
   ***************************************************************
  * PROBLEM DESCRIPTION: If the source Db2 subsystem has a       *
  *                      storage group with trailing spaces in   *
  *                      its name, and this storage group is     *
  *                      renamed during the clone using the      *
  *                      STOGROUPS keyword in the DB2UPDATE      *
  *                      command, DB2UPDATE might end with RC=8  *
  *                      and issue message CKZ22460E. With this  *
  *                      fix applied, storage groups with        *
  *                      trailing spaces in their names can be   *
  *                      successfully renamed using the          *
  *                      DB2UPDATE command if the source and     *
  *                      target storage group names have the     *
  *                      same length (excluding trailing         *
  *                      spaces).                                *
  ****************************************************************
  * 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:

  UI56640

Modules/Macros

•    CKZ00224 HCKZ320
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI56640

     UP18/06/19 P F806

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.