PH53653: PARSER ERROR DURING WSL VALIDATE STEP OF COMPARE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Parser error during WSL Validate step of compare.
  

Local fix

• Creating new APAR.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use Object Compare on a table or view    *
  *                 that has a schema name greater than          *
  *                 eight characters                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare ends with a parser error *
  *                      and RC=8 following PL/I ONCODE 340 in   *
  *                      program ADB2PA, procedure               *
  *                      ADD_SYMBOL_COLS_CTLG.                   *
  ****************************************************************
  An SQL ID greater than eight characters was used by Db2 Admin
  Tool in an EXEC SQL SET CURRENT SQLID statement. However,
  SET CURRENT SQLID does not support an SQL ID greater than eight
  characters. The resulting error SQL code caused ONCODE 340 and
  early termination of SQL parsing.
  
  Keywords: MSGIBM0342S ONCODE0340
  

Problem conclusion

• The problem has been resolved.
  ++HOLD:
  Bind required for adb2prp.
  

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:

  UI92880

Modules/Macros

• ADB2LCC  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA6  ADB2PRP  ADB2WCL
  ADB2WVL  ADB3000  ADBCRCM  ADBCRCR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI92880

     UP23/07/27 P F307

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.