---
title: "What is DB2audit how it is so important"
description: "How Db2audit plays crucial role in DB2 and what is the use of it. Really good stuff. Read more."
url: https://srinimf.com/2017/03/27/what-is-db2audit-how-it-is-so-important/
date: 2017-03-27
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2017/03/pexels-photo-4050318.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2"]
tags: ["DB2 Tips and Solutions"]
type: post
lang: en
---

# What is DB2audit how it is so important

db2audit is a facility present [in DB2](https://srinimf.com/2012/04/01/db2-triggers-part-2/). 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.

Related[Stop Manually Checking Databricks Jobs — Export Logs to PostgreSQL Instead](https://srinimf.com/2025/10/04/databricks-rest-api-export-job-logs-to-postgresql/)

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.
```

Related[COBOL-DB2 Program: SQLCA is Not Mandatory Why](https://srinimf.com/2016/02/21/how-to-get-sqlcode-in-db2-cobol-program-without-sqlca/)

Keep Reading

- [DB2: Here are 6 Top Security Features](https://srinimf.com/2017/12/10/top-db2-authority-questions-dba-to-know/)DateDecember 10, 2017
- [20 Neat DB2 Interview Questions and Answers](https://srinimf.com/2023/08/14/20-exclusive-db2-interview-questions-to-read-now/)DateAugust 14, 2023
- [A Comprehensive Overview of DB2 Catalog Table Schemas](https://srinimf.com/2023/12/17/db2-sysibm-catalog-tables-key-points-read-today-how-these-are-modified/)DateDecember 17, 2023

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2017%2F03%2F27%2Fwhat-is-db2audit-how-it-is-so-important%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2017%2F03%2Fpexels-photo-4050318.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=What%20is%20DB2audit%20how%20it%20is%20so%20important)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2017/03/27/what-is-db2audit-how-it-is-so-important/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2017/03/27/what-is-db2audit-how-it-is-so-important/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2017/03/27/what-is-db2audit-how-it-is-so-important/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2017/03/27/what-is-db2audit-how-it-is-so-important/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20What%20is%20DB2audit%20how%20it%20is%20so%20important&body=https%3A%2F%2Fsrinimf.com%2F2017%2F03%2F27%2Fwhat-is-db2audit-how-it-is-so-important%2F&share=email)
-

### Like this:

Like Loading…