When do I have to take a full offline backup for successful data protection operations using Commvault?
When a database is in a roll forward recovery mode for the first time (when the LOGARCHMETH1 parameter value is set to either LOGRETAIN, USEREXIT, DISK, TSM, or VENDOR), perform a traditional full offline backup for the database. In case of a HADR setup, perform the traditional full offline backup on the primary database.
Can I perform DB2 database backups as a user with no operating system password?
Yes, you can perform your DB2 database backups as UNIX operating system user with no password.
Can we protect data on non-global zones if the File System iDataAgent is installed only on the global zone?
Yes. We can protect file system data on non-global zones if the File System Agent is installed only on the global zone. However, in order to enable consistent backups of application specific data on the non-global zones, you will need to install the corresponding application specific iDataAgent on the non-global zone.
How do we protect DB2 data on a non-global zone?
In order to enable consistent backups of DB2 data on a non-global zone, you need to install the DB2 iDataAgent on the non-global zone.
How are data only backup jobs retained?
If a data backup job does not have a linked log backup, it will be retained based on the retention days only and does not follow the retention cycles. However, if the data backup job is linked to a log backup job, the retention will be based on both the number of days as well as the retention cycles.
How is a log backup scheduled?
For information about log backup schedules, see Modifying the Threshold Value for Log Backups.
How can we prevent log backup failures due to different database and alias names?
To prevent archive log backup failures, ensure that the name that you select is the actual name of the database and not the alias name for the database. If the database name and the corresponding alias name are different, both names are displayed under Available DB Names; if both names are the same, the name that is displayed is the database name. To find the database names and their aliases, run the following command as a DB2 instance owner on the DB2 client:
C:\Program Files\IBM\SQLLIB\BIN>db2 list db directory
System Database Directory
Number of entries in the directory = 2
Database alias = TESTDBS1
Database name = TDBS1
Local database directory = C:
How are Command Line backup images displayed in the CommCell Console?
When you run DB2 command line offline/online backup jobs, the backup image is always displayed as online in the CommCell Console.
Can I submit a backup job when the DB2 instance is down?
Yes, the job remains in the pending state until you manually start the instance.
Can we run a backup operation for DB2 encrypted databases?
Yes, you can run a backup operation for DB2 encrypted databases.
Why does application command line log backup gets launched even though disk caching is enabled for frequent log backups?
Application command line log backups get launched to back up existing logs that are present under the local archive staging directory. Further, log archival goes directly to the MediaAgent dump location by avoiding the local staging directory.
For more information, see Disk Caching for Frequent Log Backups.
Low dedupe on encrypted db backups
When a database backup is encrypted, it is no longer affected by subsequent attempts to reduce its size. For more information, see Encrypted backups.
-
To achieve dedup on encrypted database, we need to unset ENCRLIB db cfg parameter.
Example:
[db2inst5@hjdb2rec ~]$ db2 connect to test2
Database Connection Information
Database server = DB2/LINUXX8664 11.5.4.0
SQL authorization ID = DB2INST5
Local database alias = TEST2
[db2inst5@hjdb2rec ~]$ db2 "update db cfg for test2 using ENCRLIB ''"
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
-
Use DB2 compression with encryption to reduce the backup size. Commvault dedupe would still be low.
It can be achieved by setting ENCRLIB database configuration to use libdb2compr_encr.so library.