PH00168: CM BATCH OBJECT COMPARE ADB2PA PARSE ERROR ONCODE 350 ONCODE150 COLLATE_NUMBER COMPARE_TRIGGERS IBM0441W VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CM Batch or Object Compare import processing involving VIEWs,
  TRIGGERs and ALTER logic may result in ADB2PA parse errors on
  the views (due to incorrect DDL generation), and one or more of
  the following errors:
  1. ONCODE = 350 /ONCODE350 The STRINGRANGE condition was raised.
  From entry point COLLATE_NUMBER at statement 20525 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.
  2. IBM0441W ONCODE = 150 /ONCODE150 The STRINGSIZE condition
  was raised.
  From entry point COMPARE_TRIGGERS at statement 17023 at compile
  unit offset >offset< at entry offset >offset< at address
  >address<.
  From entry point COMPARE_TRIGGER_SETS at statement 9109 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.
  3. In the change file, VCAT value is invalid in the following
  statement:
  ADMIN ALTER INDEX .. VCAT ...
  4. ADMIN ALTER TABLE .. is missing before
      ALTER LOGICAL PARTITION n
      ALTER LOGICAL PARTITION n ENDING AT (nnn.,nnnn.,'nnnnnnnnn')
  
  4. ADB2PA: The following statement could not be parsed :
  ALTER LOGICAL PARTITION n ENDING AT
  (xxx.,yyyy.'zzzzzzzzzzzzzzzzzz')
  (the statement ADMIN ALTER TABLE is missing before the ALTER
  statement)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool for      *
  *                 z/OS and users of DB2 Admin Tool for z/OS    *
  *                 who use the Change Management Batch          *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When importing a change file            *
  *                      generated by Admin Tool or Object       *
  *                      Comparison Tool, multiple ONCODE        *
  *                      and parser errors may occur.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  There are 4 issues:
  
  1. ONCODE=350 The STRINGRANGE condition was raised.
  From entry point COLLATE_NUMBER at statement 20525 ...
  
  2. IBM0441W ONCODE=150 The STRINGSIZE condition was raised.
  From entry point COMPARE_TRIGGERS at statement 17023 ...
  
  3. In the change file, invalid data is generated for VCAT..
  ADMIN ALTER INDEX .. VCAT ...
  
  4. ADMIN ALTER TABLE .. is missing before
     ALTER LOGICAL PARTITION n
     ALTER LOGICAL PARTITION n ENDING AT (nnn.,nnnn.,'nnnnnnnnn')
     This incorrect syntax caused the parser errors.
  
  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  ADB2CMS  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• 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.