IBM Support

Meaning of 'I/D %' for Guardium CLI command output for "support show db-top-tables"

Question & Answer


Question

The Guardium CLI command output for "support show db-top-tables" has a column called 'I/D %'. What does the 'I/D %' column mean?

Answer

Example output of "support show db-top-tables":

TESTCOL1.ibm.com>support show db-top-tables like DB_ERROR_TEXT
Table Size (M) | I/D % |  Unused(M) | Est. Rows | Name
-------------- | ----- |  --------- | --------- | ----------
            7  |    19 |          0 |     65912 | DB_ERROR_TEXT

No tables with more than 80% of free space used found.
ok

'I' stands for 'INDEX_LENGTH'.
INDEX_LENGTH: Size of index being stored for the table

'D' stands for 'DATA_LENGTH'.
DATA_LENGTH: Size of data on disk as well as in main memory for the table

So 'I/D %' stands for "Index_length/Data_length %".

In the above example, 'DB_ERROR_TEXT' table has 'INDEX_LENGTH/DATA_LENGTH %' = 19

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Guardium Appliances","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.0;8.2;9.0;9.1;9.5","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21977742

Page Feedback