IDS Forum

RE: IDS- How to find sbspace storage utilization

Posted By: Stuart McCann
Date: Monday, 5 October 2009, at 8:00 p.m.

In Response To: IDS- How to find sbspace storage utilization (PRATHEEP KK)

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.

Messages In This Thread

• IDS- How to find sbspace storage utilization
  PRATHEEP KK -- Monday, 5 October 2009, at 6:00 a.m.
  • Re: IDS- How to find sbspace storage utilization
    Art Kagel -- Monday, 5 October 2009, at 10:46 a.m.
  • RE: IDS- How to find sbspace storage utilization
    Stuart McCann -- Monday, 5 October 2009, at 8:00 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.