beautypg.com

Get and analyze alerts, Properties – Fortinet FortiDB User Manual

Page 49

background image

Appendix B: DB2-Audit-Based Auditing for DB2 UDB V8

Different Data Retrieval Methods

FortiDB Version 3.2 Privilege Monitor User Guide
15-32000-81364-20081219

47

Get and Analyze Alerts

PM Alert Generated Using Audit-Based Data Retrieval

When used with the Audit Data Retrieval method, PM generates alerts with the
above format.

SQL Statements Possibly Causing PM Alert

If Fetch SQL Statements is also checked when creating your database
connection, you can analyze a list of possible SQL statements that possibly
caused the alert, as shown above.

Properties

A property, db2extractdir, has been introduced in order to help alleviate I/O-

contention and/or disk-space problems. This property supports the agent used for
DB2-Audit-based auditing used with DB2 UDB V8 target databases. See the
FortiDB MA Administration Guide for more information.

This property resides in serverConfigDB28.properties file which resides on the
target-database machine. The default is /tmp. You might want to choose another

disk location if you encounter an excessively large db2audit.out file.