PI99604: CM BATCH COMPARE WSL ALTER PERIOD DOUBLE QUOTES IBM0590S ONCODE 9250 ONCODE9250 ADBPMSG MSG7955

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When generating an ALTER of an object containing a period in
  its name, CM BATCH or COMPARE does not put double quotes around
  the object name in the WSL.   When the WSL is executed, the
  following errors may result:
  ADB5044I *** INPUT STATEMENT:
    ALTER INDEX schema.ABC_..D
       SECQTY -1;
  Unexpected token after ABC_ in CREATE INDEX statement --
  IBM0590S ONCODE=9250  The fetchable procedure with entry
  ADBPMSG could not be found
           From entry point MSG7955 at statement 50787 at compile
  unit offset  >offset< at entry offset  >offset< at
           address >address<.
  Note: Statement numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use CM Batch or users of 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 not include *
  *                      the quotation marks, resulting in a     *
  *                      parser 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 leave
  out the quotes in the WSL, resulting in errors such as the
  following when the WSLL is executed:
  
  ADB5044I *** INPUT STATEMENT:
    ALTER INDEX schema.ABC_..D
       SECQTY -1;
  Unexpected token after ABC_ in CREATE INDEX statement --
  
  IBM0590S ONCODE=9250 The fetchable procedure with entry
  ADBPMSG could not be found
           From entry point MSG7955 at statement 50787 at compile
  unit offset >offset< at entry offset >offset< at
           address >address<.
  
  Note: Statement numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  

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

•    ADB2CME
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58621

     UP18/09/26 P F809

• RC10 PSY UI58622

     UP18/09/26 P F809

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.