Unsolved
This post is more than 5 years old
1 Rookie
•
65 Posts
0
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


