Re[2]: oncheck -pe output
This is a multipart message in MIME format
--------------InterScan_NT_MIME_Boundary
Content-Type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable
Or you could just bring Informix down and back up=2E As it is a=20
temporary dbspace, it will be completely refreshed when the engine=20
comes back up again=2E
=20
Davin
______________________________ Reply Separator ____________________________=
_____
Subject: Re: oncheck -pe output
Author: MIME {david=2Eashby@workcover=2Ensw=2Egov=2Eau} at INTERNET
Date: 23/06/1998 07:58
=20
Tino,
=20
I had a similar problem last month=2E only it was on a temp dbspace I=20
was down to 50 meg of contiguous space when the dbspace was defined as=
=20
1 gig=2E This problem arises when there is lots of new tables being=20
inserted and deleted into the chunk, also temp files in the case of a=20
temp dbspace=2E
=20
When I talked to Informix I was told the only way to fix the problem=20
was to drop and recreate the dbspace=2E
=20
=20
Regards
=20
=20
David Ashby
=20
=20
______________________________ Reply Separator=20
_________________________________
Subject: oncheck -pe output
Author: ccremid <ccremid@saadev=2Esaa=2Enoaa=2Egov> at WCA-INET=20
Date: 22/6/98 1:00 PM
=20
=20
Informix gurus:
=20
After running oncheck -pe on Online 7=2E23/AIX 4=2E2 I got the=20
following output for my Temp dbspace=2E
=20
DBspace Usage Report: dbtemp Owner: informix Created:=20
02/25/98
=20
Chunk: 3 /dev/RDBTEMP Size Used =20
Free
75000 703 =20
74297
=20
Disk usage for Chunk 3 Start Length=20
------------------------------------------- --------- ---------=20
OTHER RESERVED Pages 0 2=20
CHUNK FREE LIST PAGE 2 1=20
TBLSPACE TBLSPACE 3 50=20
FREE 53 768=20
TBLSPACE TBLSPACE 821 50=20
FREE 871 800=20
[=2E=2E=2E snip =2E=2E=2E]
TBLSPACE TBLSPACE 1671 50=20
FREE 10221 800=20
TBLSPACE TBLSPACE 11021 50=20
FREE 11071 63929
=20
Can someone explain the use of this TBLSPACE TBLSPACE allocations?=2E=20
Is there any way to delete them?
=20
As you can see even though I have 74297 free pages on this Temp dbspace,=20
I have only 63929 continuos pages=2E This is not a problem right now, but=20
I am afraid that this will scale to a point where more space is used for=20
TBLSPACE TBLSPACE than for real data=2E
=20
Any ideas?
=20
TIA
=20
Tino
=20
=20
=20
=20
**********************************************************************
DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu=
k=20
This message and any attachments to it is intended only for the=20
individual or company to which it is addressed and may contain=20
information which is privileged, confidential or prohibited from=20
disclosure or unauthorised use=2E If the recipient of this=20
transmission is not the intended recipient, or the employee or agent=20
responsible for delivering such materials to the intended recipient,=20
you are hereby notified that any use, any form of reproduction,=20
dissemination, copying, disclosure, modification, distribution and/or=20
publication of this e-mail message or its attachments other than by=20
its intended recipient is strictly prohibited by the sender=2E =20
If you have received it in error, please notify us immediately by=20
telephone on the number above and destroy the message and all copies=20
in your possession=2E
**********************************************************************
--------------InterScan_NT_MIME_Boundary--