Function level V12R1M504 and e.g. archive tables

V12R1M504:

With APPLCOMPAT V12R1M504 on e.g. SPUFI or DSNTEP2, one can no longer create segmented or classic partitioned table spaces. See knowledge center for this restriction.
A small marginalia is behind this restriction, if this is combined with another fact.
In special cases DROP TABLE removes also dependent tables, e.g. DROP of an archive-enabled table (AET) drops the dependent archive table.

Scenario:

Assume an AET is in database 1 (DB_1), the table space type in this case is irrelevant.
The dependent archive table is in database 2 (DB_2), the table space type is an old-fashioned segmented table space.
Now DROP DB_1 is issued and this runs successful.
If the dependent archive table is in a universal table space (UTS), then DROP DB_1 results in:

SQLCODE = -669, ERROR: THE OBJECT CANNOT BE EXPLICITLY DROPPED. REASON 0001

Explanation:

The DROP DB_1 wants to drop also the AET table: this implicitly triggers the DROP of the dependent archive table, which could not run, because the dependent archive table is in a UTS. And UTS does not allow DROP TABLE. Refer again to SQLCODE-669.

With introduction of V12R1M504 this scenario could happen, because DDL CREATE syntax of an old-fashioned segmented table space creates a UTS Partition-By-Growth (PBG) table space.

If you ask yourself, why the author knows this and thinks this is remarkable: By running into the problem.

Views: 488

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Comment by Peter Hartmann on November 24, 2019 at 6:50

Now a solution is available.

For details refer to:

https://www.ibm.com/developerworks/community/blogs/897a7c98-57af-45...

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

Db2 Analytics Accelerator Version 7.5 is now Generally Available!

Started by Patricia Zakhar in What's hot ? on Monday. 0 Replies

Now Generally AvailableIBM Db2 Analytics Accelerator Version 7.5! The latest version of the Db2 Analytics Accelerator, which delivers the highly anticipated Integrated Synchronization capability, is now generally available. The Db2 Analytics…Continue

Db2 for z/OS Master class with John Campbell and the SWAT team returns!

Started by Surekha Parekh in What's hot ?. Last reply by carol Goldberg Nov 7. 1 Reply

Db2 for z/OS Master class with John Campbell and the SWAT team returns! June 24-28, 2019 at IBM Hursley near Winchester, UKSeptember 23-27, 2019 at IBM Silicon Valley Lab in San Jose, California…Continue

Tags: Events, MasterClass, JohnCampbell

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service