PK34683: OBJECT COMPARE DROPS A TABLESPACE ALONG WITH A VIEW BUT THE DROP OF VIEW IS UNNECESSARY BECAUSE IT WAS IMPLICITLY DROP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer changes a tablespace from segmented to simple and
  Object Compare runs rc=0 but it Drops the tablespace and a view.
  The drop of the view is unnecessary because it was dropped
  implicitly when the tablespace was dropped.
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 compare the same Tablespace using source     *
  *                 and target DDL, may be affected.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: A tablespace is  changed from segmented *
  *                      to simple and  Object Compare runs RC=0 *
  *                      but it drops the tablespace and a view. *
  *                      The  drop  of the view  is  unnecessary *
  *                      because  it is  dropped implicitly when *
  *                      the tablespace is  dropped.             *
  *                      .*                                      *
  *                      Comparing  the  same  tablespace  using *
  *                      same  source/target  DDL  with the only *
  *                      difference  in   the  tablespace  being *
  *                      source has 'segsize 64' and also a view *
  *                      showing a difference, the GOC run gives *
  *                      RC=0; however, there  is  a drop of the *
  *                      tablespace  and  of  the view. The Drop *
  *                      View  is   unnecessary   since  it   is *
  *                      implicitly dropped  when the tablespace *
  *                      is  dropped.                            *
  *                      .* Note:                                *
  *                      Unnecessary Drop  view statement in the *
  *                      Changes  file  occurs    when  View  is *
  *                      dropped  implicitly   by  dropping  the *
  *                      tablespace.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK21799

     UP07/02/06 P F702

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.