Data Vault Administrator Guide

Back Next

Displaying Information About Archived Tables

The TableReport command displays information about the specified archived tables.

TableReport [ <table-id> | <schema>.<table> ]

The following table provides information that appears when you run the TableReport command for a specific archived table:

Parameter	Description
ID	The internal archived table ID.
Name	The name of the archived table, qualified by schema.
Columns	The number of columns in the archived table.
Row length	The maximum length of a record in the archived table (in bytes).
Files	The total number of files registered for this archived table.
Total size	The total size of all files registered for this archived table (in bytes).
Total rows	The total number of rows in the archived table (the combined number of rows in all files registered for this table).
Flat file size	The estimated uncompressed size of the data in the archived table (in bytes).
Compression ratio	The estimated degree of data compression in the archived table.

The following table provides information that is displayed by the TableReport command for all registered archived tables:

Parameter	Description
Total tables	The total number of archived tables.
Files	The total number of files registered with archived tables.
Total size	The total size of all files registered with archived tables (in bytes).
Total rows	The total number of rows across all registered archived tables (the combined number of rows in all files).
Flat file size	The estimated uncompressed size of the data in all registered archived tables (in bytes).
Compression ratio	The estimated degree of data compression in all registered archived tables.