Troubleshooting
Problem
When "support show db-top-tables all" command is executed, N/A under the column Est. Rows can be seen for some tables.
Symptom
When "support show db-top-tables all" command is executed, "N/A" under the column Est. Rows can be seen for some tables.
e.g.
Table Size (M) | I/D % | Est. Rows | Name
-------------- | ----- | --------- | ----------
10267 | 0 | 60793643 | GDM_FIELD
4894 | 0 | N/A | MONITOR_VALUES
4553 | 0 | 19833477 | GDM_OBJECT
3492 | 0 | N/A | MONITOR_VALUES_CHANGED_COLUMN
2991 | 0 | N/A | GDM_CONSTRUCT_INSTANCE
2781 | 4 | 1098014 | REPORT_RESULT_DATA_ROW
1262 | 0 | 1875679 | GDM_CONSTRUCT
1192 | 0 | 11890600 | GDM_SENTENCE
690 | 11 | 4716553 | ALERT_LOG
409 | 0 | N/A | GDM_SESSION
109 | 0 | 356514 | GDM_ACCESS
50 | 0 | N/A | GDM_APP_EVENT
46 | 0 | N/A | GDM_EXCEPTION
42 | 0 | N/A | MESSAGE
36 | 0 | N/A | DATASOURCE_VERSION_HISTORY
Cause
N/A
Environment
v8.2
Diagnosing The Problem
To check, execute command "support show db-top-tables all" on the appliance OR look at the resultant file db_output.txt captured via "support must_gather system_db_info" command.
Resolving The Problem
In the older systems such as v8.2, that use GDMS databases in an aggregator, the est. rows will be N/A for dynamic tables. This is because, they have tables-of-the-day and it will take too long to sum the count of rows in each of them. Static tables are single tables and you will see the est. of them. In the output above under Symptom, you will see that tables like GDM_FIELD and GDM_OBJECT have an est. rows and GDM_SESSION does not.
In addition to this, the Est. Rows value is taken from "SHOW TABLE STATUS" which provides an estimated value and not an exact number.
It is advised that a PMR be opened to involve Guardium Technical Support if there are table related errors observed.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21992408