Hi,
I must write application that calculate free space of smartblobspace
,anyone have idea where find information of free page of smartblobspace
???
In the output of onstat -d this information is readable.
This is a query that I use on sysmaster db :
SELECT sysdbspaces.name, syschunks.fname, sysdbspaces.nchunks,
syschunks.chknum, (syschunks.chksize * 2048)/1024,
(syschunks.nfree * 2048)/1024
FROM
informix.syschkio syschkio,informix.syschunks syschunks, informix.sysdbspaces sysdbspaces
WHERE syschkio.chunknum = syschunks.chknum AND syschunks.dbsnum =
sysdbspaces.dbsnum
ORDER BY sysdbspaces.name,syschunks.chknum
My server is 9.14 UC6 .
I have modified this query for running on IIF 2000 and on this version I
have no problems because there is a table field tht indicate a free
pages of data in smartblobspaces but on 9.14 there isn't . The new
query is :
SELECT sysdbspaces.name, syschunks.fname, sysdbspaces.nchunks,
syschunks.chknum, (syschunks.chksize * 2048)/1024,
(syschunks.udsize*2048)/1024,
(syschunks.nfree * 2048)/1024
, syschkio.reads, syschkio.pagesread, syschkio.writes,syschkio.pageswritten
FROM
informix.syschkio syschkio,
informix.syschunks syschunks, informix.sysdbspaces sysdbspaces
WHERE syschkio.chunknum = syschunks.chknum AND syschunks.dbsnum =
sysdbspaces.dbsnum
ORDER BY sysdbspaces.name,syschunks.chknum
Anyone have suggest ???
Thanks.