This is a multi-part message in MIME format.
------=_NextPart_000_0016_01C8EBD5.33856240
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
The 2.6 do***entation was misleading. It was corrected in Ingres2006.
In 2.6 be sure to capture the output of the usermod command (I use tee)
so,
after a fail condition, you can restart the rebuild at the correct point.
In case of any fails, dont run usermod a second time otherwise you risk
losing index definitions. It is a good idea to keep a backup copy of the
schema definition just in case.
There has also been some recent enhancements to make the operation safer
by
rebuilding the indexes immediately after each table modify instead of at
the
very end.
Also the newer version provides more efficient parallel index rebuilds and
is therefore much faster.
I cant remember the patch numbers just now but will post them when I get
into the office.
Paul
-----Original Message-----
From: info-ingres-bounces@[EMAIL PROTECTED]
Behalf Of Wallen,
Alan - ES/EW
Sent: Tuesday, 22 July 2008 4:20 AM
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Question on usermod command
The Ingres 2.6 Command Reference Guide's description for the usermod
command states "The usermod command modifies a database's user-defined
tables to the most appropriate storage structure for accelerating query
processing."
I had thought that usermod simply modified the tables to their defined
storage structures which is what I recall seeing in the description for
usermod in the Ingres 2006 Command Reference Guide.
Has this command changed between the two versions of Ingres or is the
description incorrect in the Ingres 2.6 Command Reference Guide?
We're running Ingres 2.6 and I wouldn't want to suddenly have our
database
tables changed to unexpected storage structures if I were to run this
command.
Thanks,
Alan
________________________________
This e-mail and any files transmitted with it may be proprietary and are
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this e-mail in error please notify the
sender.
Please note that any views or opinions presented in this e-mail are
solely
those of the author and do not necessarily represent those of ITT
Cor****ation. The recipient should check this e-mail and any attachments
for
the presence of viruses. ITT accepts no liability for any damage caused by
any virus transmitted by this e-mail.
------=_NextPart_000_0016_01C8EBD5.33856240
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.3086" name=3DGENERATOR><!-- converted =
from rtf -->
<STYLE>.EmailQuote {
PADDING-LEFT: 4pt; MARGIN-LEFT: 1pt; BORDER-LEFT: #800000 2px solid
}
</STYLE>
</HEAD>
<BODY>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2>The=20
2.6 do***entation was misleading. It was corrected in=20
Ingres2006.</FONT></SPAN></DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2>In 2.6=20
be sure to capture the output of the usermod command (I use tee) =
so, after=20
a fail condition, you can restart the rebuild at the correct=20
point. In case of any fails, dont run usermod a second time =
otherwise=20
you risk losing index definitions. It is a good idea to keep a =
backup copy=20
of the schema definition just in case.</FONT></SPAN></DIV>
<DIV><SPAN class=3D031501022-21072008><FONT=20
color=3D#000000></FONT></SPAN> </DIV></FONT></SPAN></DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2>There=20
has also been some recent enhancements to make the operation safer by =
rebuilding=20
the indexes immediately after each table modify instead of at the very=20
end.</FONT></SPAN></DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2>Also the newer version provides more efficient parallel =
index=20
rebuilds and is therefore much faster.</FONT></SPAN></DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2>I cant=20
remember the patch numbers just now but will post them when I get into =
the=20
office.</FONT></SPAN></DIV>
<DIV><SPAN class=3D031501022-21072008></SPAN><SPAN=20
class=3D031501022-21072008></SPAN><SPAN class=3D031501022-21072008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2>Paul</FONT></SPAN></DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D031501022-21072008><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
info-ingres-bounces@[EMAIL PROTECTED]
[mailto:info-ingres-bounces@[EMAIL PROTECTED]
>On Behalf Of=20
</B>Wallen, Alan - ES/EW<BR><B>Sent:</B> Tuesday, 22 July 2008 4:20=20
AM<BR><B>To:</B> Ingres and related product discussion=20
forum<BR><B>Subject:</B> [Info-Ingres] Question on usermod=20
command<BR><BR></FONT></DIV><FONT face=3D"Arial, sans-serif" size=3D2>
<DIV>The Ingres 2.6 Command Reference Guide's description for the =
<B>usermod=20
</B>command states "The usermod command modifies a database's =
user-defined=20
tables to the most appropriate storage structure for accelerating =
query=20
processing."</DIV>
<DIV> </DIV>
<DIV>I had thought that <B>usermod </B>simply modified the tables to =
their=20
defined storage structures which is what I recall seeing in the =
description=20
for <B>usermod</B> in the Ingres 2006 Command Reference Guide.</DIV>
<DIV> </DIV>
<DIV>Has this command changed between the two versions of Ingres or is =
the=20
description incorrect in the Ingres 2.6 Command Reference Guide?</DIV>
<DIV> </DIV>
<DIV>We're running Ingres 2.6 and I wouldn't want to suddenly have our =
database tables changed to unexpected storage structures if I were to =
run this=20
command.</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>Alan</DIV>
<DIV> </DIV>
<DIV><FONT size=3D3><BR></FONT></DIV>
<DIV><FONT color=3D#c0c0c0 size=3D3><U> =
________________________________=20
</U></FONT></DIV>
<DIV><FONT face=3D"Arial, sans-serif" color=3D#808080>This e-mail and =
any files=20
transmitted with it may be proprietary and are intended solely for the =
use of=20
the individual or entity to whom they are addressed. If you have =
received this=20
e-mail in error please notify the sender.<BR>Please note that any =
views or=20
opinions presented in this e-mail are solely those of the author and =
do not=20
necessarily represent those of ITT Cor****ation. The recipient should =
check=20
this e-mail and any attachments for the presence of viruses. ITT =
accepts no=20
liability for any damage caused by any virus transmitted by this=20
e-mail.<BR></FONT></DIV></BLOCKQUOTE></FONT></BODY></HTML>
------=_NextPart_000_0016_01C8EBD5.33856240--
|
