AIX 5.3 on DB2 9.1

[Former Member]

Hi, We are using ECC 6.0 and DB2 9.1 on AIX 5.3. Both DEV and QAS instances were installed on one single machine(host). Now are going to take the backup of those Database instances using third party db2 backup client software. But it is taking only one instance ie. (DEV). So can we create one db admin user for both database instance and how we can achive it? Please do help us regarding this? Thanks and Regards, R Rajavelu

[Former Member]

A combined backup of both the instances simultaneously is not possible, you have to take two backups for two database instances dev/QAS.

Thank you,

Dev

[Former Member]

Hi Bhudev Sharma, Thanks for your reply. You are correct, we have to take the backup of each database instances separately. But I am asking, can we create one db user for both the database instances and will give the same db user to third party backup software. Then it will identify the two datbase instances in  single host machine. then only I can take the backup of both the db instance by separately. Thanks and Regards, R Rajavelu

[former_member182505]

Hi Rajavelu

Could you please provide the you third party software detail.

Thanks

Sadiq

[Former Member]

HI Sadiq, Thanks for your reply. emc avamar client , we have used for taking online backup through avarmar client software. Please do suggest same on this. Thanks and Regards, R Rajavelu

[former_member182505]

Hello Rajavelu

Please check with emc avamar client team, they have better understanding on this,

Thanks

Sadiq

[Former Member]

Hi, Thanks for your reply, They are suggessting us to create one db user for both the database instances and will give the same db user to third party backup software. Then it will identify the two database instances in single host machine. then only they can take the backup of both the db instance by individualy. Please let us know the steps to create a one db user for two database in DB2 9.1 and AIX 5.3. Thanks and Regards, R Rajavelu