Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g aqt Data Mart and Accelerated Query Table

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

Output Descriptions

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.