Thanks all.

I could not drop the tablespace because I had indexes pointing to a
different tablespace.
If I wanted to drop that tablespace, I had other indexes whose Tables are in
a different Tablespace.
To make everyones life easier, I did a full restore from 4 days old backup
and applied the Procedure and Function code which was available from the
corrupted database.

Though I'm wondering if I can Alter the Database to ENABLE ROLLFORWARD
RECOVERY, Backup Tablespaces of Stored Procedures and restored it later.

One funky day it was,

Surendar.


>From: "Edwards Ed "
><db2udbdba-ezmlmshield-x36873454.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: Urgent: Tablespace level Restore...
>Date: Thu, 26 Apr 2007 08:37:32 -0400
>
>Hey Pravin,
> Outstanding! Hehe.
>
> Have a great Day!
>
>
>
>
>
>Please take a few minutes to provide feedback on the quality of service you
>received from our staff. The Department of Education values your feedback
>as a customer. Commissioner of Education Jeanine Blomberg is committed to
>continuously assessing and improving the level and quality of services
>provided to you.Simply use the link below. Thank you in advance for
>completing the survey.
>
>
>http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>
>
>
>
> -----Original Message-----
>From: Pravin
>[mailto:db2udbdba-ezmlmshield-x21099668.[Email address protected]
>Sent: Thursday, April 26, 2007 8:01 AM
>To: LazyDBA Discussion
>Subject: RE: Urgent: Tablespace level Restore...
>
>Hi,
>
>
>If your tablespace is in drop pending state, then use
>Db2 restart with drop pending option
>And then drop the tablespace.
>
>Edwards can give you better insight.
>
>Thanks
>Pravin
>
>-----Original Message-----
>From: vedant k7
>[mailto:db2udbdba-ezmlmshield-x45508219.[Email address protected]
>Sent: Thursday, April 26, 2007 1:27 AM
>To: LazyDBA Discussion
>Subject: Urgent: Tablespace level Restore...
>
>I messed up one of the containers in a tablespace. Now,
>
>1. Can I not do Tablespace level Restore If my databaes is not
>configured
>for Roll Forward Recovery?? Is there any workaround??
>
>2. If not, How do I drop this tablespace and recreate the objects in
>there??
>
>
>Thanks,
>
>Surendar.
>
>_________________________________________________________________
>Mega Airfare Sale. Click here Now.
>http://ss1.richmedia.in/recurl.asp?pid=18
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>DISCLAIMER:
>This message contains privileged and confidential information and is
>intended only for an individual named. If you are not the intended
>recipient, you should not disseminate, distribute, store, print, copy or
>deliver this message. Please notify the sender immediately by e-mail if
>you have received this e-mail by mistake and delete this e-mail from
>your system. E-mail transmission cannot be guaranteed to be secure or
>error-free as information could be intercepted, corrupted, lost,
>destroyed, arrive late or incomplete or contain viruses. The sender,
>therefore, does not accept liability for any errors or omissions in the
>contents of this message which arise as a result of e-mail transmission.
>If verification is required, please request a hard-copy version.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

_________________________________________________________________
Voice your questions and our experts will answer them
http://content.msn.co.in/Lifestyle/AskExpert/Default01.htm


DB2 & UDB email list listserv db2-l LazyDBA home page