onstat -g aqt command: Print data mart and accelerated query table
information
Use the onstat -g aqt command to display information about the data
marts and the associated accelerated query tables (AQTs).
Example output
If you use the AQT name for the optional aqt_name parameter, the command
prints information about the specific AQT.
Output description
The AQTs are grouped by the data mart that they belong to. The groups are sorted by
accelerator name, and then by data mart name. Within the data mart groups, the AQTs are sorted
in the following order: Fact table tabid (FactTab), number of tables
(#tab), and AQT name.
The output comes from the entries in the dictionary cache that refer to the AQTs of the data
marts. The output is shown only if the AQTs have been loaded into the dictionary cache, which
normally occurs when a query is being matched against the AQTs.
Before the server attempts to match a query against the AQTs, the AQTs do not have any entries
in the dictionary cache. The onstat -g aqt command will not show any entries
in the output. When the dictionary cache is initialized during the database server startup, the
columns #matched and address get new values.
The onstat -g aqt command prints the following information:
mart
The name of the data mart
accelerator
The name of the accelerator instance
last load
The time stamp for when the data mart was last loaded
AQT name
The unique system-generated name of the AQT
FactTab
The tabid of the fact table for the AQT
#tab
The number of tables that are part of the AQT
#matched
The counter for query matches that have occurred for the AQT
address
The internal database server memory address for the AQT
The onstat -g aqtaqt_namecommand prints the following information:
AQT
The unique system-generated name of the AQT
database
The name of the database to which the AQT belongs
AQT tabid
The tabid for the entry that constitutes the AQT in the
systables system catalog table of the database
server.
Fact table
The tabid of the fact table of the AQT
Number of times matched
The counter for query matches that have occurred for the AQT
The information about the AQT is followed by a textual representation of the star schema of
the data mart. The textual representation shows how the columns of the tables are related to
each other in the star join.
For information about the Informix® Warehouse Accelerator, see
the
Informix® Warehouse Accelerator Administration
Guide.