RE: Blobspace Issues [13838]
Have you done a backup and a onstat -d update to update BLOB chunk
statistics?
Bruce Simms
Data Base Services
TALX Corporation
2330 Ball Drive
St. Louis, MO 63146
Phone (314) 214-7703
FAX (314) 983-3238
bsimms@talx.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of C
GANGULY
Sent: Thursday, October 30, 2008 1:28 AM
To: ids@iiug.org
Subject: [Likely SPAM] 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.