The onstat -g aqt command displays data mart and accelerated query table information. The command has the option to filter on AQT name. If filtered, then 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.
mart: audit accelerator: DWAFINAL last load: 2013/06/06 12:46:22 AQT name FactTab #tab #matched address -------------------------------------------------------------------------------- aqt4d11b552-7d41-4b0c-824b-7714b6cb580a 103 1 433 00x4d84ac7 aqt61498fab-3617-4c8c-ab40-fd8af4253998 103 2 23 0x4d84adc8 aqtbc2da77c-bca8-4ce7-9191-8180a860da34 103 2 875 0x4d95c028 aqt88757e9d-81ee-43b4-87b2-0bf48c98fa55 103 3 27 0x4d84a190 aqt8dd61c80-2c1c-4f0e-8f0c-91babe789f41 103 4 432 0x4d95c758
Not all fields are in the above example
Option | Description |
---|---|
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 |
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 |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.