2 sets of Archived Logs in v7.2? 
Author Message
 2 sets of Archived Logs in v7.2?

All,
I'm running DB2 v7.2 fix pack 4 on AIX platform.  I'm using userexit
pointing to ADSM (TSM) for archiving. I noticed that when DB2 performs
automaitc archiving I get 2 sets of logs with the same names (f.e.
S000006.LOG). I see those 2 sets in the ARCHIVE.LOG file and also when I
run db2adutl command. They look exactly the same and I don't understand
why DB2 issues 2 requests.
Any ideas will be very much appreciated.
Bellow is part of my ARCHIVE.LOG file.
Thanks,
   Yuri

*******************************************************************************

*
Time Started:      Wed Feb 27 13:42:29 2002

Parameter Count:      8
Parameters Passed:
Database name:     PMRTD01
Logfile name:      S0000006.LOG
Logfile path:
/db2cat01/instd4/pmrtd01/instd4/NODE0000/SQL00001/SQLOGDIR/
Node number:       NODE0000
Operating system:  AIX
Release:           SQL07022
Request:           ARCHIVE
System Action:     ARCHIVE from
/db2cat01/instd4/pmrtd01/instd4/NODE0000/SQL000
01/SQLOGDIR/ file S0000006.LOG to ADSM for database PMRTD01
Media Type:        ADSM
User Exit RC:      0
Time Completed:    Wed Feb 27 13:42:30 2002

*******************************************************************************

*******************************************************************************

*
Time Started:      Wed Feb 27 13:43:40 2002

Parameter Count:      8
Parameters Passed:
Database name:     PMRTD01
Logfile name:      S0000006.LOG
Logfile path:
/db2cat01/instd4/pmrtd01/instd4/NODE0000/SQL00001/SQLOGDIR/
Node number:       NODE0000
Operating system:  AIX
Release:           SQL07022
Request:           ARCHIVE
System Action:     ARCHIVE from
/db2cat01/instd4/pmrtd01/instd4/NODE0000/SQL000
01/SQLOGDIR/ file S0000006.LOG to ADSM for database PMRTD01
Media Type:        ADSM
User Exit RC:      0
Time Completed:    Wed Feb 27 13:43:40 2002

*******************************************************************************



Tue, 17 Aug 2004 01:01:02 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Multiple archive log processes archiving same log file

2. Q: Setting the group write permission on redo log archives

3. archive question --- too many archive logs generated during data load

4. How to check the corruption in online redo logs and archived logs

5. Log Miner : Performance problem querying archived logs

6. Table v$log and archived log files ?

7. Redo logs and archive logs

8. set returning functions in v7.3

9. Setting Isolation Level in ODBC.ini on AIX (DB2 V7)

10. SQL v7 Transaction Logs

11. SQL v7 Moving/Shrinking transaction logs

12. Corrupted Log File in V7


 
Powered by phpBB® Forum Software