How To Setup Auditing in DB2

First, check audit parameter in DB2 LUW; as you can see “audit active” is FALSE, which shows that currently auditing is not enabled on your instance.

Let’s start to configure; 

  • Update audit_buf_sz parameter.

Two paths parameters.

  • One where audit main file will be created.
  • Second where it will be archived.

Now lets create policy, you can create multiple policies in db2. you can even create policy for single table, for detail you can visit IBM page

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005483.html

I am creating generic audit policy for all database objects in my database.

The audit facility acts at both the instance and database levels, independently recording all activities in separate logs based on either the instance or the database.

 

Syed Naveed Raza

I have experience to manage DB2 & Oracle plus 3 year of experience as Temenos T24 Core Administrator on AIX & IBM Integration Bus 10.

Leave a Reply