PK62666: ADB2WVL SIGNAL ERROR RC8 MSGISPS102 MSGADB3000E ERROR PROCESSING TABLE XXX IN CREATE STATEMENT: OBJECT ALREADY EXISTS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Object Compare Tool a table level, catalog to catalog
  compare of two tables fails with the following messages:
  .
  FUNCTION = ADB2WVL, LINE 261: Signal error
  
  RC       = 8
  
  ZERRMSG  = ISPS102
  ZERRSM   = User error
  ZERRLM   = One or more statements not  successfully validated
  .
  ADB3000E Error processing Table IDC3056.PLAN_TABLE in CREATE
  statement: Object already exists.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object  Compare using validate see  *
  *                 error. FUNCTION = ADB2WVL, LINE 261: Signal  *
  *                 error Rc = 8.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare panel GOC5  requires the *
  *                      Validate=V to allow only the following. *
  *                      Otherwise,  issue the error  message to *
  *                      prevent further processing.             *
  *                       Compare Source option 1 (DDL File)     *
  *                       Compare Target option 2 (DB2 Catalog)  *
  *                       Compare Target option 4                *
  *                           (DB2 Catalog Auto Select/Extract)  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Object Compare panel GOC5 requires Validate=V to allow only the
  following:   Otherwise,  issue error message to prevent further
  processing.
    Compare Source option 1 (DDL File)
    Compare Target option 2 (DB2 Catalog)
    Compare Target option 4 (DB2 Catalog Auto Select/Extract)
  

Problem conclusion

• The problem has been fixed.
  

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

•    GOC5     GOC5H
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK39002

     UP08/08/30 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.