Log files are at database partition level (bit of a DBA nitpick there).

-----Original Message-----
From: Imran Sayed
[mailto:db2udbdba-ezmlmshield-x16021926.[Email address protected]
Sent: 24 October 2006 10:23
To: LazyDBA Discussion
Subject: RE: log files questions


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] .
****************************************************************************
***********************************************



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



-----------------------------------------------
Scanned by 186k-NetCleanse, spam and virus protection



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