Re: tbcheck problem
In article <5je9dm$d4t@cssun.mathcs.emory.edu>, Daniel W Farrow IV 89-
28759 fax 99-26758 <Daniel.W.Farrow-IV@usa.dupont.com> writes
>We are running Informix 5.14 on an IBM rs6000 under AIX. We have been
>having a problem with tbcheck of the blob space. We have three full chunks
>and one only partially filled.
>
>I forced everyone off the system (quiescent mode) and tried
>tbcheck -pB. I get...
>
>$ tbcheck -pB database:table>
>
>
>BLOBSpace Report for database:owner.table
>
>sort: Write error while sorting.
> Total pages used by table 1665171
>
> BLOBSpace usage:
>
> Space Page Percent Full
> Name Number Pages 0-25% 26-50% 51-75% 76-100%
> -----------------------------------------------------------------
>Error opening file /tmp/14946.BLOBUSE.
>$
>
>...after about 2 hours of running!
>
>ls -l /tmp shows:
>-rw-rw---- 1 informix informix 18625963 Apr 20 11:48 14946.blobuse
>
>/tmp has about 100,000,000 allocation, so there is plenty of space.
>(three times the above size of 18,000,000 was recommended and we have
>five times.)
>There is no 14946.BLOBUSE file!
>
>Any thoughts??? Anyone else encounter problems with tbcheck?
>
>Be seeing you,
>-DAN
>
Proably ran out of space whilst sorting, then deleted the
14946.BLOBUSE file. Try setting the DBTEMP enviroment variable
to somewhere with more space.
--
David Williams