It was dynamic since v8.2.

Thanks,
Ravi Khandelwal
(713) 207 5307


-----Original Message-----
From: BAIJU VARGHESE [mailto:db2udbdba-ezmlmshield-x33332080.[Email address protected]
Sent: Thursday, June 28, 2007 12:50 PM
To: LazyDBA Discussion
Subject: Re: Re : [DB2] Transaction Logs

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" <db2udbdba-ezmlmshield-x51753971.[Email address 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 <db2udbdba-ezmlmshield-x87493518.[Email address protected]
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

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