PI50403: DB2 ADMIN TOOL ALLOW ALTER FOR DEFAULT CCSID FOR A DATABASE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Alter a database using ALT, but it is not possible to
  change the default CCSID for that database on Panel ADB21DA
  "Alter/Rename Database"
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the ALT function against        *
  *                 a database.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: An option to change the encoding        *
  *                      schema of a database does not exist.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALT function against a database there was no
  entry for the user to change the encoding scheme of the
  database.
  

Problem conclusion

Temporary fix

Comments

• The new fields 'CCSID' and 'Propagate CCSID' are added
  on panel ADB21DA 'Alter/Rename Database'.
  
  The user can change the encoding schema of the database
  by specifying value (E - EBCDIC, A - ASCII, U -UNICODE)
  in field 'CCSID', and choosing whether to propagate the
  encoding schema change to table space(s) by specifying
  value (Yes/No) in field 'Propagate CCSID'.
  
  There is a restriction that column changes around CCSID
  cannot be recovered when ALT is used to propagate CCSID
  changes from Database level.
  

APAR Information

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

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

  UI40442

Modules/Macros

•    ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST
  ADBCP    ADBCRCR  ADBCSPG  ADBCVC   ADBCVCT  ADBCVEY  ADBCVIC
  ADBCVOC  ADBDAT   ADBDK    ADBH1DA  ADBLI    ADBNSPB  ADBPA
  ADBPA1   ADBTEPI  ADBTEPR  ADBTEPU  ADBTEP2  ADBVFC   ADBVFCA
  ADBVFCF  ADBV99   ADB2CDC  ADB2CID  ADB2CME  ADB2CMF  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM2  ADB2CM3  ADB2DEP
  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2OVW  ADB2PA   ADB2PA3  ADB2PA4
  ADB2PA5  ADB2PA6  ADB2PA7  ADB2RE   ADB2REE  ADB2REG  ADB2REH
  ADB2REM  ADB2REP  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC  ADB2RPT
  ADB2WCL  ADB2WIN  ADB2WVL  ADB21D   ADB21DA  ADB21DA0 ADB27AC
  ADB28MC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI40442

     UP16/09/01 P F608

• RB20 PSY UI40443

     UP16/09/01 P F608

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.