Oninit cdi / Archive
Talk to an expert →

RE: [ifxmaillist] dbspace and table size

Posted in 2000

Farmer, Byrd G - CFC — — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BFAA06.2FAEE520 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01BFAA06.2FAEE520" ------_=_NextPart_001_01BFAA06.2FAEE520 Content-Type: text/plain; charset="iso-8859-1" This is from a space report ------------------------ dbs_fbcorr ------------------------ address chk/dbs offset size free flags name 5803b428 18 18 0 1000000 222684 PO- stripe1v14 5803b860 23 18 0 1000000 0 PO- stripe1v21 5803be48 30 18 0 1000000 0 PO- stripe1v17 5805e030 32 18 0 1000000 0 PO- stripe1v24 5805e1e0 34 18 0 1000000 0 PO- stripe2v22 5805e390 36 18 0 1000000 0 PO- stripe2v1 5805e540 38 18 0 1000000 0 PO- stripe2v20 5805e6f0 40 18 0 1000000 0 PO- stripe2v4 5805e8a0 42 18 0 1000000 0 PO- stripe2v18 5805ea50 44 18 0 1000000 0 PO- stripe2v6 5805ecd8 47 18 0 1000000 0 PO- stripe3v14 5805ef60 50 18 0 1000000 0 PO- stripe2v23 5805f398 55 18 0 1000000 0 PO- stripe1v11 5805f980 62 18 0 1000000 0 PO- stripe2v8 5805fa58 63 18 0 1000000 0 PO- stripe3v10 58069430 69 18 0 1000000 0 PO- stripe3v22 58069bc8 78 18 0 1000000 0 PO- stripe2v12 5832a018 83 18 0 1000000 999997 PO- stripe4v32 5832a888 93 18 0 1000000 999997 PO- stripe4v33 In dbschema the extent size is 20000000 and 500000 for next extent. -----Original Message----- From: Murray Wood [mailto:murray@quanta.co.nz] Sent: Tuesday, April 18, 2000 6:23 PM To: 'Farmer, Byrd G - CFC'; informix-list@iiug.org Subject: RE: [ifxmaillist] dbspace and table size onstat -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_001_01BFAA06.2FAEE520 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>dbspace and table size</TITLE> <META content='"MSHTML 4.72.3612.1706"' name=GENERATOR> </HEAD> <BODY> <DIV><SPAN class=770284913-19042000><FONT color=#0000ff face="Courier New" size=2>This is from a space report </FONT></SPAN></DIV> <DIV><FONT color=#0000ff face="Courier New" size=2>------------------------ dbs_fbcorr ------------------------</FONT></DIV> <DIV><FONT color=#0000ff face="Courier New" size=2></FONT>&nbsp;</DIV> <DIV><FONT color=#0000ff face="Courier New" size=2>address&nbsp; chk/dbs offset&nbsp;&nbsp; size&nbsp;&nbsp;&nbsp;&nbsp; free&nbsp;&nbsp;&nbsp; flags&nbsp;&nbsp;&nbsp; name<BR>5803b428 18&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 222684&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe1v14<BR>5803b860 23&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe1v21<BR>5803be48 30&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe1v17<BR>5805e030 32&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe1v24<BR>5805e1e0 34&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v22<BR>5805e390 36&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v1<BR>5805e540 38&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v20<BR>5805e6f0 40&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v4<BR>5805e8a0 42&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v18<BR>5805ea50 44&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v6<BR>5805ecd8 47&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe3v14<BR>5805ef60 50&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v23<BR>5805f398 55&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe1v11<BR>5805f980 62&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v8<BR>5805fa58 63&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe3v10<BR>58069430 69&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe3v22<BR>58069bc8 78&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe2v12<BR>5832a018 83&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 999997&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe4v32<BR>5832a888 93&nbsp; 18&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000000&nbsp; 999997&nbsp;&nbsp; PO-&nbsp;&nbsp; stripe4v3<SPAN class=770284913-19042000><FONT color=#0000ff face="Courier New" size=2>3</FONT></SPAN></FONT></DIV> <DIV><FONT color=#0000ff face="Courier New" size=2><SPAN class=770284913-19042000><FONT color=#0000ff face="Courier New" size=2></FONT></SPAN></FONT>&nbsp;</DIV> <DIV><SPAN class=770284913-19042000><FONT color=#0000ff face="Courier New" siz

Related threads