Unsolved

This post is more than 5 years old

1 Rookie

 • 

65 Posts

1192

January 17th, 2010 03:00

DB2 failarchpath funcation with networker module

Hi all

When I use DB2 failarchpath with a directory,that's mean is open the db2 cfg of failarchpath.If we disable the VONDER:/us/lib/libnsrdb2.o,the failarchpath did  not  become effective.

But if the Logarchmeth1 is a disk,the failarchpath will become effective.

I had compared the different of the Logarchmethd1,VONDER and DISK,there is only the rc code different.

FAILARCHPATH is supposed to be a 'temporary' location for archived files while the main archive location/device is offline.

Szenario:

1.LOGARCHMETH1 is VONDER:/usr/lib/libnsrdb2.o

   CFG as :

     Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/

     First log archive method (LOGARCHMETH1) = VONDER:/usr/lib/libnsrdb2.o

     Options for logarchmeth1 (LOGARCHOPT1) = @/nsr/db2.cfg
     Second log archive method (LOGARCHMETH2) = OFF
     Options for logarchmeth2 (LOGARCHOPT2) = @/nsr/db2.cfg
     Failover log archive path (FAILARCHPATH) = /db2test/
     Number of log archive retries on error (NUMARCHRETRY) = 1
     Log archive retry Delay (secs) (ARCHRETRYDELAY) = 5

And I insert data to a tables continuous,then shutdown nsr process.but the log will write to the /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.that mean is the failarchpath is not effective.

with db2diag.log messages:Log archive failed with rc 11 for LOGARCHMETH1.

2.LOGARCHMETH1 is DISK:

   CFG as :

     Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/

     First log archive method (LOGARCHMETH1) = DISK:/db2archlog/

     Options for logarchmeth1 (LOGARCHOPT1) = @/nsr/db2.cfg
     Second log archive method (LOGARCHMETH2) = OFF
     Options for logarchmeth2 (LOGARCHOPT2) = @/nsr/db2.cfg
     Failover log archive path (FAILARCHPATH) = /db2test/
     Number of log archive retries on error (NUMARCHRETRY) = 1
     Log archive retry Delay (secs) (ARCHRETRYDELAY) = 5

And I insert data to a tables continuous,then make the directory /db2archlog full.The log will write to the /db2test/.that mean is the failarchpath is effective.

with db2diag.log messages:Log archive failed with rc -2045837302 for LOGARCHMETH1.

Question:

What is wrong with the failarchpath?

ENV:

OS:aix 5.3

DB2:8.1 fixpak 15

NetWorker:7.5.1

Module for DB2:2.1

No Responses!
No Events found!

Top