Configuring Database

[Racerx]

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.

[Phil Sherman]

Re: Configuring Database

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.
>

[Mark A]

Re: Configuring Database

"Racerx" <p.paingankar@g mail.comwrote in message
news:1161357172 .400608.30350@f 16g2000cwb.goog legroups.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.