LOGSECOND is dynamic and does not require a reactivation of the db.
Hope this helps, Pierre.

----- Message d'origine -----
De: BAIJU VARGHESE <db2udbdba-ezmlmshield-x33332080.[Email address protected]
Date: Jeudi, Juin 28, 2007 1:51 pm
Objet: Re: Re : [DB2] Transaction Logs
À: LazyDBA Discussion <[Email address protected]

> Guys,
> Just want to make sure something here..Is the LOGSECOND change
> is dynamic in version 8.2 or it is something new for version 9?
> I believe LOGSECOND requires a database restart to take effect
> in version 8.2.
>
> Baiju
>
>
> >>> "p" > protected] 06/26/2007 10:34 AM >>>
> Your log file list ifdentifies only 5 log files.
> I suspect they are the result of the initial default setting (3
> primary, 2 secondary).
> Do a db2 get db cfg for dbname show detail.
> Two columns will list. One is the memory setting and the other
> is the file setting.
> In your case LOGPRIAMRY would shoe 3 10 and LOGSECOND 5 5
> LOGSECOND can be dynamically changed but LOGPRIMARY requires the
> database to be deactivated (disconnected) and reactivated. You
> do not nee to bounce the instance, this is just a db issue for
> that db.
> Hope this helps, Pierre.
>
> ----- Message d'origine -----
> De: gcanedy > Date: Mardi, Juin 26, 2007 11:05 am
> Objet: [DB2] Transaction Logs
> À: LazyDBA Discussion <[Email address protected]
>
> > Hi everyone, First time post here. I'm guessing this is an old
> > topic, but
> > having trouble finding the right answer.
> >
> > I have a small table with about 100,000 rows. If I do "delete from
> > table_name" it fails with the "TTSQL error -
> > 964:[DataDirect][ODBC DB2 Wire
> > Protocol driver][UDB DB2 for Windows, UNIX, and Linux] The
> > transaction log
> > for the database is full." error message.
> >
> > I can selectively delete small groups of records until I get
> it
> > down to
> > around 10.000 rows, then sometimes it will let me finish with
> > the 'delete
> > from table'.
> >
> > I've got the following cfg (which was just changed from values
> > 1024, 3, 2):
> >
> > Log file size (4KB)
> > (LOGFILSIZ) = 4096
> > Number of primary log files (LOGPRIMARY) = 10
> > Number of secondary log files (LOGSECOND) = 5
> >
> > with logs files as shown:
> >
> > /db2/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR
> > $ ls -l
> > total 40080
> > -rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:52 S0000000.LOG
> > -rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:42 S0000001.LOG
> > -rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:43 S0000002.LOG
> > -rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:43 S0000003.LOG
> > -rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:43 S0000004.LOG
> >
> > Does DB2 have to be bounced for the changes to take effect? Is
> > there a
> > cleaner way to manage the transaction logs? I'm also having trouble
> > loading mass rows (around 200,000) into the tables.
> >
> > Thanks!
> >
> > Gary P. Canedy
> > Database Analyst
> > ProMutual Group
> > (617) 757-6775
> >
> >
> >
> >
> >
> > -----------------------------------------------------------
> > This email and any files transmitted with it are intended only
> > for the
> > person or entity to which it is addressed and may contain
> confidential> and/or privileged material. If you received this
> email in
> > error, please
> > contact the sender immediately and delete this email from your
> > system. If
> > you are not the named addressee, you should not disseminate,
> > distribute,print, or copy the email, or take any action in
> > reliance on its contents.
> >
> >
> >
> > ---------------------------------------------------------------
> --
> > ----
> > 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
> >
> >
>
> Pierre Saint-Jacques
>
>
>
>
> -----------------------------------------------------------------
> ----
> 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
>
>

Pierre Saint-Jacques

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