hi ,

I need to configure db2audit in my test envi.
I first increased the aud_buf_siz to 40. then stop and start the instance .

When trying to configure using
db2audit configure scope checking, objmaint, validate status failure
errortype normal

I get Operation failed error.

if i use scope as "all" or any 1 parameter "checking" then it is successful.

I am using db2 9.7 fp4 linux 5.5

suggest me how to corret this. thanks !

looking at syntax diagram : should it not be ..
scope xx status yy, xx2 status yy2

You should see
at the top of the error output

Try

thanks it worked.

Hi even after the stating of db2audit, db2audit.log was not created on $INST/sqllib/security/

where to check or any way to change the path of log file.

Have you had an event that generates audit record.
In 9.7 audit records are saved under
sqllib/security/auditdata
and has a more descriptive name
db2audit.db.SAMPLE.log.0

HTH

Sathyaram

thanks sathya,

i could see 2 logs created for instance and database. But when i try to view it says it as a binary. so unless i extract it i wont be able to see ?

(sorry it was a silly question)

db2audit command , extract option.
I am sure you know where to find the details of the command. ;-)

Thanks sathya...

One more doubt,

After archiving and extracting i wanted to load the file to a table.

when i try to give the command

[db2inst1@WESSDITM auditdata]$ db2 load from objmaint.del of DEL insert into db2inst1.OBJDEL01
SQL3304N The table does not exist.


On what basis should i create a table, And what are the columns it should have. Any demo tables available in the db2 system tables.

kindly help me.

the doc has been available since ages. why don't users ever find them
if you don't create the tables- they will not be created by the holly spirit
all is over here
Creating tables to hold the DB2 audit data - IBM DB2 9.7 for Linux, UNIX, and Windows

hey thanks doc was helpful.

trying for the first time.. from now one i will look for doc and then come to forum if required...