Skip to Content
Former Member
Dec 29, 2011 at 09:24 PM

Error in Phase Deleting Substitution Tablespaces - (Follow Up Activities)



I have the following problem after finish upgrade 4.7 for ECC6 SR3 AIX-DB2 9.5

At phase Follow up Activities : 6.2 Deleting Substitution Tablespaces. (pag 139 - Upgrade Guide)

Delete old

PSAPES<source release>D

PSAPES<source release>I

PSAPEL<source release>D

PSAPEL<source release>I

I deleted the tablespaces PRD#EL620D and PRD#EL620I with sucess, but when I try delete the tablespace PRD#ES620D, the following error appear :

$ db2 drop tablespace PRD#ES620D

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0282N Table space "PRD#ES620D" cannot be dropped because at least one of

the tables in it, "SAPPRD.BCACT", has one or more of its parts in another

table space. SQLSTATE=55024

How can I resolve this problem ?

best regards