By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Load command

P: n/a
Tim
Hi

I have what is probably a strange question but is it possible to get a
tablespace out of a backup pending state if one does a load on a
recoverable database? Also assuming this isn't possible would it be
possible to add a warning when it is run in a recoverable database
especially since it would typically result in an outage for that
tablespace?

thanks
tim

Ps. Also will the Infocenter ever return results correctly? I've
noticed when you look for say, "load command", its listed as a 23% hit
despite the fact that the page title is "load command". There is quite
a bit of very useful documentation in the Infocenter but its searching
appears to need some work :)

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Tim wrote:
Hi

I have what is probably a strange question but is it possible to get a
tablespace out of a backup pending state if one does a load on a
recoverable database? Also assuming this isn't possible would it be
possible to add a warning when it is run in a recoverable database
especially since it would typically result in an outage for that
tablespace?


Did you have a look at the COPY option of the LOAD command? That way you
can avoid that the tablespace goes into backup pending state.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2

P: n/a
Tim
I hadn't but now that I have I might try it next time. What I was
really after was a way for DB2 to warn you that you were about to do
something stupid in a similar fashion of doing a restore into an
existing database but only when the load could cause you problems.
Obviously if the user were a little more careful in what they were
doing it wouldn't be a problem but I'm sure we all know that users
can't really be trusted to get things right ;)

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.