If you look at the 'db2 list history backup' command you can see the history
of you backups and determine which logs are required for which backups.

Type 'db2 ? list history' for usage'

-----Original Message-----
From: Joe Philip
[Email address protected]
Sent: Wednesday, May 19, 2004 2:58 PM
To: LazyDBA Discussion
Subject: newbie questions on archive logs


It seems like there are many newbie DB2 dbas like me here (mostly moved from
Oracle). In oracle, archive logging is different. You can issue a log switch
and then safely archive off all the logs which are older than the current
ones.

DB2 seems to be different. You are never sure which one you can archive off
- I am still learning the userexit stuff.

So, I would invite the DB2 experts in the list to send the answers on these
newbie transaction/archive logs to the list directly (instead of just
sending only to the original sender).




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe, e-mail: [Email address protected]
For additional commands, e-mail: [Email address protected]


DB2 & UDB email list listserv db2-l LazyDBA home page