IBM Support

Large Table Index causing internal Guardium DB to fill up

Troubleshooting


Problem

Sometimes Guardium DB fills up, eventhough the retaintion period is low.

Symptom

It can be that one of the table indexes has grown out of proportion. This can be seen with the result of the CLI command:

support show db-top-tables all

Table Size (M) | I/D % | Est. Rows | Name
-------------- | ----- | --------- | ----------
          1015 |     9 |   1194556 | REPORT_RESULT_DATA_ROW
           233 |    35 |    119724 | GDM_ERROR
            13 |  1190 |      5308 | GDM_CONSTRUCT_INSTANCE
            12 |   123 |      5972 | GDM_ACCESS
            11 |   176 |       841 | GDM_FIELD
             9 | 17976888 |         6 | TURBINE_ROLE_PERMISSION
             8 |     2 |      5973 | SOFTWARE_TAP_PROPERTY
             8 |     0 |     15267 | SNIFFER_BUFFER_USAGE
             7 |    17 |     63517 | DB_ERROR_TEXT

Notice that the index size for the table TURBINE_ROLE_PERMISSION is too large compared to the actual table size.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.0;8.2;8.1;8.0.1;8.0","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

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:
16 June 2018

UID

swg21637462

Page Feedback