PI62080: DB2 OBJECT COMPARE TOOL COMPARE 2 CREATE GLOBAL TEMPORARY TABLESADB7350E MODULE : ADB2CMF DETECTED AN ONCODE 9999 / IBM IBM0281S

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When comparing source (new) with at least 2 CREATE GLOBAL
  TEMPORARY TABLEs against target (old) of an EMPTY DDL file
  and specify compare mask CLOSE:*.*,YES specified, returns the
  following error:
  ADB7350E Module : ADB2CMF detected an ONCODE condition 9999 in
           WRITE_TSP_FIELDS at 34481
  
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped
  
  No error with CLOSE:*.*,YES  removed.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who run compare with           *
  *                 a mask specified.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Object Compare with          *
  *                      a mask specified, Object Compare        *
  *                      may fail with an ONCODE9999 /           *
  *                      ONCODE 9999 in the                      *
  *                      APPLY_OVERWRITE function of             *
  *                      program ADB2MSK with error              *
  *                      messages ADB7350E / msgadb7350e         *
  *                      and ADB7380E / msgadb7380e.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using Object Compare with a mask specified, Object Compare
  may fail with an ONCODE9999 / ONCODE 9999 in the APPLY_OVERWRITE
  function of program ADB2MSK with error messages ADB7350E /
  msgadb7350e and ADB7380E / msgadb7380e:
  
  ADB7350E Module : ADB2CMF detected an ONCODE
  condition  9999 in APPLY_OVERWRITE at 12981
  ADB7380E Module ADB2CMP - Severe error Compare
  has been stopped.
  
  The Abend could occur when the following conditions are true:
  
  1. The source is from the DDL file.
  
  2. The Source DDL file contains a table definition which uses
  an implicit database and table space.
  
  3. The mask definition contains overwrite information for table
  space level attributes and the dbname in the inmask is specified
  as "*". For example:
  
  CLOSE:*.*,YES
  

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:

  UI41285 UI41286

Modules/Macros

• ADB2MSK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI41285

     UP16/10/08 P F610

• RB20 PSY UI41286

     UP16/10/08 P F610

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.