Re: HPL and PDQ
Neil,
Did you get this to work with onpload in 9.4? I have used HPL alot in
past releases and never gotten it to use the pdq settings for an index
build. My work around has always been to build the table with no
indexes, load the data using hpl, and then build the indexes in a
seperate sql setting pdqpriority and isolation level there. I am
getting ready to move to 9.4 soon and I would be interested in
learning more about how this works in the newer release. I have
several large tables I have to rebuild occasionally and getting this
to work directly in hpl would be a huge help.
Thanx,
~Tisha
Pravin Kedia <kedia@us.ibm.com> wrote in message news:<cg2ol5$4ec$1@news.xmission.com>...
> --0__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25
> Content-type: multipart/alternative;
> Boundary="1__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25"
>
> --1__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25
> Content-type: text/plain; charset=US-ASCII
> Content-transfer-encoding: quoted-printable
>
>
>
>
>
>
>
> Hi Neil,
>
> Please try to use onpload directly and see if you still see the same
> failure. If it works ok, then that is your workaround for time being.
> Then please get in contact with IBM Informix Tech support to open a cas=
> e
> with onpladm.
>
> Regards,
> Pravin.
>
>
>
> =
>
> "Neil Truby" =
>
> <neil.truby@arden =
>
> ta.com> =
> To
> Sent by: informix-list@iiug.org =
>
> owner-informix-li =
> cc
> st@iiug.org =
>
> Subj=
> ect
> Re: HPL and PDQ =
>
> 08/19/2004 03:21 =
>
> AM =
>
> =
>
> =
>
> Please respond to =
>
> "Neil Truby" =
>
> =
>
> =
>
>
>
>
>
> > Hi Neil,
> >
> > How are u running the onpload. Are you using ipload or onpladm?
> > If that is the case then we might not be passing these environment
> > varaibles to onpload.
>
> onpladm.
> From the original post you could see that some environment variables *w=
> ere*
> being passed, but not the important PDQ ones :-(
>
>
> =
>
> --1__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25
> Content-type: text/html; charset=US-ASCII
> Content-Disposition: inline
> Content-transfer-encoding: quoted-printable
>
> <html><body>
> <p>Hi Neil,<br>
> <br>
> Please try to use onpload directly and see if you still see the same fa=
> ilure. If it works ok, then that is your workaround for time being.<br>=
>
> Then please get in contact with IBM Informix Tech support to open a cas=
> e with onpladm.<br>
> <br>
> Regards,<br>
> Pravin.<br>
> <br>
> <img src=3D"cid:10__=3D08BBE466DFCDAC258f9e8a93df938@us.ibm.com" width=3D=
> "16" height=3D"16" alt=3D"Inactive hide details for "Neil Truby&qu=
> ot; <neil.truby@ardenta.com>">"Neil Truby" <neil.tru=
> by@ardenta.com><br>
> <br>
> <br>
>
> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
>
> <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE46=
> 6DFCDAC258f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
> th=3D"40%">
> <ul>
> <ul>
> <ul>
> <ul><b><font size=3D"2">"Neil Truby" <neil.truby@ardenta.c=
> om></font></b><font size=3D"2"> </font><br>
> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
> <p><font size=3D"2">08/19/2004 03:21 AM</font>
> <table border=3D"1">
> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"=
> center"><font size=3D"2">Please respond to<br>
> "Neil Truby"</font></div></td></tr>
> </table>
> </ul>
> </ul>
> </ul>
> </ul>
> </td><td width=3D"60%">
> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
>
> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
> 0__=3D08BBE466DFCDAC258f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
> 1" width=3D"58" alt=3D""><br>
> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
> 100%"><img src=3D"cid:30__=3D08BBE466DFCDAC258f9e8a93df938@us.ibm.com" =
> border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
> <font size=3D"2">informix-list@iiug.org</font></td></tr>
>
> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
> 0__=3D08BBE466DFCDAC258f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
> 1" width=3D"58" alt=3D""><br>
> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
> 100%"><img src=3D"cid:30__=3D08BBE466DFCDAC258f9e8a93df938@us.ibm.com" =
> border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
> </td></tr>
>
> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
> 0__=3D08BBE466DFCDAC258f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
> 1" width=3D"58" alt=3D""><br>
> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
> h=3D"100%"><img src=3D"cid:30__=3D08BBE466DFCDAC258f9e8a93df938@us.ibm.=
> com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
> <font size=3D"2">Re: HPL and PDQ</font></td></tr>
> </table>
>
> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE466DFCD=
> AC258f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
> =3D""></td><td width=3D"3
"Tisha" <loden@networkip.net> wrote in message
news:8085cdee.0408240701.35b83299@posting.google.com...
> Neil,
>
> Did you get this to work with onpload in 9.4? I have used HPL alot in
> past releases and never gotten it to use the pdq settings for an index
> build. My work around has always been to build the table with no
> indexes, load the data using hpl, and then build the indexes in a
> seperate sql setting pdqpriority and isolation level there. I am
> getting ready to move to 9.4 soon and I would be interested in
> learning more about how this works in the newer release. I have
> several large tables I have to rebuild occasionally and getting this
> to work directly in hpl would be a huge help.
Indeed this is what I do too. I haven't got it to work correctly. Priven
suggested that I raise a support case with UK Tech Support and I might do
this when I get time.