IBM Support

Guardium internal database full percentage is not decreasing, even after a successful purge. - Reclaim DB Space with OPTIMIZE

Troubleshooting


Problem

You note that the Guardium database is showing as full. When running the "support show db-top-tables all" command from CLI you see that the total size of the top tables is much smaller than the total disk space available for the database. You have recently purged data off the system but the data % did not decrease. - You also noticed that there is Unused (M) in some tables in "support show db-top-tables all"

Symptom

You can see if the internal database is full in a number of ways:
  • Messages in the syslog saying the db is full.
  • Output of CLI command:
    • support show db-status used %
  • Mysql Disk Usage column in GUI->Guardium Monitor->Buffer Usage Monitor report
  • You may notice a large amount of unused space with this command
    • support show db-top-tables all

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0JAAS","label":"APPLIANCE"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

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:
24 November 2020

UID

swg21676156