Database log files are truncated when the last user disconnects from the
database or when you deactivate the database. If you have several client
applications that
connect
do some work
disconnect
then when no user is connected, the database is shutdown and the log
truncated. The next user to connect will have the overhead of building all
the shared memory structures and will start logging in the next log file.
Therefore, it is better to keep the database active either by having one
persistent connection or using the activate database command.
Chris Eaton
"kishore lingamallu" <[EMAIL PROTECTED]>@lists1.ba.best.com on
05/23/2001 01:54:53 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: DB2EUG: UDB log files
Hi
In one of our system the udb log files are tiny.
Any body knows why do they form like that, though the log file
size(logfilsiz) is set to 5000 pages.
Does the log files gets closed for every transaction? If so, is there any
way I can tell user the log file for multiple transactions.
Is there any way I can tell database to use the log files till it reaches
the size defined?
Platform: UDB 6.1 FP4, NT 4
Thanks
Kish
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
