Not sure what you mean by archivelog mode, if you mean logretain, and
perhaps userexit you can tell by looking at your db config. 'db2 get db
config for <database>' and see if LOGRETAIN and USEREXIT are enabled. If so
you are archiving logs, where will depend on how userexit is written. If
you just have LOGRETAIN on then the logs are simply being kept in the logs
directory.

You would only apply them in a online restore - rollforward scenario or
during a crash recovery. Crash recovery would hapeen automatically,
rollforward would be issues as art of a restore command, or perhaps as a
separate step afterwards.

See: 'db2 ? Rollforward'

-----Original Message-----
From: edwinuy
[mailto:db2udbdba-ezmlmshield-x61840898.[Email address protected]
Sent: Wednesday, September 29, 2004 12:16 PM
To: LazyDBA Discussion
Subject: HOW TO CHECK IF DB is in ARCHIVELOG or NOT


hi gurus,

does anyone know what the command to execute to check if my db is in
archivelog mode or not? if it is in archivelog mode, how do I apply the
logs?

Cheers,

EDWIN ONG UY
UNIT 4,64 GRANGE ROAD
MT EDEN 1003
AUCKLAND, NEW ZEALAND
Email: [Email address protected]
Mobile: 64-021-622092

-------------------------------------
This email is intended solely for the named recipient/s and as such is
confidential and may contain information that is privileged. If you have
received it by mistake, please notify the sender. You must not use, copy,
distribute or disclose its contents to anyone other than the addressee. This
email and any attachments might not be free from computer viruses or other
defects.



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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