Adding chunk but not seeing any more free space

smmathew · #1 (**permalink**) 02-14-12, 16:48

I keep seeing a warning that one of my blob spaces is 93% full.

Here is my "onstat -d update" output

Chunks
address chunk/dbs offset size free bpages flags pathname
50e53928 1 1 4 100000 86254 PO-- /dev/rrootdbs
516e07d8 2 2 4 4797952 3905540 PO-B /dev/rbasedbs
516e0960 3 3 4 500000 447723 PO-- /dev/rllogdbs
516e0ae8 4 4 4 16000 947 PO-- /dev/rplogdbs
516e0c70 5 5 4 126000 123697 PO-- /dev/rtempdbs
516e0df8 6 6 4 600064 217554 600064 POB- /dev/rimagebbs
516e1018 7 7 4 19456 12547 PO-- /dev/rimagedbs
516e11a0 8 8 0 15360 13700 PO-- /usr/informixdb/graphdbs
516e1328 9 9 0 240640 15036 15040 POB- /usr/informixdb/graphbbs
516e14b0 10 6 4 550000 547825 550000 POB- /dev/mapper/rootvg-imagebbs1
516e1638 11 5 4 2560000 2553897 PO-B /dev/mapper/rootvg-tempdbs1
516e17c0 12 9 0 128000 7997 8000 POB- /usr/informixdb/graphbbs1
516e1948 13 6 4 2560000 2549879 2560000 POBB /dev/mapper/rootvg-imagebbs2
516e1ad0 14 10 2 512000 431123 PO-- /dev/mapper/rootvg-bphistorydbs
516e1c58 15 11 2 512000 509367 PO-- /dev/mapper/rootvg-archivedbs
516e1de0 16 9 0 524288 32759 32768 POB- /usr/informixdb/graphbbs2

The last line is the new chunk I attempted to add in order to add space and alleviate this 93% full problem. I did that with the following command: "onspaces -a graphbbs -p /usr/informixdb/graphbbs2 -o 0 -s 1048576"

After this I ran a level 0 backup.

As you can see the free / total numbers for graphbbs still show 93% usage.

The following query also shows this:
"SELECT * FROM sysmaster:syschunks, sysmaster:sysdbspaces WHERE sysmaster:syschunks.dbsnum = sysmaster:sysdbspaces.dbsnum AND sysmaster:sysdbspaces.name = 'graphbbs'

begooden-it · #2 (**permalink**) 02-19-12, 04:10

Hi

I can read from your select statement in sysmaster that the new chunks size has a 524288 pages size, among which 32759 pages are free, so for me you have available space.

To get things clearer, state your select with a group by dbspace and with a sum on size and free, like this

Code:

SELECT name,fname,sum(chksize) as chksize,sum(chksize-nfree) as used,sum(nfree) as nfree
FROM syschunks, sysdbspaces
WHERE syschunks.dbsnum = sysdbspaces.dbsnum
group by 1,2
order by 1,2

Multiply the results by pagesize to have bytes, else results are in pages.

This would help to get clarity in your output :-)

Eric

Internet Services

Web Development

Digital Marketing

Consumer Tech