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\B IN>db2 list tablespaces

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE...