PI82330: CONVERSION OF TABLESPACE FROM EBCDIC TO UNICODE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• CONVERSION OF TABLESPACE FROM EBCDIC TO UNICODE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool             *
  *                 for z/OS that use the ALT table              *
  *                 space and ALT table functions.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: ALT/TS path does not check for          *
  *                      RI relationship and issue a warning     *
  *                      message when the CCSID attribute        *
  *                      is changed on panel 'Redefine           *
  *                      Table Space' (ADB21SAR).                *
  *                                                              *
  *                      In addition, in the ALT Table           *
  *                      function, changing the CCSID            *
  *                      attribute for a column that is part     *
  *                      of a key in a referential constraint    *
  *                      results in SQLCODE = -873.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ALT/TS path does not check for RI relationship and issue
  a warning message when the CCSID attribute is changed
  on panel 'Redefine Table Space'.
  
  In addition, when using the ALT Table function,
  if the CCSID attribute of a key column in the parent
  or child table of a referential constraint is changed,
  an SQLCODE -873 can result due to a key
  mismatch.
  

Problem conclusion

Temporary fix

Comments

• Problem has been resolved where the following warning message
  will be issued when the ALT/TS CCSID attribute is changed and
  associated tables are involved in RI relationship.
  
  New messages:
  
  ADBU004W Warning: Referential constraint has been detected
  where changing the CCSID field may introduce a mismatch
  
  Explanation:
  When the CCSID attribute is changed for a table space
  that's associated with a table that has referential
  constraint (RI Parent/Child table relationship),
  check the other table space and ensure the
   CCSID attribute is the same.
  
  User Response
  Consider changing the CCSID attribute in the corresponding
  table space that has parent/child table relationship with
  referential constraints so that the attributes match.
  Otherwise do not proceed with the CCSID attribute
  change.
  
  Also, warning message ADBP015W will be issued when
  changing the CCSID atttribute of a column which is part
  of a key in a referential constraint.
  
  ADBP015W Changing the CCSID of a key column in a
  foreign key relationship requires that the CCSID of the
  corresponding key in the parent or child table match.
  
  Explanation:
  This warning message is issued when the CCSID attribute is
  changed for a parent or foreign key column in a referential
  constraint. This could lead to a failure during execution
  when ALT attempts to reestablish the foreign key.
  
  System Action
  Processing continues after hitting ENTER.
  
  User Response
  If possible, change the corresponding key in the parent
  or child table so that the attributes match. Otherwise do
  not proceed with the CCSID attribute change.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADBU00
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI50554

     UP17/09/26 P F709

• RC10 PSY UI50555

     UP17/09/26 P F709

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.