PI75873: OBJECT-TRANSLATE FOR DATABASE AND TABLESPACE DOES NOT WORK PROPERLY IF NAME IS LESS THAN 8 CHARACTERS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If source database name or tablespace name is less than 8
  characters and user uses OBJECT-TRANSLATE for DATABASE and
  TABLESPACE with wildcards, e.g.
  .
  OBJECT-TRANSLATE(                -
        DATABASE,C2999DB%,C2999DB% -
  )                                -
  .
  or
  .
  OBJECT-TRANSLATE(                -
      TABLESPACE,C2999TS%,C2999TS% -
  )
  .             -
  DB2 Cloning Tool may translate names incorrectly and issue
  messages like these:
  .
  CKZ54701W Target SS AA1A, Object Not in DB2 Catalog, TS
  C2999DB.C2999TS, can Not be Copied per Parms
  CKZ54701W Target SS AA1A, Object Not in DB2 Catalog, TS
  C2999DB.C2999TS, can Not be Copied per Parms
  .
  That is, the wildcard '%' is replaced by space after
  OBJECT-TRANSLATE.
  

Local fix

• If source database name or tablespace name is less than 8
  Currently if source database name or tablespace name is less
  than 8 characters then user should use translation without
  wildcards, e.g.
  DATABASE,C2999DB,C2999DB instead of DATABASE,C2999DB%,C2999DB%
  TABLESPACE,C2999TS,C2999TS instead of
  TABLESPACE,C2999TS%,C2999TS%
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: If source database name or tablespace   *
  *                      name is less than 8 characters and user *
  *                      uses OBJECT-TRANSLATE for DATABASE and  *
  *                      TABLESPACE with wildcards, e.g.         *
  *                      OBJECT-TRANSLATE(                -      *
  *                            DATABASE,C2999DB%,C2999DB% -      *
  *                      )                                -      *
  *                      or                                      *
  *                      OBJECT-TRANSLATE(                -      *
  *                          TABLESPACE,C2999TS%,C2999TS% -      *
  *                      )                                       *
  *                      .             -                         *
  *                      DB2 Cloning Tool may translate names    *
  *                      incorrectly and issue messages like     *
  *                      these:                                  *
  *                      CKZ54701W Target SS AA1A, Object Not    *
  *                       in DB2 Catalog, TS                     *
  *                      C2999DB.C2999TS, can Not be Copied per  *
  *                       Parms                                  *
  *                      CKZ54701W Target SS AA1A, Object Not    *
  *                       in DB2 Catalog, TS                     *
  *                      C2999DB.C2999TS, can Not be Copied per  *
  *                       Parms                                  *
  *                      That is, the wildcard '%' is replaced   *
  *                      by space after OBJECT-TRANSLATE.        *
  ****************************************************************
  * 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:

  UI45688

Modules/Macros

•    CKZ00569
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI45688

     UP17/03/23 P F703

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.