Limit db2diag.log size

[Franco Lombardo]

I found that the file db2diag.log on my box is growing more and more. Is
there a way to limit is size? Is it possible to limit the registration only
to the severe or error level events?

Thanks a lot.

Bye

Franco

[Mark A]

"Franco Lombardo" <f_lom...@hotmail.com> wrote in message
news:ha5767$8l8$1...@aioe.org...

Yes you can do all those things. The amx severity level is a parm in the dbm
config.

Most people just zip the file every day or once a week, and delete the zip
files after about a month. You can delete the file anytime you want (or
rename it).

There is a utiliity called db2diag (db2diag.log analysis tool) to help you
with these tasks if you don't want to write your own scripts to zip and
delete.

[Frederik]

On 2 okt, 20:56, "Mark A" <no...@nowhere.com> wrote:
> "Franco Lombardo" <f_lomba...@hotmail.com> wrote in message

If you are on some Unix flavor, you can also simply use logrotate for
this. It's very easy, just google it.

[jmueller]

Franco,

if you on DB2 V9.7 you can do it with db2:

Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) = /db2/DPP/
db2dump
Size of rotating db2diag & notify logs (MB) (DIAGSIZE) = 0

Best regards,
Joachim

[Franco Lombardo]

"jmueller" <joachimchris...@googlemail.com>

>rotating db2diag & notify logs (MB) (DIAGSIZE) = 0

Oh, this sounds reasonable. Another reason to upgrade to 9.7.

Thank you all for your answers.

Bye

Franco

[Mark A]

>>rotating db2diag & notify logs (MB) (DIAGSIZE) = 0

One would think that if IBM went to the trouble to add these features they
would document them somewhere (like in What's New...).

[Jan M. Nelken]

Mark A wrote:

One would think than search in online documentation (available online at:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
would be sufficient:

Product overview
-> What's New overview
-> High Availability,backup,logging,resiliency and recovery enhancements

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/c0054925.html

Jan M. Nelken

[Frederik]

Personally, I believe that the new functionality is only just good
enough compared to what is available for other products (WebSphere AS
comes to mind).

It is missing an option adjust the number of logs to keep (it's 10,
point final), it can't rotate daily, keep a minimum of x days of
logs, ... Compressing old log files would be nice too, but it's not a
must-have.

These should be very easy to implement, but are very useful features.
Me, I rotate daily, zip old files and keep them for 2 weeks on a
separate filesystem. It would be nice to be able to configure this in
DB2.

[Mark A]

"Frederik" <engelen...@gmail.com> wrote in message
news:797b26d8-bf05-4ae3...@l35g2000vba.googlegroups.com...

I would say compressing the log files should definitely have been included
since they compress well over 90%.

[Mark A]

> Jan M. Nelken" <Unknow...@Invalid.Domain> wrote in message
> news:7iuau7F...@mid.individual.net...

> One would think than search in online documentation (available online at:
> http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
> would be sufficient:
>
> Product overview
> -> What's New overview
> -> High Availability,backup,logging,resiliency and recovery
> enhancements
>
> http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/c0054925.html
>
> Jan M. Nelken

OK, my mistake. You lucked out on that one.

[Jan M. Nelken]

Mark A wrote:

> OK, my mistake. You lucked out on that one.

Luck has nothing to do with this :-)

Jan M. Nelken

[Frederik]

> I would say compressing the log files should definitely have been included
> since they compress well over 90%.

They'd probably still try to sell it as part of the Storage
Optimization Feature Pack ;-)