Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    3

    Unanswered: Adding chunk but not seeing any more free space

    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'

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •