PI41522: CMBATCH ENDS W/RC8 MSG ADB8052E/ADB8051W/ADB0006E DURING COMPARE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CMBATCH FAILS WITH RC8 AND ERROR MESSAGES FOUND DURING COMPARE.:
  ADB8051W Alter found for DB2IVP0.TDB2REFDBCLOB but no object
  definition was found in base.
  ADB8052E A change was found for DB2IVP0.TDB2REFDBCLOB but no
  base definition was found.
  ADB0006E ADBCCM - Error(s) found.  Please review output.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool          *
  *                 for z/OS who use the DDL line command        *
  *                 to generate DDL of a base version on         *
  *                 panel ADB2C41 'CM - Versions'.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the DDL line command to      *
  *                      generate DDL of a base version on       *
  *                      panel ADB2C41, the output of the DDL    *
  *                      contains the following alter statement: *
  *                                                              *
  *                      ADMIN ALTER IMPLICIT LOB TABLESPACE     *
  *                        FOR TABLE >table-name<                *
  *                          COLUMN(>coltype_dbclob_1m<)         *
  *                        BUFFERPOOL BP0      ;                 *
  *                                                              *
  *                      If the generated DDL is used as input   *
  *                      to Object Compare, the Object           *
  *                      Compare job ends with a Return Code     *
  *                      8 / RC=8 and error messages ADB8052E /  *
  *                      msgadb8052e and ADB0006E /              *
  *                      msgadb0006e:                            *
  *                                                              *
  *                      ADB8052E A change was found for         *
  *                      >table_name< but no base definition     *
  *                      was found.                              *
  *                                                              *
  *                      ADB0006E ADBCCM - Error(s) found.       *
  *                                                              *
  *                      If the customer uses the DDL in SPUFI,  *
  *                      it fails with a SQLCODE=-104 /          *
  *                      SQLCODEN104 error message:              *
  *                                                              *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL "ADMIN". SOME SYMBOLS    *
  *                      THAT MIGHT BE LEGAL ARE: <ERR_STMT>     *
  *                      <WNG_STMT> GET SQL SAVEPOINT HOLD       *
  *                      FREE  ASSOCIATE                         *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the DDL line command to generate DDL of a base
  version on panel ADB2C41, the output of the DDL contains the
  following alter statement:
  
  ADMIN ALTER IMPLICIT LOB TABLESPACE
    FOR TABLE >table-name<
      COLUMN(>coltype_dbclob_1m<)
    BUFFERPOOL BP0      ;
  
  If the generated DDL is used as input to Object Compare,
  the Object Compare job ends with a Return Code 8 / RC=8
  and error messages ADB8052E / msgadb8052e and ADB0006E /
  msgadb0006e:
  
  ADB8052E A change was found for >table_name< but no base
  definition was found.
  
  ADB0006E ADBCCM - Error(s) found.
  
  If the customer uses the DDL in SPUFI, it fails with a
  SQLCODE=-104 / SQLCODEN104 error message.
  

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:

  UI29167 UI29168

Modules/Macros

• GOCCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA20 PSY UI29167

     UP15/07/10 P F507

• RB10 PSY UI29168

     UP15/07/10 P F507

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.