PI45053: DB2 ADMIN SQLCODE -104 IS RETURNED WHEN USE DISPLAYS DB2 CATALOG SCHEMAS WITH KATAKANA-BASED CCSIDS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1) Using "DB2 Administration Menu 11.1.0" panel
  2) Selecting : 1 - DB2 system catalog
  3) Selecting : H - Schemas
  4) then SQLCODE : -104
  .
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "e". SOME
           SYMBOLS THAT MIGHT BE LEGAL ARE:
               ( ??(    CONCAT || / MICROSECONDS MICROSECOND
  
  This error happens when the DB2 is configured with KATAKANA-
  based CCSIDs (930, 1390, or 5026). DB2 Admin Tool is encoded in
  CCSID 500 and has some lower-case letters (e.g, "Decimal") in
  it's SQL statements. As those characters are not compatible
  between CCSID 500 and KATAKANA-based ones, the SQL statement is
  not interpreted correctly, thus above SQL error.
  

Local fix

• By default, the DB2 Administration Tool plan and packages are
  bound using the character set ENCODING(EBCDIC). If your DB2
  is configured with an EBCDIC code page in which the quotation
  mark is not X'7F' or with KATAKANA-based CCSIDs, then you are
  recommended to add an ENCODING BIND option with 939, 1399, or
  5035 accordingly.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use IBM Tools Customizer            *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a DB2 subsystem is configured      *
  *                      with KATAKANA-based CCSIDs like         *
  *                      (i.e, 930, 1390, 5026), after binding   *
  *                      packages using the DB2 Admin Tool       *
  *                      with option ENCODING(EBCDIC), and       *
  *                      issuing the 'H - Schemas' primary       *
  *                      command to display DB2 catalog          *
  *                      schemas, a SQLCODE -104 /               *
  *                      SQLCODEN104 error is observed:          *
  *                                                              *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL "e". SOME                *
  *                      SYMBOLS THAT MIGHT BE                   *
  *                      LEGAL ARE: ( ??(    CONCAT || /         *
  *                      MICROSECONDS MICROSECOND..))            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a DB2 subsystem is configured with KATAKANA-based
  CCSIDs like (i.e, 930, 1390, 5026), after binding packages
  using the DB2 Admin Tool with option ENCODING(EBCDIC),
  and issuing the 'H - Schemas' primary command to display DB2
  catalog schemas, a SQLCODE -104 / SQLCODEN104 error is
  observed.
  

Problem conclusion

• The problem has been fixed.
  
  The new field 'ENCODING CCSID' is added respectively on the
  Product Parameters panel CCQPPRD and DB2 Parameters panel
  CCQPDB2 to allow the user to bind DB2 Admin Tool packages
  & plans with a CCSID value other than the SYSTEM EBCDIC CCSID.
  

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:

  UI40883 UI40884

Modules/Macros

• ADB$$PRM ADBBIND  ADBCFGBD ADBCUST  ADBPLANS ADBSETUP ADB2CUST
  ADB21
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI40883

     UP16/09/22 P F609

• RB20 PSY UI40884

     UP16/09/22 P F609

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.