Log files are always closed when the database is either disconnected and/or deactivated. Seems to me that a) You have not issued any activate db command andb) all of your connections have issued a connect reset. No connections, close all files, free resources and close the db2 application. Therefore your log file gets closed and "chopped" at that point. HTH, Pierre. kishore lingamallu wrote: > 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
begin:vcard n:Saint-Jacques;Pierre tel;cell:514-233-8679 tel;fax:514-737-1268 tel;work:514-737-4515 x-mozilla-html:FALSE org:SES Consultants Inc. adr:;;233 Simcoe Cr.;Mount-Royal;QC;H3P 1X1;Canada version:2.1 email;internet:[EMAIL PROTECTED] title:President fn:Pierre Saint-Jacques end:vcard
