oncheck -pe output

Posted in 1998

ccremid — Mon, 22 Jun 1998 13:00:24 -0400 — source: Informix-list mailing list archive (1991-1998)

Informix gurus: After running oncheck -pe on Online 7.23/AIX 4.2 I got the following output for my Temp dbspace. DBspace Usage Report: dbtemp Owner: informix Created: 02/25/98 Chunk: 3 /dev/RDBTEMP Size Used Free 75000 703 74297 Disk usage for Chunk 3 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 768 TBLSPACE TBLSPACE 821 50 FREE 871 800 [... snip ...] TBLSPACE TBLSPACE 1671 50 FREE 10221 800 TBLSPACE TBLSPACE 11021 50 FREE 11071 63929 Can someone explain the use of this TBLSPACE TBLSPACE allocations?. Is there any way to delete them? As you can see even though I have 74297 free pages on this Temp dbspace, I have only 63929 continuos pages. This is not a problem right now, but I am afraid that this will scale to a point where more space is used for TBLSPACE TBLSPACE than for real data. Any ideas? TIA Tino