PI51466: DB2 ADMIN TOOL DROP OF A TEMPORAL TABLE COMPLEX WITH VIEWS ON THE TABLES ENDS WITH SQLCODE -204 DROP VIEW.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A two temporal table complex contains a table for current data,
  a table for history data, and each table is their own
  tablespace.
  Each table has a view. A DB2 ADMIN Compare that drops both table
  spaces gets error:
     ADB5044I *** INPUT STATEMENT:
        DROP VIEW <view_schema>.<view_name>
     sqlerror on DROP       command, PREPARE    function
      DSNT408I SQLCODE = -204, ERROR:  <view_schema>.<view_name>
      IS AN UNDEFINED NAME
      DSNT418I SQLSTATE   = 42704 SQLSTATE RETURN CODE
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who use the Compare            *
  *                 function to drop a temporal table            *
  *                 complex.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Object Compare to drop a     *
  *                      temporal table complex, the dependent   *
  *                      VIEW created on the history table was   *
  *                      not detected as dropped by dropping     *
  *                      the history table. An unneeded DROP     *
  *                      VIEW statement was generated which      *
  *                      caused the run change job (WSL) to      *
  *                      fail with SQLNCODE204 /                 *
  *                      SQLCODE=-204:                           *
  *                                                              *
  *                      DROP VIEW <view_schema>.<view_name>;    *
  *                      sqlerror on DROP    command, PREPARE    *
  *                      function                                *
  *                      DSNT408I SQLCODE = -204, ERROR:         *
  *                      <view_schema>.<view_name> IS AN         *
  *                      UNDEFINED NAME                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using Object Compare to drop a temporal table complex,
  the dependent view created on the history table was not
  detected as dropped by dropping the history table.  An
  unneeded DROP VIEW statement was generated which caused
  the run change job (WSL) to fail with SQLCODEN204 /
  SQLCODE=-204.
  

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:

Modules/Macros

•    ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI33958

     UP15/12/23 P F512

• RB10 PSY UI33959

     UP15/12/23 P F512

• RB20 PSY UI33960

     UP15/12/23 P F512

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.