NetWorker: NMDA DB2 Troubleshooting Guide

General information and Logs:

1. NetWorker Server and client OS and version: NetWorker: Methods for Identifying NetWorker Software version
2. NMDA for DB2 version and build number
3. Problem description, get details regarding what specific actions are failing (backup, restore). Provide a screenshot or log snippet for the backup failure
4. General system logs:

• Policy logs:

Linux: /nsr/logs/policy/POLICY_NAME/WORKFLOW_NAME
Windows (Default): C:\Program Files\EMC NetWorker\nsr\logs\policy\POLICY_NAME\WORKFLOW_NAME

• NetWorker server and Client daemon.raw:

Linux: /nsr/logs/daemon.raw
Windows (Default): C:\Program Files\EMC NetWorker\nsr\logs\daemon.raw

NetWorker: How to use nsr_render_log to render .raw log files

Issue regarding Database Backup

1. Is this a new install?
   
   If Yes:

• Check the compatibility matrix to ensure that there are no support conflicts: E-Lab Interoperability Navigator 2.0-HOME (You must sign in with your Dell support account)
• Check NMDA documentation to for configuration and best practices: Support for NetWorker Module for Databases and Applications | Manuals & Documents  (You must sign in with your Dell support account)
• Is the DB2 client created through NMC client create wizard? If not, try to use Wizard and collect outcome.

If No:

• Was it working before? Get: mminfo -avot -r name,savetime,pool,ssflags -q client=<db2 client name>
• What changed in the environment prior to the issue appearing?

2. Does manual backup work?

• UNIX or Linux: 

  db2 backup db <db name> load /usr/lib/libnsrdb2.so options @/<path/to/db_backup>.cfg> without prompting
  

• Windows:

  db2 backup db <db name> load c:\\path\linbsrdb2.dll  options @/<path/to/db_backup>.cfg> without prompting
  

3. Issue regarding Archive log backup? 

• Log in to DB2 instance with DB2 instance administrator. Get output of:

db2 get db cfg for <DB name>

• Get the DB2 archive log backup configuration file <db2archive>.cfg file on the DB2 client.

4. Error message and log excerpt. Check knowledge base for any articles specific to the errors found.
5. Backup Device type (Tape, AFTD, Data Domain, VTL or other)
6. Debug: Set the Debug option in the db2.cfg file

   NSR_DEBUG_LEVEL= 1 ~ 9 (most cases 3~5)
   
   NSR_DIAGNOSTIC_DEST= /nsr/apps/logs (make the folder full permission to db2 account)
   
   NSR_DPRINTF=TRUE  (enables NetWorker debug for modules)
   

4. If further analysis is needed, get an NSRGET bundle from both the NetWorker server and client: NetWorker: How to Use the NSRGet NetWorker Data Collection Tool

Restore failures:

On the DB2 host (NetWorker client) where the data is to be restored, type the DB2 restore command appropriate for the operating system as follows:

Linux and UNIX:

$ db2 restore db <source DB name> load /usr/lib/libnsrdb2.xx open sessions <n>  options @/pathname/nmdb2.cfg taken at yyyymmddtttt into <target DB name>

Windows:

$ db2 restore db <source DB name> load <drive>:\<NetWorker_Install_Directory>\nsr\bin\libnsrdb2.dll open sessions <n> options @<drive>:\pathname\nmdb2.cfg taken at yyyymmddtttt into <target DB name>