PH03987: CM BATCH COMPARE RUN WSL REBUILD INDEX DOUBLE QUOTES LISTDEF DSNU088I DSNUGTIS INVALID CHARACTER OPERAND RC=8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When processing an ALTER to an index name surrounded by double
  quotes, CM Batch or Compare may generate the subsequent REBUILD
  INDEX LIST LISTDEF statement with too many double quotes around
  the schema and index name. This may result in the following
  error when executing the run job:
  ADB5044I *** INPUT STATEMENT:
  REBUILD INDEX LIST ADBLD1;
  ADB5060I *** Implicit commit performed, number:             3
  DSNU000I    278 18:56:44.63 DSNUGUTC - OUTPUT START FOR
  UTILITY, UTILID = C00038
  DSNU1044I   278 18:56:44.64 DSNUGTIS - PROCESSING SYSIN AS
  EBCDIC
  DSNU005I    278 18:56:44.64 DSNUGTIS - LISTDEF ADBLD1
  DSNU005I    278 18:56:44.64 DSNUGTIS - INCLUDE INDEXSPACES
  DSNU005I    278 18:56:44.64 DSNUGTIS - INDEX
  ">schema<"."">indexname<""
  DSNU088I    278 18:56:44.64 DSNUGTIS - INVALID CHARACTER
  OPERAND - ">schema<"."">indexname<""
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS who use CM Batch or users of Db2        *
  *                 Object Comparison Tool for z/OS.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a change includes an index name      *
  *                      with quotes (for example ALTER INDEX    *
  *                      "ABC_..D"), the WSL generated by CM     *
  *                      batch or Object Compare may include     *
  *                      too many quotation marks, resulting     *
  *                      in a REBUILD utility error when the     *
  *                      WSL is executed.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When processing an index name that includes quotes
  (for example, ALTER INDEX "ABC_..D"), CM Batch or
  Object Compare may have double quotes in the WSL,
  resulting in errors such as the following when the
  WSL is executed:
  
  DSNU088I 278 18:56:44.64 DSNUGTIS - INVALID
  CHARACTER OPERAND -
  ">schema<"."">indexname<""
  DSNU005I 278 18:56:44.64 DSNUGTIS - REBUILD
  INDEX LIST ADBLD1
  DSNU012I 278 18:56:44.64 DSNUGBAC - UTILITY
  EXECUTION TERMINATED,
  HIGHEST RETURN CODE=8
  

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:

  UI61173 UI61174

Modules/Macros

•    ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI61173

     UP19/02/08 P F902

• RC10 PSY UI61174

     UP19/02/08 P F902

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.