Ian wrote:
hrishy wrote: Hi All
I was just wundering is there any dictionary view which would tell me
which is the current active online log.I am a db2 database newbie
please bear with me.
You can get this information from the command 'get db cfg for <dbname>',
but this is not exposed within the database.
Good luck,
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Hrishy,
What Ian says is true.
However (noting you are a newbie : your words) be aware that logs will only
be archived at all if you have set the LOGRETAIN or USEREXIT DB CFG
parameter for the database. The default is to use "circular logging" which
is not really suitable for a production environment.
Note also that the default log path when a database is created is under the
default directory (i.e. in the same disk area as tablespaces are put by
default).
It is a very good idea to change this to another disk : you do this by
"UPDATE DB CFG FOR dbname USING NEWLOGPATH path". Also a good idea to look
at the MIRRORLOGPATH and OVERFLOWLOGPATH parameters, to set up dual logging
and to specify an area to bring back logs from archive which are needed for
rollbacks if infinite logging is enabled.l
HTH
Phi
--
Philip Nelson
ScotDB Limited
http://www.scotdb.com
(te*****@scotdb.com)