LOGSECOND can be dynamically changed in 8.2.

---------- Original Message ----------------------------------
From: "BAIJU VARGHESE " <db2udbdba-ezmlmshield-x33332080.[Email address protected]
Date: Thu, 28 Jun 2007 12:50:00 -0500

>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