PH14886: OBJECT COMPARE STORED PROCEDURE GOC5 CM IMPORT CHANGES ADB2C14 ADB7749E UNEXPECTED TOKEN MAIN ADB9409E FAILED BUILDING DELTA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using Object Compare to make multiple changes to a stored
  procedure's attributes or body, if a user generates a Change
  (Generate Apply jobs-> Change) on panel GOC5,
  and then attempts to import the change into Change Management
  on panel ADB2C14, the registration of the change may fail
  with message ADB7749E/msgadb7749E:
  
  
  ADB7749E The DDL reader encountered an unexpected token in the
  following option: MAIN.
  ADBCDTS - Unsuccessful
  completion
  
            ADB9409E Registration could not be
  completed.
                     Reason Code . . . 20
                     Reason  . . . . . : Failed while building
  the delta version.
                     Change ID . . . . : nnnn
  Register error. rc= 16
  

Local fix

• Do not go through Change Management, but instead enter the
  following on panel GOC5:
  
  GENERATE APPLY JOBS -> YES
  AS WORK STATEMENT LIST -> YES
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who alter stored procedures.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Importing changes to a native SQL       *
  *                      stored procedure's body and its         *
  *                      attributes may result in error message  *
  *                      ADB7749E/msgadb7749e.                   *
  ****************************************************************
  Importing a change into Change Management that contains multiple
  alters to a stored procedure, including at least one to the SQL
  body and one to its attributes, may result in the following
  error:
  
  ADB7749E The DDL reader encountered an unexpected token in the
  following option: MAIN.
  

Problem conclusion

• The issue 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:

  UI66307

Modules/Macros

• ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66307

     UP19/11/12 P F911

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.