RE: [ifxmaillist] dbspace and table size
Posted in 2000
Topics: Storage & Space Management, Server Administration, Platform-Specific Issues
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_001_01BFAA08.5D338120
Content-Type: text/plain;
charset="iso-8859-1"
By the way, I am not using the insert into statement. I am using
Informatica ETL tool.
Thanks!
-----Original Message-----
From: Farmer, Byrd G - CFC
Sent: Wednesday, April 19, 2000 6:50 AM
To: 'murray@quanta.co.nz'; Farmer, Byrd G - CFC; informix-list@iiug.org
Subject: RE: [ifxmaillist] dbspace and table size
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_01BFAA08.5D338120
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=450010814-19042000><FONT color=#0000ff face="Courier New"
size=2>By the way, I am not using the insert into statement. I am using
Informatica ETL tool.</FONT></SPAN></DIV>
<DIV><SPAN class=450010814-19042000><FONT color=#0000ff face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=450010814-19042000><FONT color=#0000ff face="Courier New"
size=2>Thanks!</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B> Farmer, Byrd G - CFC
<BR><B>Sent:</B> Wednesday, April 19, 2000 6:50 AM<BR><B>To:</B>
'murray@quanta.co.nz'; Farmer, Byrd G - CFC;
informix-list@iiug.org<BR><B>Subject:</B> RE: [ifxmaillist] dbspace and
table size<BR><BR></FONT></DIV>
<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> </DIV>
<DIV><FONT color=#0000ff face="Courier New" size=2>address chk/dbs
offset size free
flags name<BR>5803b428 18 18
0 1000000 222684
PO- stripe1v14<BR>5803b860 23 18
0 1000000
0 PO-
stripe1v21<BR>5803be48 30 18
0 1000000
0 PO-
stripe1v17<BR>5805e030 32 18
0 1000000
0 PO-
stripe1v24<BR>5805e1e0 34 18
0 1000000
0 PO-
stripe2v22<BR>5805e390 36 18
0 1000000
0 PO-
stripe2v1<BR>5805e540 38 18
0 1000000
0 PO-
stripe2v20<BR>5805e6f0 40 18
0 1000000
0 PO-
stripe2v4<BR>5805e8a0 42 18
0 1000000
0 PO-
stripe2v18<BR>5805ea50 44 18
0 1000000
0 PO-
stripe2v6<BR>5805ecd8 47 18
0 1000000
0 PO-
stripe3v14<BR>5805ef60 50 18
0 1000000
0 PO-
stripe2v23<BR>5805f398 55 18
0 1000000
0 PO-
stripe1v11<BR>5805f980 62 18
0 1000000&nbs
Related threads
- IDS 10 table-level restore
- DBPATH & INFORMIXSERVER - HELP
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape