Question & Answer
Question
Top tables, by growth:
GDM_FIELD: +121 MB in last 24 hours; current size: 253 MB;
GDM_OBJECT: +40 MB in last 24 hours; current size: 92 MB;
GDM_SENTENCE: +17 MB in last 24 hours; current size: 39 MB;
DM_EXTRACTION_LOG: +1 MB in last 24 hours; current size: 3 MB;
GDM_ERROR: +0 MB in last 24 hours; current size: 293 MB;
GDM_CONSTRUCT: +0 MB in last 24 hours; current size: 27 MB;
REPORT_RESULT_DATA_ROW: +0 MB in last 24 hours; current size: 5 MB;
AUDIT_PROCESS_LOG: +0 MB in last 24 hours; current size: 2 MB;
GDM_ACCESS: +-1 MB in last 24 hours; current size: 20 MB;
GDM_SESSION: +-1656 MB in last 24 hours; current size: 10 MB;
Cause
Answer
Alert description:
Alerts are sent when the system predicts that a DB size or files on disk (/var) will reach 50% in the next 14 days. Alerts detail the predicted size and the largest tables or files. Alerts are also shown in the deployment health dashboard of the central manager.
The prediction is based on the pace of traffic. You need to check the policy and how much data is being captured that can fill internal DB or file system.
High level steps
1. CLI command to check DB usage and identify largest tables:
support show db-status used %
support show db-top-tables all
2. CLI commands to check filesystem usage and identify large files:
show filesystem usage
support show large_files 10 0
(larger than 10MB older than 0 days )
3. Use reports in the GUI to see how much data is in the largest tables per day
Report definitions are available to download in technote:
How much data is in my Guardium top tables per day?
For example: If you notice GDM_CONSTRUCT_TEXT is largest table then "Full SQL per day" report will help you understand how much data is being logged in the table daily.
4. The below two technotes can help you understand why your internal database is filling up and what actions can be taken to reduce its space.
Related Information
Product Synonym
IBM Guardium
Was this topic helpful?
Document Information
Modified date:
15 July 2019
UID
ibm10881099