IntelliSnap - Troubleshooting - DB2 MultiNode

Unable to discover DB2 instances from the CommCell Console

If you are unable to discover DB2 instances from the CommCell Console and get the below error message:

Unable to execute SrvDb2Agent to populate CV tables for DB2

You need to restart the services and then try to discover the Db2 instance from the CommCell as DB2 Instances cannot be discovered from the CommCell when the services are down on the DB2 client computer.

Sometimes, if the DB2 instance could not find the db2ls binary file location, then the DB2 instance will not be discovered from the CommCell Console.

db2ls binary file location is an user defined path. Generally, it is under /usr/local/bin. Auto-discover instance depends on this binary file. Hence, verify whether this db2ls binary file is located in the root of .profile. If it is not present in the specified root location, then add the following in .profile of root home:

export PATH=$PATH:/usr/local/bin

Unable to discover DB2 databases from the CommCell Console

If the DB2 instance is configured with incorrect credentials, then the DB2 databases will not be discovered from the CommCell Console.

In order to discover the databases, you need to enter the correct user account credentials for the DB2 instance.

Log Only backup is failing after a DB2 upgrade from 32-bit to 64-bit

When you upgrade from 32bit to 64bit, the log only backup will fail if you have not linked the sqllib/lib library to a correct lib64 for 64bit DB2.

Make sure to link the sqllib/lib library to a correct lib64 for 64bit DB2 when you upgrade DB2 from 32bit to 64bit.

Completed with one or more errors

Backup jobs from the DB2 Agent are displayed as "Completed w/ one or more errors" in the Job History window in the following cases:

• The job is killed after creating some valid data archive files. For example, after running a database backup, the job is killed during the log files phase.

• An online, offline, or command line backup job completes the data phase but fails during log phase.

• A log file-only backup job fails or is killed after you backup some log files.