Hi.
I have question that may be very strange to many of you.

I am writing monitoring program for informix server. Well I managed to see the session information (users, hosts, etc.) with sql statement but I do not know how to see the other info about the server. So if anybody knows how to see the following info via sql statement, please share your knowage.

1. dbspaces and chunks - like the command onstat -d
2. replication servers - like the command cdr list server
3. Txns in queue - like the command onstat -g rqm
4. and any userfull onstat command.

Thanks for the advise.

Hi,

I suggest you that look in sysmaster database and explor in $INFORMIXDIR/etc/sysmaster.sql.

Gustavo.

Thanks a lot

check this out

http://www.advancedatatools.com/Articles/sysmast.htm