Blobspace Issues

Hi, We have a blobspace as textdbs. Which is 98.5 percent full. I have added chunks to the dbspace but could not increase the free space count The onmonitor screen shows 7 0 1024000 788600 /dev/OnLine/dad_qa1_chk7 POBB 8 0 1024000 100 /dev/OnLine/dad_qa1_chk8 POBB 22 0 1024000 100 /dev/OnLine/dad_qa1_chk12 POBB For the last two dbspaces the used pages are 100 but when I am running the sql select a.dbsnum, a.name, sum(b.chksize),sum(b.nfree)from sysdbspaces a,syschunks b where a.dbsnum=b.dbsnum group by a.dbsnum,name Its showing still 98.5% full Please suggest if I am doing something wrong Regards Chandan

Huhmm...If you've added chunks and the percentage full is still the same then the question is... are you looking at the right (blob) dbspace? ________________________________ From: C GANGULY <chandan.ganguly@wyndhamworldwide.com> To: ids@iiug.org Sent: Thursday, October 30, 2008 2:28:07 AM Subject: Blobspace Issues [13838] Hi, We have a blobspace as textdbs. Which is 98.5 percent full. I have added chunks to the dbspace but could not increase the free space count The onmonitor screen shows 7 0 1024000 788600 /dev/OnLine/dad_qa1_chk7 POBB 8 0 1024000 100 /dev/OnLine/dad_qa1_chk8 POBB 22 0 1024000 100 /dev/OnLine/dad_qa1_chk12 POBB For the last two dbspaces the used pages are 100 but when I am running the sql select a.dbsnum, a.name, sum(b.chksize),sum(b.nfree)from sysdbspaces a,syschunks b where a.dbsnum=b.dbsnum group by a.dbsnum,name Its showing still 98.5% full Please suggest if I am doing something wrong Regards Chandan ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.