What is DB2audit how it is so important

db2audit is a facility present in DB2. It is a component that generates logging for some security events on the database, for example, authorization checking, security administration, user validation, changes in database objects.

It is an interesting way to investigate security questions in the database. db2audit basic commands.

Below are the Commands to Use in db2audit.

db2audit start -> to start db2audit 
db2audit stop -> to stop db2audit 
db2audit describe -> to check status of db2audit (if it's running)

How Db2audit looks like

db2inst1@olimpio:/db/db2inst1/db2backup/home>db2audit 
describe DB2 AUDIT SETTINGS: 
Audit active: "TRUE " ---------> 
db2audit is running! 
Log audit events: "FAILURE" 
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: "NONE" Return SQLCA on audit error: "FALSE " 
Audit Data Path: "" Audit Archive Path: "" 
AUD0000I Operation succeeded. 
...
db2inst1@olimpio:/db/db2inst1/db2backup/home>db2audit 
describe DB2 AUDIT SETTINGS: 
Audit active: "FALSE " ---------> 
db2audit is NOT running! 
Log audit events: "FAILURE" 
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: "NONE" 
Return SQLCA on audit error: "FALSE " 
Audit Data Path: "" 
Audit Archive Path: "" AUD0000I Operation succeeded.

Keep Reading

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.