I have backup that I can use to get the data, but its not letting me drop
the Tablespace.
I did restart db <dbname> drop pending tablespaces(DATA_TS1). Still no
effect.

I need this tablespace dropped!!

Any help?


>From: "Edwards Ed "
><db2udbdba-ezmlmshield-x18454728.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: Urgent: Tablespace level Restore...
>Date: Wed, 25 Apr 2007 16:11:22 -0400
>
>Do you have any exports (via export command or db2move)?
>
>
>
>
>
>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: DANIEL CALLAHAN
>[mailto:db2udbdba-ezmlmshield-x13828058.[Email address protected]
>Sent: Wednesday, April 25, 2007 4:08 PM
>To: LazyDBA Discussion
>Subject: Re: Urgent: Tablespace level Restore...
>
>You cant do the tablespace restore with circular logging. You can drop
>the tablespace and create a new one, but you will manually have to
> create the tables and load the data again.
>
>
>
>
>
>
>"vedant k7 " <db2udbdba-ezmlmshield-x45508219.[Email address protected]
>04/25/2007 03:56 PM
>
>To
>"LazyDBA Discussion" <[Email address protected]
>cc
>
>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
>
>
>
>
>---------------------------------------------------------------------
>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
>

_________________________________________________________________
Sign in and get updated on all the action from Formula One
http://content.msn.co.in/Sports/FormulaOne/Default


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