DB2 tablespace (USERSPACE1) from Drop Pending to Normal stats?

[calvinyin]

Can I know how I could change the DB2 tablespace (USERSPACE1) from Drop Pending to Normal stats? And now i have only a single back up file with me. I have run the restore database few time but the status is still same.


D:\IBM\SQLLIB\BIN>db2 list tablespaces

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.

State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0xc000
Detailed explanation:
Offline
Drop Pending

Tablespace ID = 3
Name = ITMREG8K
Type = System managed space
Contents = All permanent data. Regular table space.

State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 4
Name = ITMSYS8K
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 5
Name = ITMUSER8K
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 6
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 7
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal

[chendan]

If a tablespace is placed in drop pending state, you can't changed it back to normal state without help from support. Then only thing you can do is to drop and recreate it. One thing you might want to figure out is why it was in drop pending state. One common case is: the database/tablespace is non-recoverable, and you some how damaged it.