sbspaces

I need some help with sbspaces and the information that is presented from onstat -d and the data in syschunks. When I issue a onstat -d, it appears I have lots of free space in my sbspace's. However, when I query the syschunks table looking at the nfree column, it appears I have almost no free space. Any thoughts out there? I have not been able to dig anything out of the manual. onstat -d outputaddress chk/dbs offset size free bpages flags pathname 5a0c0ce8 12 12 2 949998 796642 877630 POS /dev/ifmx Output from my select against syschunks chknum dbsnum chksize offset nfree 12 12 949998 2 54965 Thanks... Sent via Deja.com http://www.deja.com/

When you are measuring disk usage of an sbspace, "nfree" column in syschunks refers to the "metadata" free space. You could identify an sbspce in syschunks SMI table if you have the following value is_sbspace=1. When an sbspace is initially created, the chunk will be divided into 3 areas, they are: "header", "metadata", and the "userdata". The userdata is used to store your smart large objects (LO's) while header are reserved pages, and metadata area stores information for one or more chunks within the sbspace. You would notice that onstat -d output will display 2 rows for an sbspace chunks. The first row is an information about "userdata" while the second row displays information about "metadata" area. To clearly measure and monitor sbpace usage, you would need the following SMI sql script, this will work in at least 9.21.UC1 version: select name dbspace, sum(mdsize) metadata_size, sum(nfree) metadata_free, sum(mdsize)-sum(nfree) metadata_used, sum(udsize) userdata_size, sum(udfree) userdata_free sum(udsize)-sum(udfree) userdata_used from sysdbspace d, syschunks c where d.dbsnum=c.dbsnum and is_sbspace=1 group by 1 order by 1 -Jonathan In article <91bofu$o1c$1@nnrp1.deja.com>, mhood1@sears.com wrote: > I need some help with sbspaces and the information that is presented > from onstat -d and the data in syschunks. When I issue a onstat -d, it > appears I have lots of free space in my sbspace's. However, when I > query the syschunks table looking at the nfree column, it appears I > have almost no free space. Any thoughts out there? I have not been > able to dig anything out of the manual. > > onstat -d output> address chk/dbs offset size free bpages flags pathname > 5a0c0ce8 12 12 2 949998 796642 877630 POS /dev/ifmx > > Output from my select against syschunks > chknum dbsnum chksize offset nfree > 12 12 949998 2 54965 > > Thanks... > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/