PI97260: DB2 ADMIN TOOL - WSL ENTRY FOR DROP INDEX TRUNCATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A WSL generated from a Compare between two tablespaces results
  in a WSL that will not run due to  missing semi-colon. Running
  the WSL returned SQLCODE = -199 / SQLCODEN199.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use CM Batch function.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: CM Batch function to Compare and        *
  *                      Analyze a change generates a WSL        *
  *                      with DROP INDEX ..statement. RUN WSL    *
  *                      results in SQLCODE=-199 / SQLCODEN199.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Using CM Batch function to Compare and Analyze a change that
  results in generating a WSL with DROP INDEX ..statement without
  the terminator character. Running the WSL results in SQL error:
  
  DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD COMMIT.
  TOKEN >END-OF-STATEMENT< WAS EXPECTED
  

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

•    ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI56654

     UP18/06/22 P F806

• RC10 PSY UI56655

     UP18/06/22 P F806

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.