The ARCHIVE LOG command was added in V 7.2, check the README file.
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager,
DB2 / LUW Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
[EMAIL PROTECTED]
t.com
Sent by: To
[EMAIL PROTECTED] [EMAIL PROTECTED]
ash.org cc
Subject
07/23/2003 05:37 Re: [DB2EUG] db2 archive log
PM
Please respond to
[EMAIL PROTECTED]
t.com
Carla had a question about DB2 ARCHIVE LOG.
I don't see anything about ARCHIVE LOG in the DB2 V7.2 documentation, so it
looks like the command is only available in DB2 V8. You must also be using
linear (recovery) logging, and not circular logging, in order to archive
log files at all.
In V8, ARCHIVE LOG is a command in that tells the database to close the
current log file in order to make the file safe for transport. It would
probably be less confusing if IBM had named the command CLOSE CURRENT
LOGFILE, which is what it really does. Unless you have defined a user exit
that processes each logfile after it is closed, the database does nothing
more than close the logfile and leave it in its current location (the log
directory).
Hope this helps,
Fred Sobotka
IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX, and
Windows
CollegeNET, Inc.
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
