DB6CONV 6.39 - Dropping source tablespaces after conversion
I want to drop the old Tablespace after a conversion with Option don't "Delete Source Table After Conversion"
Steps I did:
1. db2 "RENAME TABLESPACE SID#CLUD to SID#CLUD_old"
2. created a new tablespace SID#CLUD identical to SID#CLUD_old with DBACOCKPIT
3. SA38 - DB6CONV
4. Folder Tablespace
- Tablespace to Be Converted: SID#CLUD_old
- Use Target Tablespace
--Target Data Tablespace: SID#CLUD
--Target Index Tablespace: SID#CLUI (same as CLUD_old)
--Target Long Tablespace: empty
5. Pressed Button "Create Queue" (31 Tables & 22480 KB)
-active: Use COPY WITH INDEXES
-inactive: Use LOAD
-inactive: Use REDIRECT
-gray: Stop Before Switch
-inactive: Delete Source Table After Conversion
-Data: Yes (adaptive)
8. Save -> Conversion Job created (Status Planned)
9. Start Conversion - Immediately - OK
10. FINISHED - all rows green - 31 green entries for converted tables
db2 "SELECT b.tbspace, a.tabschema, a.tabname FROM SYSCAT."TABLES" a INNER JOIN SYSCAT.TABLESPACES b ON ( a.tbspaceid = b.tbspaceid ) WHERE b.tbspace = 'SID#CLUD_ALT'"
shows the 31 old tables now with names like CDCLSAAR4gTo.
At the IBM Knoweledge Center (ADMIN_MOVE_TABLE procedure - Move tables online) I found
"... options ... KEEP This option keeps a copy of the original source table under a different name. If the source table name is T1, then after the move that table will be automatically renamed to something such as T1AAAAVxo..."
Looks good at this point.
After comparisson of tables in tablespace CLUD and CLUD_OLD I wanted to drop old tablespace with
db2 drop tablespace SID#CLUD_ALT
But instead of dropping it following error message came up:
DB21034EThe command was processed as an SQL statement because it was not avalid Command Line Processor command.During SQL processing it returned: SQL0282NTable space "HWD#CLUD_ALT" cannot be dropped because at least one of the tables in it, "SAPHWD.CDCLSAAR4gTo", has one or more of its parts in another table space.SQLSTATE=55024
Trying to delete tablespace with DBACOCKPIT brought up a "Tablespace … still in use; deletion not possible"
How to proceed?