PM94214: DB2 ADMINISTRATION TOOL FOR Z/OS GEN PROCESS DOES NOT USE THE CCSID OF THE VIEW FROM SYSENVIRONMENT RECORD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS GEN process does not use the
  CCSID of the VIEW from SYSENVIRONMENT record resulting in
  ADB2GEN error similar to this :
  .
  ADB2PA5.TOKENIZE
  O i=0001696 st=00 Char=ﾽ 4A Sym#=01 N st=00 Act=77 Typ=10
  Ts=0001682
  P=0001696 C
  i=000001696L(sql_stmt)=000001944L(sql_stmt_caps)=000001942
  Syntax error during statement scan. Text=^= 'Y'
  
  ADB2PA5: The following statement could not be parsed :
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user runs ADB2GEN on a view,     *
  *                      if the default CCSID for EBCDIC SBCS    *
  *                      on the user's system is different       *
  *                      than the CCSID in the                   *
  *                      SYSIBM.SYSENVIRONMENT table row for     *
  *                      the view, the DB2 Admin Tool issues     *
  *                      the following error:                    *
  *                                                              *
  *                      ADB2PA5: The following statement        *
  *                      could not be parsed:                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a user runs ADB2GEN on a view, if the default CCSID for
  EBCDIC SBCS on the user's system is different than the CCSID in
  the SYSIBM.SYSENVIRONMENT table row for the view, the DB2 Admin
  Tool issues the following error:
  
  ADB2PA5: The following statement could not be parsed :
  

Problem conclusion

• Problem has been resolved.
  

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

•    ADB2PA   ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI13021

     UP13/11/30 P F311

• RA20 PSY UI13020

     UP13/11/30 P F311

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.