This article provides few tips for Networker DB2 backup configuration and log collection.

EMC NetWorker Module for Databases and Applications (NMDA) is a NetWorker addon module that provides data protection services for multiple enterprise database environments including DB2 support.

Setup and configuration

DB2 configuration file /nsr/apps/config/nmda_db2.cfg example:

DB2_NODE_NAME=db2inst1

DB2_USER=db2inst1

DB2INSTANCE=db2inst1

INSTHOME=/home/db2inst1

NSR_SERVER=

NSR_DEBUG_LEVEL=5

NSR_DIAGNOSTIC_DEST=/nsr/apps/logs

NSR_DATA_VOLUME_POOL='Default'

NSR_LOG_VOLUME_POOL='Default'

NSR_SAVESET_RETENTION='6 months'

NSR_SAVESET_BROWSE='6 months'

On DB2 server:

- Set DB2 password in NMDA configure file

> nsrdaadmin -P -z /global/db2dg1/db2inst1/DB2_CFG.sample

On NetWorker server, in client resource

- “Save set:” field

  DB2:/DBNAME/NODE0000

- “Backup command:” field

  nsrdasv -z

Manually backup in Windows environment:

> db2 backup db test1 LOAD "C:\Progra~1\Legato\nsr\bin\libnsrdb2.dll" options @e:\tmp\DB2_CFG

Manually backup in UNIX environment (Solaris):

> db2 backup db sample LOAD "/usr/lib/libnsrdb2.so" options @/space1/db2home/db2inst2/DB2_CFG

Backup and Recovery – Archivelog backup and recovery

DB2 Transaction log backup

Update Logarchmeth1, Logarchopt with db2 command

  db2 update db using LOGARCHMETH1 VENDOR:/usr/lib/libnsrdb2.so

  db2 update db using LOGARCHOPT1 @/db2inst/DB2_CFG

Verify with db2 get db cfg command

  db2 get db cfg for

  - First log archive method                 (LOGARCHMETH1) = VENDOR:/usr/lib/libnsrdb2.so

  - Options for logarchmeth1                  (LOGARCHOPT1) = @/db2inst/DB2_CFG_online

Troubleshooting tips:

Set debug level 9 in “Backup command

> nsrdasv –D 9 -z e:\tmp\nmdb2_demo2.cfg

Set debug files in DB2_CFG file

NSR_DEBUG_LEVEL=9

NSR_DIAGNOSTIC_DEST=/nsr/apps/logs

Note: By default, error messages are written to /nsr/apps/logs/

• nsrdasv_DB2_2013_10_22.04_25_34.22249.log
• Libnsrdb2_default.log
• nmda_db2.messages.raw
• nsrdb2ra.log
• xbsa.messages
• db2diag.log (in DB2 SQLLIB/DB2 install directory)

Useful DB2 command of DB2 configuration information

To see the current values for those administration configuration parameters relevant to the DAS(DB2 Administration Server):

> db2 get admin cfg

To discovery of administration Servers, instances, and databases:

> db2 get dbm cfg

> db2 get db cfg for

Show DB2 service level command:

> db2level

Showing All Current Profile Registry Settings

> db2set –all

To list database directory & instance:

> db2 list db directory

> db2 get instance

Author: Fenglin Li

iEMC APJ

Please click here for for all contents shared by us.