Working with third party backup solutions in DB2 can be a bit of a challenge at times. About a year ago I setup an EMC NetWorker backup environment for DB2 9.5 running under AIX.
For this example we will call the database 'db2demo'.
We firstly, need to get access to the EMC NetWorker backup environment and to create the xbsa_config file. In our case the xbsa_config file was created in the top level of the DB2 instance owner directory, but it could be anywhere.
The parts of the xbsa_config file the dba supplies are as follows.
The DB2_PASSWD is generated with the nsrdb2sv command. For example:
nsrdb2sv -p <password> -f <filename>
You only need the password if you are having the backup environment start the backups for you. If you initiate your backups from the DB2 side this value is not used.
At this point you should validate that you can in fact backup to NetWorker. It makes sense to test that now before turning on log backups, even though you will need to do another backup again after you turn on log backups. There is nothing worse than being in a backup pending situation if your networker config isn't working.
> db2 backup db db2demo load /usr/lib/libnsrdb2.so db2demo @/data/db2demo/xbsa_config compress"
Assuming that worked then we turn on log file archiving as follows
> db2 update db cfg for db2demo using LOGARCHMETH1 'VENDOR:/usr/lib/libnsrdb2.so'
> db2 update db cfg for db2demo using LOGARCHOPT1 @/data/db2demo/xbsa_config
Now rerun a offline backup again.
> db2 backup db db2demo load /usr/lib/libnsrdb2.so options @/data/db2demo/xbsa_config compress
If that works generate some traffic so log files get backed up. Validate that this is successful. Then test the restore and roll forward.
> db2 restore db db2demo load /usr/lib/libnsrdb2.so options @/data/db2demo/xbsa_config_sam taken at <timestamp> without prompting
> db2 rollforward database quote to <timestamp> using local time and stop;
If all went well then you are now using EMC NetWorker.
If it didn't and you get errors like SQL2025, SQL2062, SQL2071, SQL2079 etc you will need to consult the EMC NetWorker Module for DB2 Administration Guide which has some explination.
These are errors from the backup software passed through the database. Additionally changing the DEBUG level of various variables in the xbsa_config file will give you additional info but be warned 9 is the highest and can generate an enormous amount of data. For example: