How to solve the problem about the active log is full

[m***@hotmail.com]

I got error message from event viewer of windows about the active log is full.
Please advise me, how to solve it ?
Thank you.

[m***@hotmail.com]

Thank you for your comment.

I cannot modify program. In this case, can we do anything to solve the problem ?

Thank.
Apinya W.

[c***@us.ibm.com]

If you cannot have the application changed to COMMIT their units-of-work better, than you will have to make alterations to the db cfg to accommodate it. I'd start with increasing the number of secondary logs (LOGSECOND). That will allow the log files to increase dynamically (to a limit).

If you see the secondary logs are always being allocated, then it would appear that you should increase the number of primary logs (LOGPRIMARY). Finally, depending on the work that is being done, you may want to increase the size of the log files themselves. But first, I'd go with increasing the number of secondary logs.

- Bill -

[m***@hotmail.com]

Thank you in advance.

There are OS information :
OS : Microsoft Windows Server 2003 Standard Edition
Service : Service Pack 2
Ram : 3.75 GB
Disk space : C: 4.33 GB
D: 177 GB


There are some current database configuration :
Log buffer size (4KB) (LOGBUFSZ) = 99
Log file size (4KB) (LOGFILSIZ) = 1000
Number of primary log files (LOGPRIMARY) = 20
Number of secondary log files (LOGSECOND) = 10

Could you please to advise me how to increase it ?


Thank you.
Apinya W.

[b***@to.com]

Hi,

"UPDATE DB CFG FOR <dbname> USING LOGSECOND <new nr of secondary log files>". For more infos, check the DB2 documentation, it's really good!

Greetings from Stuttgart,
Bogdan

[m***@hotmail.com]

Thank you.

Sorry for my mistake.

I mean, :
There are some current database configuration :
Log buffer size (4KB) (LOGBUFSZ) = 99
Log file size (4KB) (LOGFILSIZ) = 1000
Number of primary log files (LOGPRIMARY) = 20
Number of secondary log files (LOGSECOND) = 10

New configuration :
Number of primary log files (LOGPRIMARY) = 50
Number of secondary log files (LOGSECOND) = 30

Is it OK ?

Thank you.
Apinya W.