PI56431: UNFRIENDLY MESSAGE WHEN REGISTER A CHANGE BY IMPORTING DDL BY BOTH TSO & BATCH MODE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unfriendly message when register a change by importing DDL by
  both TSO & Batch mode.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unfriendly error message was         *
  *                      received when registering a change.     *
  *                      The error occurs when parsing a DDL     *
  *                      statement that contain errors.  In      *
  *                      this case the statement contains a      *
  *                      DDL statement with an unquoted SQL      *
  *                      identifier that contains a question     *
  *                      mark (?) character:                     *
  *                                                              *
  *                      Unfriendly message in TSO mode:         *
  *                      ADB2PA5.TOKENIZE                        *
  *                      ...                                     *
  *                      Syntax error during statement scan.     *
  *                      Text=?MD?_MCROSEG                       *
  *                                                              *
  *                      ADB2PA5: The following statement        *
  *                      could not be parsed :                   *
  *                                                              *
  *                      RENAME TABLE >table_name<               *
  *                            TO  >new_table_name<              *
  *                                                              *
  *                      Unsuccessful parse of DDL statement.    *
  *                                                              *
  *                      ADB2CID - Now terminating               *
  *                      ***                                     *
  *                                                              *
  *                      Unfriendly message in Batch mode:       *
  *                      ADB0351E  Module : ADB2CID              *
  *                      detected an ONCODE condition            *
  *                      520 At TOKENIZE                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The SQL parser fails on parsing a DDL statement with an
  unquoted SQL identifier that contains a question mark
  character.
  

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

•    ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST
  ADBCRCR  ADBCSPG  ADBDAT   ADBDK    ADBLI    ADBNSPB  ADBPA
  ADBPA1   ADBTEPI  ADBTEPR  ADBTEPU  ADBTEP2  ADBV99   ADB2CID
  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  ADB2CMU  ADB2CM3  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA3
  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2REG  ADB2REH  ADB2WCL
  ADB2WIN  ADB2WVL  ADB27AC  ADB28MC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI36696

     UP16/04/02 P F604

• RB20 PSY UI36697

     UP16/04/02 P F604

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.