This is a multi-part message in MIME format.
------_=_NextPart_001_01C8B053.9A26D179
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I once though a sysmod might include iietabs, but it doesn't.
=20
I considered a modify to the new page size on an iietab table once, but =
eventually opted out.
Not being familiar with the 'behind the scenes' iietab management, I =
went for the safe, much longer way.
________________________________
From: Martin Bowes [mailto:martin.bowes@[EMAIL PROTECTED]
May 7, 2008 9:51 AM
To: Ingres and related product discussion forum
Cc: Laframboise Andr=E9
Subject: RE: [Info-Ingres] page_size on iietabs
Hi Andre,
=20
Dropping the original and recreating would take at least two hours.
=20
I'm lucky enough to have an agreement with the owner to take the =
database offline at the moment and connect with +U and modify the =
catalog directly. I'm not sure how long that will take, but it should be =
less.
=20
BTW. Expanding to 8k will probably buy me another year before I'm in =
this problem again ... on this column. Can I make the etab a partitioned =
table?
=20
Marty
=20
From: info-ingres-bounces@[EMAIL PROTECTED]
=
[mailto:info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of =
Laframboise Andr=E9
Sent: 07 May 2008 14:25
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] page_size on iietabs
=20
There's a page size and structure parameter for iietabs in CBF.
=20
We have ours at 64K pages.
=20
blob_etab_page_size =20
blob_etab_structure
=20
Once you set this, copy your existing table to a temp table, drop the =
original and re-create/copy.
=20
Andre =20
________________________________
From: info-ingres-bounces@[EMAIL PROTECTED]
=
[mailto:info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of =
Martin Bowes
Sent: May 7, 2008 9:00 AM
To: Ingres and related product discussion forum
Subject: [Info-Ingres] page_size on iietabs
Hi Everyone,
=20
I have a table with 4 long varchar columns. The table itself has only =
793613 rows on 142675 pages, but one of its sup****ting iietabs has just =
reached the magical 8.3million rows (1 row per page). And so now an =
insert into the table fails as the blob table cannot be extended.
=20
If this were an ordinary table I would simply expand the page size from =
2k to 8k and buy myself some more time. But I can't seem to do that with =
the iietab. I was hoping the page size would be copied from the base =
table when creating the blob table but this doesn't appear to be the =
case and its stuck on 2k pages.
=20
Is there a configuration parameter, or modify option that allows me to =
specify the page size on the iietabs?
=20
Would making the base table partitioned help the iietab?
=20
Ingres version is: II 9.0.4 (a64.lnx/105)NPTL + patch12707
=20
Martin Bowes
------_=_NextPart_001_01C8B053.9A26D179
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40"
xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:m =3D=20
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.3243" name=3DGENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
..shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@[EMAIL PROTECTED]
{
font-family: Calibri;
}
@[EMAIL PROTECTED]
{
font-family: Tahoma;
}
@[EMAIL PROTECTED]
Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt =
72.0pt; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: =
"Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: =
"Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: =
"Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: =
personal
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: =
personal-reply
}
..MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: ex****t-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=3DEN-GB vLink=3Dpurple link=3Dblue>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D406175714-07052008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>I once though a sysmod might include iietabs, =
but it=20
doesn't.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D406175714-07052008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D406175714-07052008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>I considered a modify to the new page size on=20
an iietab table once, but eventually opted out.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D406175714-07052008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Not being familiar with the 'behind the scenes' =
iietab=20
management, I went for </FONT></SPAN><SPAN =
class=3D406175714-07052008><FONT=20
face=3DArial color=3D#0000ff size=3D2>the safe, much longer=20
way.</FONT></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Martin Bowes=20
[mailto:martin.bowes@[EMAIL PROTECTED]
<BR><B>Sent:</B> May 7, 2008 9:51=20
AM<BR><B>To:</B> Ingres and related product discussion =
forum<BR><B>Cc:</B>=20
Laframboise Andr=E9<BR><B>Subject:</B> RE: [Info-Ingres] page_size on=20
iietabs<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><SPAN style=3D"COLOR: #1f497d">Hi =
Andre,<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: =
#1f497d"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: #1f497d">Dropping the =
original and=20
recreating would take at least two hours.<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: =
#1f497d"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: #1f497d">I'm lucky enough to =
have an=20
agreement with the owner to take the database offline at the =
moment and=20
connect with +U and modify the catalog directly. I'm not sure how long =
that will=20
take, but it should be less.<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: =
#1f497d"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: #1f497d">BTW. Expanding to 8k =
will=20
probably buy me another year before I'm in this problem again =85 on =
this column.=20
Can I make the etab a partitioned table?<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: =
#1f497d"><o:p> </o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: =
#1f497d">Marty<o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"COLOR: =
#1f497d"><o:p> </o:p></SPAN></P>
<DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: =
#b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: =
medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=3DMsoNormal><B><SPAN lang=3DEN-US=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
'Tahoma','sans-serif'">From:</SPAN></B><SPAN=20
lang=3DEN-US style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
'Tahoma','sans-serif'">=20
info-ingres-bounces@[EMAIL PROTECTED]
<B>On Behalf Of=20
</B>Laframboise Andr=E9<BR><B>Sent:</B> 07 May 2008 14:25<BR><B>To:</B> =
Ingres and=20
related product discussion forum<BR><B>Subject:</B> Re: [Info-Ingres] =
page_size=20
on iietabs<o:p></o:p></SPAN></P></DIV></DIV>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
'Arial','sans-serif'">There's=20
a page size and structure parameter for iietabs in CBF.</SPAN><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"><o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"> <o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
'Arial','sans-serif'">We have=20
ours at 64K pages.</SPAN><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"><o:p></o:p></SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"> <o:p></o:p></SPAN></P>
<DIV>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
'Arial','sans-serif'">blob_etab_page_size &n=
bsp; &nb=
sp; <BR>blob_etab_structure</SPAN><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"><o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"> <o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
'Arial','sans-serif'">Once you=20
set this, copy your existing table to a temp table, drop the original =
and=20
re-create/copy.</SPAN><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"><o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"> <o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
'Arial','sans-serif'">Andre =20
</SPAN><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"><o:p></o:p></SPAN></P></DIV>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" align=3Dcenter><SPAN =
lang=3DEN-US=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'">
<HR align=3Dcenter width=3D"100%" SIZE=3D2>
</SPAN></DIV>
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><B><SPAN lang=3DEN-US =
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
'Tahoma','sans-serif'">From:</SPAN></B><SPAN=20
lang=3DEN-US style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
'Tahoma','sans-serif'">=20
info-ingres-bounces@[EMAIL PROTECTED]
<B>On Behalf Of=20
</B>Martin Bowes<BR><B>Sent:</B> May 7, 2008 9:00 AM<BR><B>To:</B> =
Ingres and=20
related product discussion forum<BR><B>Subject:</B> [Info-Ingres] =
page_size on=20
iietabs</SPAN><SPAN lang=3DEN-US=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New =
Roman','serif'"><o:p></o:p></SPAN></P>
<P class=3DMsoNormal>Hi Everyone,<o:p></o:p></P>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal>I have a table with 4 long varchar columns. The =
table itself=20
has only 793613 rows on 142675 pages, but one of its sup****ting =
iietabs=20
has just reached the magical 8.3million rows (1 row per page). And so =
now an=20
insert into the table fails as the blob table cannot be =
extended.<o:p></o:p></P>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal>If this were an ordinary table I would simply =
expand the page=20
size from 2k to 8k and buy myself some more time. But I can't seem to do =
that=20
with the iietab. I was hoping the page size would be copied from the =
base table=20
when creating the blob table but this doesn't appear to be the case and =
its=20
stuck on 2k pages.<o:p></o:p></P>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal>Is there a configuration parameter, or modify =
option that=20
allows me to specify the page size on the iietabs?<o:p></o:p></P>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal>Would making the base table partitioned help the=20
iietab?<o:p></o:p></P>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal> Ingres version is: II 9.0.4 (a64.lnx/105)NPTL =
+=20
patch12707<o:p></o:p></P>
<P class=3DMsoNormal><o:p> </o:p></P>
<P class=3DMsoNormal>Martin Bowes<o:p></o:p></P></DIV></BODY></HTML>
------_=_NextPart_001_01C8B053.9A26D179--
|
