db2audit.log is growing automatically

This is a discussion on db2audit.log is growing automatically within the db2-udb forums in Other Databases category; Hi, In DB2 8.2, db2audit.log file grows automatically without executing flush command. Is it because of zero size of audit buffer? DB2 documentation states : When the size of the buffer is set to 0, synchronous log writing occurs, and the audit buffer is not used. I executed get dbm cfg query that results to : Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 Then I executed : update dbm cfg using audit_buf_sz 10 db2stop db2start get dbm cfg : Audit buffer size (4KB) (AUDIT_BUF_SZ) = 10 But still db2audit.log is growing automatically even I don't execute flush command. What should I do ...

Go Back   Database Forum > Other Databases > db2-udb

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 07-09-2008, 03:38 AM
Default db2audit.log is growing automatically

Hi,

In DB2 8.2, db2audit.log file grows automatically without executing flush command.

Is it because of zero size of audit buffer?
DB2 documentation states : When the size of the buffer is set to 0, synchronous log writing occurs, and the audit buffer is not used.

I executed "get dbm cfg" query that results to :
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0

Then I executed :
update dbm cfg using audit_buf_sz 10
db2stop
db2start
get dbm cfg :
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 10

But still db2audit.log is growing automatically even I don't execute flush command.
What should I do to prevent db2audit.log from growing automatically???

Thanks in advance,
Roopsi
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 08:59 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.