Data Backup and Recovery

Multiple DB2 instances

debpearenetapp
3,228 Views

How do I configure the DB2 plugin for different instance names to find the databases?  I am running DB2 on windows and using SnapDrive to do the snapshots. I appreciate the help.

Thanks.

Deb

1 ACCEPTED SOLUTION

ktenzer
3,228 Views

Hi Deb,

The Snap Creator DB2 plugin does not backup an instance it backs up one or more databases. You must specifcy database. If you have multiple databases on the same host you can do this as well. Below is example:

DB2_CMD=C:\IBM\SQLLIB\BIN\db2cmd.exe -c -w -i Z:\IBM\SQLLIB\BIN\db2.exe

DB2_DATABASES=db1:user1;db2:user2;db3:user3

Regards,

Keith

View solution in original post

2 REPLIES 2

ktenzer
3,229 Views

Hi Deb,

The Snap Creator DB2 plugin does not backup an instance it backs up one or more databases. You must specifcy database. If you have multiple databases on the same host you can do this as well. Below is example:

DB2_CMD=C:\IBM\SQLLIB\BIN\db2cmd.exe -c -w -i Z:\IBM\SQLLIB\BIN\db2.exe

DB2_DATABASES=db1:user1;db2:user2;db3:user3

Regards,

Keith

debpearenetapp
3,228 Views

Keith,

Thanks for your response. I was making a mistake and not changing the IP address to the correct server in my SC_AGENT settings.

Thanks again.

Deb

Public