How to perform an online DB2 database backup using the VERITAS NetBackup (tm) DB2 database agent

Article: 100015339
Last Published: 2013-10-23
Ratings: 2 0
Product(s): NetBackup & Alta Data Protection

Problem

How to perform an online DB2 database backup using the VERITAS NetBackup (tm) DB2 database agent

Solution

In order to perform an online DB2 database backup, you need to modify the DB2 backup command line in the sample offline script to add the keyword "online" as follows:

CMD_LINE="db2 BACKUP DATABASE sample online load /usr/openv/netbackup/bin/nbdb2.lib OPEN 4 SESSIONS BUFFER 1024"

Change nbdb2.lib above to match the correct NetBackup library name for your specific host:

Solaris-32 = nbdb2.so
Solaris-64 = nbdb2.so64
AIX-32      = nbdb2.sl
AIX-64      = nbdb2.sl64

* Note: Online backups are only available for databases configured with logretain or userexit enabled. *
 
 

 

Was this content helpful?