If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > drop tablespace

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-26-11, 02:35
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
drop tablespace

db2 ese 9.5 fp 8 on P/linux
I have restored a part of a db with rebuild command for testing
but in the log there have been some statements accessing other tablespaces and these have also been defined in catalog but are in restore pending state
I tried to drop these, but SQL0282N is presented
some tables are present in these tablespaces, but can not be dropped, because of SQL0290N
the problem is that a backup started by procedure is giving errors
is there any possibility to drop these tables/tablespaces, because they are not needed.
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #2 (permalink)  
Old 10-26-11, 08:15
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
After a partial restore with rebuild option, excluded tablespaces should be in restore pending state (for db using archival logging). You should be able to drop tablespaces in this state. For sql0282n, some table parts (ie, data/index/lobs) are defined in separate tablespaces. You can drop these related tablespaces using one command (ie. drop tablespaces <data>, <index>, <lob>).
Reply With Quote
  #3 (permalink)  
Old 10-26-11, 09:28
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
yes
db2 "drop tablespace TS_L_JBPM40_D_4K, TS_R_JBPM40_i_4K, TS_R_JBPM40_d_4K"
DB20000I The SQL command completed successfully.
if dropping them together all is ok..
thanks for the help/update
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On