RE: [ifxmaillist] dbspace and table size
This is a multi-part message in MIME format.
------=_NextPart_000_000A_01BFAA02.528A11E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
dbspace and table sizeonstat -d
oncheck -pt database:table
Is the load a "load from file insert into table"? or something else?
dbaccess or program?
MW
-----Original Message-----
From: owner-ifxmaillist@quanta.co.nz
[mailto:owner-ifxmaillist@quanta.co.nz]On Behalf Of Farmer, Byrd G - CFC
Sent: Wednesday, April 19, 2000 9:49 AM
To: 'informix-list@iiug.org'
Subject: [ifxmaillist] dbspace and table size
I am running into a small issue with one of our larger tables. We are
running 7.24 UC3 on Solaris 2.6.
The table has 33546106 rows and is 920 in size. There are 19 2 GIG chunks
in this dbspace. 4 GIG are free. When trying to load data, I am getting an
out of disk space error message. I have had this before and ended up
purging out 6 months of old data and then things loaded perfectly fine. I
am wondering if there is a size limit to a dbspace or table in Informix. I
would appreciate any help in this matter. Thanks in advance.
------=_NextPart_000_000A_01BFAA02.528A11E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>dbspace and table size</TITLE>
<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D660422001-19042000>onstat=20
-d</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D660422001-19042000>oncheck -pt =
database:table</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D660422001-19042000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D660422001-19042000>Is the=20
load a "load from file insert into table"? or something =
else? =20
dbaccess or program?</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D660422001-19042000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D660422001-19042000>MW</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
owner-ifxmaillist@quanta.co.nz =
[mailto:owner-ifxmaillist@quanta.co.nz]<B>On=20
Behalf Of </B>Farmer, Byrd G - CFC<BR><B>Sent:</B> Wednesday, April =
19, 2000=20
9:49 AM<BR><B>To:</B> 'informix-list@iiug.org'<BR><B>Subject:</B>=20
[ifxmaillist] dbspace and table size<BR><BR></DIV></FONT>
<P><FONT color=3D#000080 face=3D"Courier New" size=3D2>I am running =
into a small=20
issue with one of our larger tables. We are running 7.24 UC3 on =
Solaris=20
2.6.</FONT> <BR><FONT color=3D#000080 face=3D"Courier New" =
size=3D2>The table has=20
33546106 rows and is 920 in size. There are 19 2 GIG chunks in =
this=20
dbspace. 4 GIG are free. When trying to load data, I am =
getting an=20
out of disk space error message. I have had this before and =
ended up=20
purging out 6 months of old data and then things loaded perfectly =
fine. =20
I am wondering if there is a size limit to a dbspace or table in=20
Informix. I would appreciate any help in this matter. =
Thanks in=20
advance.</FONT></P><BR></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_000A_01BFAA02.528A11E0--