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.

Resolving The Problem

The index can be fixed running the CLI command:

       support check tables <database> <table>

For example, in this case:

      support check tables TURBINE TURBINE_ROLE_PERMISSION

Related Information

Guardium internal DB getting full

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21637462

Page Feedback