Hi All,

I have DB2 V9.7 Express on Linux RedHat 5.
I need to extract the audit logs in a specific format, "syslog" format.
Now I obtained this log :
---

timestamp=2009-09-10-12.40.02.368188;
category=CONTEXT;
audit event=ATTACH;
event correlator=1;
userid=db2inst1;
authid=DB2INST1;
application id=*LOCAL.db2inst1.090910104003;
application name=db2audit;

---

Is possible to distribute in a single line ?
Many thanks.

Carlito.

We can do better than that .. this tool will load your audit data into a table periodically (e.g. every 20 minutes) - all you have to do is query the table ... part of this package: http://www.db2topgun.com/dbapf5