IDS- How to find sbspace storage utilization

I was trying to find out the storage utilized by dbspace,sbspace and blobspace. I have executed the following query in dbaccess select c.pagesize pagesize,d.name dbspace,c.chksize totalpages,c.nfree freepages, c.fname filename from syschunks c, sysdbspaces d where d.dbsnum = c.dbsnum; For sbspace, I was getting the following output pagesize 2048 dbspace sbspace1 totalpages 51200 freepag 2581 filename /opt/data/sbspace_chunk1 But when I compared the value with onstat -d, I was getting a different value for sbspace "free pages" Onstat output is given below Chunks address chunk/dbs offset size free bpages flags pathname 10a5de028 1 1 0 50000 35329 PO-B /opt/IBM/informix/demo/server/online_root 10a5de410 2 2 100 51200 10231 10240 POBB /opt/data/blob_chunk1 10a5de5f8 3 3 0 51200 10231 10240 POBB /opt/data/blob_chunk2 10a5de7e0 4 4 0 51200 47678 47678 POSB /opt/data/sbspace_chunk1 Metadata 3469 2581 3469 4 active, 32766 maximum As per onstat -d, spspace "free page" 47678 that is far away from dbaccess out put for sbspace "free page"(2581). My problem is the value for spspace free page reported by dbaccess is not matching with onstat -d output. I strongly believe that values reported by onstat -d is correct How can I calculate sbspace "free page size" using SMI tables? I am using IDS 11.10 on Solaris. Any help to solve the problem is highly appreciated. Thank you. Pratheep

For an sbspace chunk, the syschunks fields are interpreted as follows: - msize is the size of the meta data area, - nfree is the number of free metadata pages, - udsize is the size of the remaining data area, and - udfree is the free data pages available. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Oct 5, 2009 at 6:00 AM, PRATHEEP KK <pratheepkk@gmail.com> wrote: > I was trying to find out the storage utilized by dbspace,sbspace and > blobspace. > I have executed the following query in dbaccess > > select c.pagesize pagesize,d.name dbspace,c.chksize totalpages,c.nfree > freepages, > c.fname filename from syschunks c, sysdbspaces d where d.dbsnum = c.dbsnum; > > For sbspace, I was getting the following output > > pagesize 2048 > dbspace sbspace1 > totalpages 51200 > freepag 2581 > filename /opt/data/sbspace_chunk1 > > But when I compared the value with onstat -d, I was getting a different > value > for sbspace "free pages" > Onstat output is given below > > Chunks > address chunk/dbs offset size free bpages flags pathname > 10a5de028 1 1 0 50000 35329 PO-B /opt/IBM/informix/demo/server/online_root > 10a5de410 2 2 100 51200 10231 10240 POBB /opt/data/blob_chunk1 > 10a5de5f8 3 3 0 51200 10231 10240 POBB /opt/data/blob_chunk2 > 10a5de7e0 4 4 0 51200 47678 47678 POSB /opt/data/sbspace_chunk1 > > Metadata 3469 2581 3469 > 4 active, 32766 maximum > > As per onstat -d, spspace "free page" 47678 that is far away from dbaccess > out > put for sbspace "free page"(2581). > My problem is the value for spspace free page reported by dbaccess is not > matching with onstat -d output. > I strongly believe that values reported by onstat -d is correct > > How can I calculate sbspace "free page size" using SMI tables? > > I am using IDS 11.10 on Solaris. > > Any help to solve the problem is highly appreciated. > > Thank you. > > Pratheep > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517476248ee7b0e0475312c32

For an SBSpace you need to also count the Meta Data Total and Free Pages. You may find this SQL useful, run it against the sysmaster database. You may also need to run onstat -d update so that the values match at a point in time. SELECT TRIM(name), -- SpaceName SUM(chksize), -- Total Size SUM(udsize), -- UD Size SUM(udfree), -- UD Free ROUND ((SUM(udfree)) / (SUM(udsize)) * 100, 2), -- UD % Free SUM(mdsize), -- MD Size SUM(nfree), -- MD Free ROUND ((SUM(nfree)) / (SUM(mdsize)) * 100, 2) -- MD % Free FROM sysdbspaces d, syschunks c WHERE d.dbsnum = c.dbsnum AND is_sbspace = 1 GROUP BY 1 Stuart McCann Integrated Spatial Services Unit Information Communication & Technology Department of Lands, Bathurst Phone: (02) 63328284 stuart.mccann@lpma.nsw.gov.au -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PRATHEEP KK Sent: Monday, 5 October 2009 9:01 PM To: ids@iiug.org Subject: IDS- How to find sbspace storage utilization [17320] I was trying to find out the storage utilized by dbspace,sbspace and blobspace. I have executed the following query in dbaccess select c.pagesize pagesize,d.name dbspace,c.chksize totalpages,c.nfree freepages, c.fname filename from syschunks c, sysdbspaces d where d.dbsnum = c.dbsnum; For sbspace, I was getting the following output pagesize 2048 dbspace sbspace1 totalpages 51200 freepag 2581 filename /opt/data/sbspace_chunk1 But when I compared the value with onstat -d, I was getting a different value for sbspace "free pages" Onstat output is given below Chunks address chunk/dbs offset size free bpages flags pathname 10a5de028 1 1 0 50000 35329 PO-B /opt/IBM/informix/demo/server/online_root 10a5de410 2 2 100 51200 10231 10240 POBB /opt/data/blob_chunk1 10a5de5f8 3 3 0 51200 10231 10240 POBB /opt/data/blob_chunk2 10a5de7e0 4 4 0 51200 47678 47678 POSB /opt/data/sbspace_chunk1 Metadata 3469 2581 3469 4 active, 32766 maximum As per onstat -d, spspace "free page" 47678 that is far away from dbaccess out put for sbspace "free page"(2581). My problem is the value for spspace free page reported by dbaccess is not matching with onstat -d output. I strongly believe that values reported by onstat -d is correct How can I calculate sbspace "free page size" using SMI tables? I am using IDS 11.10 on Solaris. Any help to solve the problem is highly appreciated. Thank you. Pratheep ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. *************************************************************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Land and Property Management Authority. This email message has been swept by MIMEsweeper for the presence of computer viruses. *************************************************************** Please consider the environment before printing this email.