Re: IDS HPL features....
This is a multi-part message in MIME format.
------=_NextPart_000_00D8_01C3F2EA.AE4C9770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Have a look at the load FAQ (www.artentech.com/downloads.htm) - if you =
can't get it let me know and I'll send it along - there is an external =
(to IBM) discussion of HPL and some of it's failings. The next section =
right after HPL is a discussion of the XPS ploader - which states =
essentially - imagine all of the power of HPL with all of the problems =
fixed. ;-). =20
The ploader is much nicer in that you have an internal table definition =
and can use the 'external files' as tables. =20
Get rid of the way HPL hogs shared memory until it runs out. =20
The ploader is much eaiser to script than HPL. onpladm is cute, but =
it's an afterthought, not a better solution. =20
Where there is a 2GB limit, it would be nice if the unloader dealt with =
that gracefully - either announcing in the beginning that there is =
insufficient space, or by creating a new unload file once it hit the 2GB =
boundary. It can be a real pain to set up an unload, you think you're =
ok, and then 30 minutes in it falls over because you didn't include =
anough files in your device to unload your 100GB table.
HPL is finicky (yes, that's a technical term) It might be easier to just =
port the ploader back and get rid of the interface all together.
Regards,
Jack Parker
----- Original Message -----=20
From: Pravin Kedia=20
To: informix-list@iiug.org=20
Sent: Tuesday, February 10, 2004 6:34 PM
Subject: IDS HPL features....
Hi All,
I am looking for new ideas and enhancements that our customers =
community need in IDS HPL product.
Can you please send me your problems/features/requirements that you =
need in HPL product?
Regards,
Pravin.
------=_NextPart_000_00D8_01C3F2EA.AE4C9770
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=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Have a look at the load FAQ (<A=20
href=3D"http://www.artentech.com/downloads.htm">www.artentech.com/downloa=
ds.htm</A>)=20
- if you can't get it let me know and I'll send it along - there is an =
external=20
(to IBM) discussion of HPL and some of it's failings. The =
next=20
section right after HPL is a discussion of the XPS ploader - which =
states=20
essentially - imagine all of the power of HPL with all of the problems=20
fixed. ;-). </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The ploader is much nicer in that you =
have an=20
internal table definition and can use the 'external files' as =
tables. =20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Get rid of the way HPL hogs shared =
memory until it=20
runs out. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The ploader is much eaiser to script =
than=20
HPL. onpladm is cute, but it's an afterthought, not a better=20
solution. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Where there is a 2GB limit, it would be =
nice if the=20
unloader dealt with that gracefully - either announcing in the beginning =
that=20
there is insufficient space, or by creating a new unload file once it =
hit the=20
2GB boundary. It can be a real pain to set up an unload, you think =
you're=20
ok, and then 30 minutes in it falls over because you didn't include =
anough files=20
in your device to unload your 100GB table.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>HPL is finicky (yes, that's a technical =
term) It=20
might be easier to just port the ploader back and get rid of the =
interface all=20
together.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jack Parker</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Dkedia@us.ibm.com href=3D"mailto:kedia@us.ibm.com">Pravin =
Kedia</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dinformix-list@iiug.org=20
href=3D"mailto:informix-list@iiug.org">informix-list@iiug.org</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, February 10, =
2004 6:34=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> IDS HPL =
features....</DIV>
<DIV><BR></DIV>
<P>Hi All,<BR><BR>I am looking for new ideas and enhancements that our =
customers community need in IDS HPL product.<BR>Can you please send me =
your=20
problems/features/requirements that you need in HPL=20
product?<BR><BR>Regards,<BR>Pravin.</P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_00D8_01C3F2EA.AE4C9770--
sending to informix-list