Re[3]: oncheck -pe output
Davin,
It doesn't work. The temp dbspace is still fragmented. The "TBLSPACE
TBLSPACE" is not released.
David
______________________________ Reply Separator _________________________________
Subject: Re[2]: oncheck -pe output
Author: <davin_harvey@dsti.co.uk> at WCA-INET
Date: 23/6/98 8:49 AM
Or you could just bring Informix down and back up. As it is a
temporary dbspace, it will be completely refreshed when the engine
comes back up again.
Davin
______________________________ Reply Separator _________________________________
Subject: Re: oncheck -pe output
Author: MIME {david.ashby@workcover.nsw.gov.au} at INTERNET
Date: 23/06/1998 07:58
Tino,
I had a similar problem last month. only it was on a temp dbspace I
was down to 50 meg of contiguous space when the dbspace was defined as
1 gig. This problem arises when there is lots of new tables being
inserted and deleted into the chunk, also temp files in the case of a
temp dbspace.
When I talked to Informix I was told the only way to fix the problem
was to drop and recreate the dbspace.
Regards
David Ashby
______________________________ Reply Separator
_________________________________
Subject: oncheck -pe output
Author: ccremid <ccremid@saadev.saa.noaa.gov> at WCA-INET
Date: 22/6/98 1:00 PM
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
**********************************************************************
DST International Tel:+44 181 390 5000 www.dstinternational.co.uk
This message and any attachments to it is intended only for the
individual or company to which it is addressed and may contain
information which is privileged, confidential or prohibited from
disclosure or unauthorised use. If the recipient of this
transmission is not the intended recipient, or the employee or agent
responsible for delivering such materials to the intended recipient,
you are hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message or its attachments other than by
its intended recipient is strictly prohibited by the sender.
If you have received it in error, please notify us immediately by
telephone on the number above and destroy the message and all copies
in your possession.
**********************************************************************