Hi,
I am running DB2 Community edition V9.7 on linux.
I am trying to get some audit running and extract data.
DB2 AUDIT SETTINGS:
Audit active: "TRUE "
Log audit events: "BOTH"
Log checking events: "FAILURE"
Log object maintenance events: "FAILURE"
Log security maintenance events: "FAILURE"
Log system administrator events: "FAILURE"
Log validate events: "FAILURE"
Log context events: "BOTH"
Return SQLCA on audit error: "FALSE "
Audit Data Path: "/home/db2inst1/sqllib/security/auditdata/"
Audit Archive Path: "/home/db2inst1/sqllib/security/auditarchive/"
So in dir /home/db2inst1/sqllib/security I have these dirs:
drwxrwxrwx 2 db2inst1 db2iadm1 4096 Jun 22 15:49 auditarchive
drwxrwxrwx 2 db2inst1 db2iadm1 4096 Jun 22 15:19 auditdata
drwxrwxrwx 2 db2inst1 db2iadm1 4096 Jun 22 15:50 auditdelasc
I have run
db2audit flush
db2audit archive database FAMMC to /home/db2inst1/sqllib/security/auditarchive/
Node AUD Archived or Interim Log File
Message
-------- -------- ---------------------------------------------------
0 AUD0000I
AUD0000I Operation succeeded.
Now I would like to extract some data:
db2inst1@db2migt:~/sqllib/security> db2audit extract delasc to /home/db2inst1/sqllib/security/auditdelasc from files /home/db2inst1/sqllib/security/auditarchive/*
AUD0003N I/O error on accessing "/home/db2inst1/sqllib/security/auditarchive/auditlobs", make sure the directory/file exists and has the right permission.
AUD0001N Operation failed.
I have played with permissions (rwx, rw-, rx etc in various combinatins) to no avail.
Any ideas?
Thanks a lot, Igor
------------------------------
Igor MERKU'
------------------------------
#Db2