ARCHIVE LOG doesn't by itself put the logfiles anywhere. They will stay in whatever directory is specified in the DB config. The only thing it does is to close the active log. Or logs, if you issue it on all nodes of a EEE system.
It only works if you have your database in archive log mode.
Applications can be connected while you execute it, as long as you're not connected with the session you execute it from. It will flush any log buffers to disk before the log is actually closed.
To actually move logs out of the default log directory for more meaningful archiving, use a userexit. If you have the DB userexit parameter set to yes, every time a log is closed (either because it's full, or because an online backup finished, or because you issue archive log) a userexit program will be called. This can then be used to move the log files over to another location, which can be disk, maybe tape, or TSM. It's very useful and you may want to take a close look.
Hope this helps,
/T
Tomas Hallin
Database Administration
Robert Half International
Pleasanton, CA
-----Original Message-----
From: Carla Cristina Alonzo Ducl�s [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 23, 2003 2:06 PM
To: [EMAIL PROTECTED]
Subject: [DB2EUG] db2 archive log
Hello,
I�m planning a backup strategy e I�d like to know more about archive db2
logs.
I�ve read some documents and I didn�t understand where db2 put archived
logs after the command:
# db2 archive log for database <database name>
So, I have some doubts. I�ll be so gratefull with any help. :)
How do I have to proceed after this command has been executed?
Can I execute this command with online database?
Do I have finish all connection to the database before execute this command?
I have db2 7.2.7 and AIX 4.3.3.
Thanks a lot,
Carla
--
Carla Alonzo Ducl�s
Systems Administrator
Solvo S.A. - Servi�os de Miss�o Cr�tica
@ www.solvo.com.br
-
::: 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
