Showing posts with label emc. Show all posts
Showing posts with label emc. Show all posts

Tuesday, October 15, 2013

the networker config file

the networker config file

  1. for backups
    1. all you need from the db2 command line is the backup server and backup client ( if you schedule your backup from the networker server or want to use nsrdb2sv /nsrdasv, you need more parameters)
      1. NSR_SERVER=backupservername
      2. NSR_CLIENT=nameoftheclientdefined in networker
      3. it's better to have a different log and data volume to avoid tape mount conflict that blcok the backup from completion 
    2. if you forget an '@' sign you will get error sql2062n reason code 3
  2. for log archiving
    1. don't forget @ in front of the config file when configuring logarchopt1
    2. if you change the config file, the new values are not taken up immediately,it's better to restart the db2vend processes (i.e. kill them )

Friday, October 11, 2013

nsrdb2rlog does not work with error message related to file privileges

nsrdb2rlog doe snot work with error message related to privileges



nsrdb2rlog -a dbname -d . -C 1 -E 13867 -S 13856 -s networker_server
Unable to create temporary configuration file please check permissions


solution:

use truss to see which system call cause the error:
truss nsrdb2rlog -a dbname -d . -C 1 -E 13867 -S 13856 -s networker_server


near the end of the output you can see that a certain file is not being created due to privileges issues,
then you can correct the privileges on the folder to make it writable for the user you sue for the nsrdb2rlog command



DB2 restore seems to hang using backup saved on networker

DB2 restore seems to hang using backup saved on networker.

check that the nsrladb is setup correctly ( no reference to a different server than the server you are trying to restore on)

solution:

  1. stop networker client
  2. rename /nsr/res/nsrladb
  3. restart networker client
now the restore command should start processing.