Well,log files are database level.

If you are receiving log full error,you can do the following:
1. You can increase your logfilsiz,logprimary,logsecond param.
2. You can decrease the commit count and perform frequent commits.
3. Before starting the transaction you can activate not logged initilally (for the table). However,the problem with the last option(3) is that if your transaction fails at any point your table will be corrupted and you will have to drop and recreate the table again,so before using the last option,please export the table and generate its ddl's so that they can be used later.

Regards,
I

________________________________

From: Sheuehua [mailto:db2udbdba-ezmlmshield-x99254553.[Email address protected]
Sent: Tue 24/10/2006 09:19
To: LazyDBA Discussion
Subject: log files questions







Hi,
Questions on logfiles below:
are they per instance or per database level ?
Thanks for help!!
Sue



Log file size (4KB) (LOGFILSIZ) = 32761
Number of primary log files (LOGPRIMARY) = 35
Number of secondary log files (LOGSECOND) = 25


**********************************************************************
This e-mail transmission and any attachments that accompany it may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law and is intended solely for the use of the individual(s) to whom it was intended to be addressed. If you have received this e-mail by mistake, or you are not the intended recipient, any disclosure, dissemination, distribution, copying or other use or retention of this communication or its substance is prohibited. If you have received this communication in error, please immediately reply to the author via e-mail that you received this message by mistake and also permanently delete the original and all copies of this e-mail and any attachments from your computer. Thank you.
**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html





***************************************************************************************************************************
This e-mail communication and any attachments may be privileged and confidential to Hexaware and are intended only for the
use of the recipients named above. If you are not the intended recipient, please do not review, disclose, disseminate,
distribute or copy this e-mail and attachments. If you have received this email in error, please delete the same alongwith
all attachments thereto and notify us immediately at [Email address protected] .
***************************************************************************************************************************


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