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

Configuring Database

P: n/a
Hi All:

I use db2 v8.2 on AIX platform.
I have three databases using the same instance.
Whenever I stop and start my database for taking a full backup all my
three databases are disconnected.
Can someone suggest me a way to isolate these databases so the instance
restart for one does no affect the other two.

Oct 20 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Have you looked at the QUIESCE DATABASE command? It should allow you to
do an offline backup of each database without shutting down the instance
or the other two databases. Note that it doesn't forbid access to the
database; it restricts it to those having some form of maintenance
authority over it.

Phil Sherman
Racerx wrote:
Hi All:

I use db2 v8.2 on AIX platform.
I have three databases using the same instance.
Whenever I stop and start my database for taking a full backup all my
three databases are disconnected.
Can someone suggest me a way to isolate these databases so the instance
restart for one does no affect the other two.
Oct 20 '06 #2

P: n/a
"Racerx" <p.**********@gmail.comwrote in message
news:11*********************@f16g2000cwb.googlegro ups.com...
Hi All:

I use db2 v8.2 on AIX platform.
I have three databases using the same instance.
Whenever I stop and start my database for taking a full backup all my
three databases are disconnected.
Can someone suggest me a way to isolate these databases so the instance
restart for one does no affect the other two.
You can do a full on-line backup if you have archive logging configuring. If
you include the logs in the backup (the logs that are active during the
backup) then it is not much different than a off-line backup.
Oct 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.