PI39262: DDL COMMAND IN CM - MANAGE VERSIONS INCORRECTLY CREATES ADMIN ALTER IMPLICIT STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when using DDL command to
  produce BASE DDL in CM - Manage Versions incorrectly creates
  ADMIN ALTER IMPLICIT statement (panelid ADB2C41)
  

Local fix

• Manual edit of the produced DDL to remove ADMIN ALTER IMPLICIT
  statement is the workaround when using BASE DDL to run in SPUFI
  

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:

  UI29162 UI29163

Modules/Macros

• ADBCNBVF ADBPC41E ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  ADB2C41
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI29162

     UP15/07/10 P F507

• RB10 PSY UI29163

     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.