470,641 Members | 1,592 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

Configuring Database

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
2 1201
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
"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.

By using this site, you agree to our Privacy Policy and Terms of Use.