Get and analyze alerts, Properties – Fortinet FortiDB User Manual
Page 49
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.