IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
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.
Add a Comment
Now a solution is available.
For details refer to:
https://www.ibm.com/developerworks/community/blogs/897a7c98-57af-45...
March 16, 2021 from 11am to 11:30pm – Webcast
0 Comments 2 LikesBringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.
Started by Shaun Hide in Security and DB2. Last reply by Alexander Dashevsky Nov 17, 2020. 1 Reply 0 Likes
I would need to know who modified table data on a certain day.I do have my backups and database logs available.DB2audit was however not activated at this point.How would i be able to access this information?Continue
Tags: #DataAccess
Started by Kip in What's hot ? Nov 4, 2020. 0 Replies 0 Likes
This digital event examines how enterprises can become smarter with a data management system that is developer-inclusive. During this session, participants will get to learn how Db2 integrates with a broad array of programming languages, employs…Continue
© 2021 Created by Surekha Parekh.
Powered by
You need to be a member of The World of DB2 to add comments!
Join The World of DB2