Multi-Instance DB2 Backup Configuration

Hi Iggy,

Thank you for reaching out. Please find the answers inline:

1. Are multiple Commvault instances required to protect multiple DB2 instances?
No. You can back up multiple DB2 instances on the same server using a single Commvault instance.

2. Can different users or groups own different DB2 instances?
If the DB2 instance owners belong to different groups, create a common group and add the respective DB2 instance OS users to that group.
Then, assign the Commvault installation group ownership to this new common group using the cvpkgchg utility.

Refer:

https://documentation.commvault.com/2024e/commcell-console/changing_unix_groups_and_permissions_on_unix_clients.html

3. Should the Db2_config.sh script be run from each user owning the DB2 instance (if supported)?
Yes. The Db2_config.sh script should be executed as the DB2 instance owner for each DB.
This ensures that the correct DB2 configuration parameters are applied for each database.

4. Are the configuration parameters different for each DB2 instance as explained here (https://documentation.commvault.com/2024e/commcell-console/setting_db2_configuration_parameters.html)?

This configuration is independent of the number of DB2 instances. It is applied at the database level.

If the environment includes multiple instances or multiple databases, use the following format in the Name field. You will need the additional settings as below to ensure archiving path is assigned to each instances:

<db2 instance name>_<db name>_sDB2_ARCHIVE_PATH

<db2 instance name>_<db name>_sDB2_AUDIT_ERROR_PATH

<db2 instance name>_<db name>_sDB2_RETRIEVE_PATH

Refer:

https://documentation.commvault.com/2024e/commcell-console/modifying_db2_archive_path_02.html

https://documentation.commvault.com/2024e/commcell-console/modifying_db2_audit_error_path_02.html

https://documentation.commvault.com/2024e/commcell-console/modifying_db2_retrieve_path_03.html

Hi Sarvesh,

The same error is still generated.

I have added the user to the group of the first DB2 instance and CV instance.

user1    group1    CV_Instance001

user1    group1    db2instance1

user2    group2    db2instance2 → group2 as secondary group.

Is there anything additional to be done?

Regards,

Ignes

Hi.

I tested this in my lab environment where I was able to backup multiple DB2 instances owned by different user accounts with a single Commvault instance.

Now with my customer it is not working.

Instance002 is the only installed Commvault instance.

Error:

Db2 vendor library reported an error:[---- error report ---- app. message = backing up the database line = 6198 file = CIDb2AgentLib.cpp SQLCODE = -2079 SQL2079N An error was reported by the shared library "/opt/Commvault/commvault2/Base64/libDb2Sbt.so". Return code: "-1". ---- end error report----]. [Backup] operation could not be completed.

From all the feedback received from the customer the UNIX group owning the Commvault installation also contains the DB2 instance users.

Running a readiness check shows all ready including the folders that is required for archive/retrieve/audit_error.

Does anyone have an idea?

I did log a support case but no concrete feedback yet.

Thank o​​​​​you.

Ignes

Hi Ignes,

I see that you have already created case 251104-573 for this issue. Our team is actively working on it, and we will resolve it as soon as possible. I will get in touch with the engineer handling the case to ensure timely updates.

Regards,

Sarvesh