PM76737: PANEL ADB2EC 'CREATE PLAN_TABLE' CREATES DDL WITH CCSID EBCDIC DB2 10 NFM IF DATABASE IS DEFINED WITH CCSID EBCDIC SQLCODEN878

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS panel ADB2EC
  'Create PLAN_TABLE' creates DDL with a CCSID EBCDIC if the
  database specified in the 'Database' field was defined as
  CCSID EBCDIC.
  The CREATE PLAN_TABLE DDL will execute successfully however
  when an EXPLAIN is attempted a SQLCODE -878 / SQLCODEN878 will
  be received:
  DSNT408I SQLCODE = -878, ERROR:  THE PLAN_TABLE USED FOR EXPLAIN
  MUST BE
           ENCODED IN UNICODE.  IT CANNOT BE IN ASCII OR EBCDIC
  DSNT418I SQLSTATE   = 53094 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXOD0Z SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -150  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF6A'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

• Use the PROMPT feature to edit the CREATE DDL to replace the
  CCSID EBCDIC with a CCSID UNICODE.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'CT - Create Table'         *
  *                 command on panel ADB2E 'Explain' to          *
  *                 create an EXPLAIN table.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool panel       *
  *                      ADB2EC 'Create PLAN_TABLE' creates DDL  *
  *                      with a CCSID EBCDIC encoding scheme if  *
  *                      the database specified in the           *
  *                      'Database' field was defined as CCSID   *
  *                      EBCDIC.  The CREATE PLAN_TABLE DDL      *
  *                      will execute successfully in DB2 10     *
  *                      Conversion Mode (CM).  However,         *
  *                      when an EXPLAIN is attempted a          *
  *                      SQLCODE=-878 /  SQLCODEN878             *
  *                      error is received:                      *
  *                                                              *
  *                      DSNT408I SQLCODE = -878,                *
  *                      ERROR: THE >explain-object< USED        *
  *                      FOR EXPLAIN MUST BE ENCODED             *
  *                      IN UNICODE. IT CANNOT BE IN             *
  *                      ASCII OR EBCDIC.                        *
  *                      DSNT418I SQLSTATE   = 53094             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      When executed in DB2 9 New Function     *
  *                      Mode (NFM) and below, if the EXPLAIN    *
  *                      table is created with CCSID ASCII       *
  *                      encoding scheme, the CREATE EXPLAIN     *
  *                      table DDL will execute successfully,    *
  *                      however when an EXPLAIN is attempted,   *
  *                      a SQLCODE= -878 / SQLCODEN878 error     *
  *                      is received:                            *
  *                                                              *
  *                      DSNT408I SQLCODE = -878,                *
  *                      ERROR: THE PLAN_TABLE USED              *
  *                      FOR EXPLAIN CANNOT BE ASCII.            *
  *                      DSNT418I SQLSTATE   = 53094             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool panel ADB2EC 'Create PLAN_TABLE'
  creates DDL with a CCSID EBCDICwith encoding scheme if the
  database specified in the 'Database' field was defined as
  CCSID EBCDIC.  The CREATE PLAN_TABLE DDL will execute
  successfully in DB2 10 Conversion Mode (CM).  However, when
  an EXPLAIN is attempted a SQLCODE=-878 / SQLCODEN878 error is
  received.
  
  When executed in DB2 9 New Function Mode (NFM) and below, if
  the EXPLAIN table is created with CCSID ASCII encoding scheme,
  the CREATE EXPLAIN table DDL will execute successfully,
  however when an EXPLAIN is attempted, a SQLCODE=-878 /
  SQLCODEN878 error is received.
  

Problem conclusion

• Problem has been resolved. DB2 Admin will issue the message
  ADB398E on panel ADB2EC when the incorrect encoding scheme is
  used:
  
  ADB398E
  The encoding scheme of the specified table space must be
  V_CCSID.
  
  Explanation:
  The encoding scheme of the EXPLAIN table must be the same as
  the encoding scheme of the table space that contains the
  table. In DB2 Version 9.1 and below New Function Mode
  (NFM), because the encoding scheme of the EXPLAIN table
  must be EBCDIC or UNICODE, the encoding scheme of the table
  space that contains the EXPLAIN table must be EBCDIC or
  UNICODE. In DB2 Version 10 and above in conversion mode (CM),
  because the encoding scheme of the EXPLAIN table must be
  UNICODE, the encoding scheme of the table space that contains
  the EXPLAIN table must be UNICODE.
  
  System action:
  None.
  
  User response:
  In DB2 Version 9.1 and below NFM environments, specify a table
  space that is encoded in EBCDIC or UNICODE. In DB2 Version 10
  and above CM environments, specify a table space that is
  encoded in UNICODE.
  

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:

  UK91054 UK91055

Modules/Macros

•    ADB2EC   ADB39
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK91054

     UP13/01/22 P F301

• RA20 PSY UK91055

     UP13/01/22 P F301

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.