C2150-606 · Question #45
After a successful purge, a Guardium administrator observes that the full percentage of the Guardium internal database is not decreasing. The administrator uses support show db-top- tables all and…
The correct answer is D. Optimize the internal TURBINE database using diag CLI command. If you when using IBM InfoSphere Guardium product, you notice the database disk space is growing at a fast rate. This is caused by sniffer not able to handle some types of SQLs (usually a sniffer bug). This failure to handle the SQLs occurs frequently enough that GDM_ERROR…
Question
After a successful purge, a Guardium administrator observes that the full percentage of the Guardium internal database is not decreasing. The administrator uses support show db-top- tables all and finds the size of the largest tables has decreased significantly. What should the administrator do?
Options
- AIncrease the retention period and rerun the purge.
- BRebuild the appliance and restore from the backup.
- CLogin to CLI and execute stop inspection-core.
- DOptimize the internal TURBINE database using diag CLI command.
How the community answered
(41 responses)- A2% (1)
- B7% (3)
- C17% (7)
- D73% (30)
Explanation
If you when using IBM InfoSphere Guardium product, you notice the database disk space is growing at a fast rate. This is caused by sniffer not able to handle some types of SQLs (usually a sniffer bug). This failure to handle the SQLs occurs frequently enough that GDM_ERROR table grows at a fast rate which then translates to database disk space usage growth. Use command support show db-status used % to show database used space. Run an Optimize to optimize the TURBINE database. This will reorganize the data in all tables, including GDM_ERROR, which will result in reflecting the current actual reduced size. Not C: The inspection-core is sniffer itself. You can stop inspection-core by "stop inspection-core" CLI command and start it by "start inspection-core" CLI command.
Topics
Community Discussion
No community discussion yet for this question.