don't understand sbspace
hi all
I'm using 9.14UC3 on solaris 2.5.1
when I monitor my sbspace by two differents ways . I got
two differents results.
by using onstat -d, here is my display:
> onstat -d
INFORMIX-Universal Server Version 9.14.UC3 -- On-Line -- Up 1 days
01:11:56 -- 91960 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
c0a2108 1 2 1 1 M informix rootdbs
c0a2a68 2 1 2 1 N informix dbsp1
c0a2ae0 3 1 3 1 N informix logdbsp
c0a2b58 4 2001 4 1 N T informix tempdbsp
c0a2bd0 5 2 5 1 M informix clientdbsp
c0a2c48 6 8002 6 1 M S informix clientsbsp
c0a2cc0 7 8001 7 1 N S informix clientsbsp2
7 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
c0a2180 1 1 128 450000 447710 PO-
/dev/rdsk/c0t2d0s0
c0a2258 1 1 128 450000 0 MO-
/dev/rdsk/c0t3d0s0
c0a23a8 2 2 128 500000 499897 PO-
/dev/rdsk/c0t2d0s1
c0a2480 3 3 128 500000 191747 PO-
/usr/informix/dbspaces/logdbsp
c0a2558 4 4 64 497500 497447 PO-
/usr/informix/dbspaces/tempdbsp
c0a2630 5 5 64 497500 317494 PO-
/usr/informix/dbspaces/clientdbsp
c0a28b8 5 5 64 497500 0 MO-
/usr/informix/dbspaces/m_clientdbsp
c0a2708 6 6 64 499980 341533 474927 POS
/usr/informix/dbspaces/clientsbsp
c0a2990 6 6 64 499980 0 MOS
/usr/informix/dbspaces/m_clientsbsp
c0a27e0 7 7 8 475000 375481 463239 POS
/usr/informix/dbspaces/clientsbsp2
7 active, 2047 maximum
by using the sysmaster with a request inspired by L B. Knutsen:
set isolation dirty read;
SELECT name[1,11] dbspace, -- name truncated to fit on one line
-- is_sbspace sbspace, -- true if 1
sum(chksize) Pages_size, -- sum of all chuncks size pages
sum(chksize) - sum(nfree) Pages_used,
sum(nfree) Pages_free, -- sum of all chunks free pages
round ((sum(nfree)) / (sum(chksize)) * 100, 2) percent_free
FROM sysdbspaces d, syschunks c
WHERE d.dbsnum = c.dbsnum -- and d.is_sbspace = 1
GROUP by 1
ORDER BY 1
here is the display:
> ./dbfree.sh
display free DB Space
dbspace clientdbsp
pages_size 497500
pages_used 180014
pages_free 317486
percent_free 63.82
dbspace clientsbsp
pages_size 499980
pages_used 499980
pages_free 0
percent_free 0.00
dbspace clientsbsp2
pages_size 475000
pages_used 475000
pages_free 0
percent_free 0.00
dbspace dbsp1
pages_size 500000
pages_used 103
pages_free 499897
percent_free 99.98
dbspace logdbsp
pages_size 500000
pages_used 308253
pages_free 191747
percent_free 38.35
dbspace rootdbs
pages_size 450000
pages_used 2290
pages_free 447710
percent_free 99.49
dbspace tempdbsp
pages_size 497500
pages_used 61
pages_free 497439
percent_free 99.99
I notice that sql request shows 0 on pages_free for clientsbsp2 and
clientsbsp.
the result seems goods because now I got smatblobs errors.
How can we explain this?
I think it comes from the metadata which is badly set.
So is it a good solution to drop the sbspace so that I set a new metadata?
and what the tip to set a efficient metadata?
thanks for any answers.
georges