IBM Support

[Db2] Simple test case shell script for db2audit instance and database level auditing

Question & Answer


Question

This document contains Frequently Asked Questions (FAQ), especially simple test case shell script or scenario about the product DB2 for Linux UNIX and Windows. Simple shell script or scenario can not only clarify whether the current environment work fine or not but also show us a basic usage and/or how Db2 works for Db2 beginner and Db2 average users.
If users could provide a problem reproducible shell script after modifying on of scripts, it helps Db2 technical support analysts to identify the root cause.  Users may clarify whether newer Db2 Version/Fixpack or Operating System patch, etc. could have the same problem or not by themselves once he/she created one.  Users may create their own shell script base tool/application referencing below scripts as a sample or an example.  Scripts have been verified on AIX platform so may need to modify as needed for other platforms, such as Linux, Windows, etc.
In this article, you may find :
- db2audit for instance level auditing
- db2audit for database level auditing

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

ibm11075779