Hi;Dear Sir;
I'm a member of iiug with username "20337" named "khalafi" and email address "nilofkh@yahoo.com".
I have some questions and problems in relation with system monitoring.Our system is a database using "Informix Dynamic Server 7.31.UD1" on Unix platform.When I use a query as follow , it give some information about databaseserver but the problem is that the showing informiation is defferent from the real information on system;eg. diskread shows 23333 while the real amount of it is 966.I wanted to know why the result of queries like this (queries on sysmasterdatabase) is different from reality?select d.name,fname[15,25] path_name,sum(pagesread) diskreads, sum(pageswritten) diskwrites
from syschkio c,syschunks k,sysdbspaces d
where d.dbsnum=k.dbsnum
and k.chknum=c.chunknum
group by 1,2
order by 1;
WITH THANKS.
I'm a member of iiug with username "20337" named "khalafi" and email address "nilofkh@yahoo.com".
I have some questions and problems in relation with system monitoring.Our system is a database using "Informix Dynamic Server 7.31.UD1" on Unix platform.When I use a query as follow , it give some information about databaseserver but the problem is that the showing informiation is defferent from the real information on system;eg. diskread shows 23333 while the real amount of it is 966.I wanted to know why the result of queries like this (queries on sysmasterdatabase) is different from reality?select d.name,fname[15,25] path_name,sum(pagesread) diskreads, sum(pageswritten) diskwrites
from syschkio c,syschunks k,sysdbspaces d
where d.dbsnum=k.dbsnum
and k.chknum=c.chunknum
group by 1,2
order by 1;
WITH THANKS.