Troubleshooting
Problem
Scheduled jobs fail with the following error message:
Alert Details Exception Timestamp Exception Description Count of Exceptions 2020-05-04 12:00:05 customTableDataUpload_104 trigger: customTableJobGroup.customTableDataUpload_104 Cannot upload any more data, the custom DB has reached its quota.
Cause
This error is presented when the CUSTOM database is full.
Diagnosing The Problem
The CUSTOM and DATAMART database both contribute to this quota on the collector. DATAMART could be the database that uses the most space.
Resolving The Problem
Use the following commands to check the table sizes in the CUSTOM and DATAMART databases:
support show db-top-tables db CUSTOM
Here is an example of the output returned by this command:
Table Size (M) | I/D % | Unused(M) | Est. Rows | Name
-------------- | ----- | --------- | --------- | ----------
2 | 25 | 0 | 16315 | STAP_ASSOCIATION_HISTORY
1 | 0 | 1 | 0 | STAP_INFO
0 | 100 | 0 | 0 | CM_SNIFFER_BUFFER_USAGE
support show db-top-tables db DATAMART
Table Size (M) | I/D % | Unused(M) | Est. Rows | Name
-------------- | ----- | --------- | --------- | ----------
6448 | 24 | 4643 | 1696846 | ENTERPRISE_STAP_VERIFICATION
700 | 53 | 90 | 2418730 | FAILED_LOGGINS
In the previous example, DATAMART has the largest tables.
Ensure the purge periods are set to the proper specification by using this command:
show purge object age (look for your particular object)
56 30 DAY Eagle Eye Symptom Details
66 30 DAY Eagle Eye Symptoms
72 90 DAY Enterprise Stap Verification
88 14 DAY External S-TAP Deployment
42 7 DAY Failed User Login Attempts - Distributed
Reduce the number of days kept in the table to reduce the amount of space used.
Use the following CLI command:
store purge object age <index> <age>
The tables in the database will be reduced upon the next archive and purge, then the scheduled jobs will run to completion.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0PAAS","label":"DATABASE"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Version(s)","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
Modified date:
10 December 2020
UID
ibm16260529