PK69018: DB2 OBJECT COMPARE DDL SOURCE OR TARGET INPUT DOES NOT USE THE CCSID DEFAULT VALUE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Compare DDL source or target input does not use the
  CCSID default value.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Admin & Object Comparison Tool *
  *                 who performs compare  between a DDL file and *
  *                 catalog  extract with  source DDL tablespace *
  *                 without CCSID attribute.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When source(DDL file) having tablespac  *
  *                      without  CCSID  attribute  is  compare  *
  *                      against  target DB2  catalog with  sam  *
  *                      tablespace having CCSID EBCDIC, result  *
  *                      change in encoding_scheme erro r in th  *
  *                      ompare report (E) Attempted  change  o  *
  *                      field ENCODING SCHEME is not supported  *
  *                      Change ignored.                         *
  *                                                              *
  *                      This is due to DTC not setting default  *
  *                      encoding  scheme  as EBCDIC ('E') when  *
  *                      CCSID attribute not specified in        *
  *                      tablespaces.                            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Changes are done in DTC to  initialize default encoding scheme
  as 'E',irrespective of CCSID specified in tablespaces or not.
  

Problem conclusion

• The problem has been fixed in V7.2 only.
  

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

•    ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK40537

     UP08/10/16 P F810

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.