Kishore:
The log files get truncated after the last connection to the database
terminates. You can activate the database to prevent this from happening. It
will also improve first connection performance to the database. The command
to execute is :
db2 activate database dbname
Manas.
----- Original Message -----
From: "kishore lingamallu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 1:54 PM
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
