Re: querying smi tables

fitr For performance statistics (i.e. cache hit ratio,# of seq scans, etc...), generally whatever you would get from onstat -p, use sysmaster:sysprofile. For db growth stats (i.e. total space allocated, used and free), whatever you get from onstat -d, use sysmaster:sysdbspaces and sysmaster:syschunks. Generally look around the sysmaster database and you will find data you can use. You may want to check out Lester Knutsen's site http://www.advancedatatools.com for examples of this. HTH Sujit fitr0912@my-deja.com on 10/19/99 07:18:47 AM Please respond to fitr0912@my-deja.com To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: querying smi tables I am trying to put together some views that DBA could use to look at performance statistics (i.e. cache hit ratio,# of seq scans, etc...), db growth stats (i.e. total space allocated, used and free) and user stats (i.e. concurrent users and max users). Does anyone have some examples or can someone point me to a place where examples of these types of requests reside? I know I am asking a lot here. Thanks in advance!! fitr Sent via Deja.com http://www.deja.com/ Before you buy.