PH19522: ADMIN TOOL DOES NOT ALLOW X'5A5A' AS A CONCATENATION CHARACTER. THIS IS VALID IN DB2 FOR SOME EBCDIC CCSIDS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Admin Tool does not allow X'5A5A' as a concatenation
  character.  This is valid in DB2 for some ccsids.  The
  following error is received when doing a GEN on a object created
  with the X'5A5A'.
  
  DB2PA5: The following statement could not be parsed
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object compare fails with a parser      *
  *                      error when using X'5A5A' for            *
  *                      concatenation characters.               *
  ****************************************************************
  Object Compare fails with the following error when the DDL
  contains X'5A5A' characters in an environment that uses CCSID
  273:
  
  ADB2PA5.TOKENIZE
  O i=0001076 st=00 Char= U FC Sym#=01 N st=00 Act=77 Typ=02
  Ts=0001073 P=0001076 C=0000000
  i=000001076L(sql_stmt)=000006816L(sql_stmt_caps)=000006817
    Syntax error during statement scan. Text=!! partial_statement
  

Problem conclusion

• The problem is 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:

  UI67944

Modules/Macros

• ADB2PA5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67944

     UP20/02/20 P F002

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.