Skip to Content
avatar image
Former Member

AIX 5.3 on DB2 9.1

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 05, 2015 at 10:40 AM

    Hi Rajavelu

    Could you please provide the you third party software detail.

    Thanks

    Sadiq

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Sadiq Iqbal Siddiqui

      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

  • avatar image
    Former Member
    Jun 09, 2015 at 12:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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