PK54046: ADMIN ALC USING CM GIVES RC08 STEP MERGE3 ERROR CHANGE FOUND FOR TABLESPACE DSNDB04.ADRESSE BUT NO BASE DEFINITION WAS FOUND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User does a ALC in Admin Tool R720 and uses  Change management
  REQUIRED for SQLID  change of a table that had been defined
  originally with:
     Base situation: table DB.ADRESSE
     with default table space (ADRESSE)
     and default database   DSNDB04
  When doing the  ALC change the user changes database and
  table space names. After this change was registered in CM
  they did a Analyze which fails with:
  Step MERGE3  fails with RC08 and error message:
  " Change found for Tablespace DSNDB04.ADRESSE but no base
    definition was found ."
  

Local fix

• Please apply ptf when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of  DB2 Administration Tool            *
  *                 who use ALC and change management            *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool, when using  *
  *                      ALC and Change Management to change     *
  *                      the table's database or table space,    *
  *                      a RC08 may occur in the merge step      *
  *                      when performing the analyze function.   *
  *                      The reported symptom is "...no base     *
  *                      definition found." Additional errors    *
  *                      during register or analyze may occur    *
  *                      due to multiple SQL statements not      *
  *                      being registered or an absent           *
  *                      statement to drop the primary key.      *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  An improper change statement was being produced by exec
  ADB2CCA during the registration of the change. Multiple
  statements passed to the register component by ALC were
  not split into individual statements.  This could lead to a
  variety of errors, such as a particular element of the change
  not being performed. When altering the primary key or dropping
  a primary key column, the DROP PRIMARY KEY statement was not
  being registered. This could lead to a message issued during
  the analyze process: "<tablename> already has a primary key".
  

Problem conclusion

• The problems have 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

•    ADB2CCA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK36514

     UP08/05/30 P F805

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.