High Performance Load question
Hi
Folks,
Hopefully this won't have the =20 at the end of the line 8-)
IBM Informix Dynamic Server Version 9.40.UC2E1
Linux hostname 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
I have an issue with HPL when trying to run a job. I can create the job
successfully, run unsuccessfully and then delete the job successfully.
This is the version downloaded from iiug.org and installed on a linux
box. Is this limited perhaps and I'm unable to use this feature?
The commands I'm using are :
onpladm create job tmpjob3 -d /usr/hpltest/stock.unl -D stores_demo -t
stock -fu <----- works
onpladm run job tmpjob3 -fu <----- doesn't work
onpladm delete job tmpjob3 -fu -R <----- works
I am using the examples from the paper by John Carlson that I found on
the IBM website so can't understand why it wouldn't work.
The onpload database has been created and as the create and delete jobs
will attest, is reachable. There is nothing in the log files but they
are created in /tmp with a length of 0.
The messages are :
Successfully created Job tmpjob3 <----- from the create job
Connecting to onpload, Please wait...
Timeout error trying to connect to onpload <----- from the run job
Successfully deleted Job tmpjob3 <----- from the delete job
I have also tried the run job with a -S <my instance name> with no
success.
Any assistance or ideas where to look greatly appreciated.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
--0__=08BBE548DFC65F818f9e8a93df938690918c08BBE548DFC65F81
Content-type: multipart/alternative;
Boundary="1__=08BBE548DFC65F818f9e8a93df938690918c08BBE548DFC65F81"
--1__=08BBE548DFC65F818f9e8a93df938690918c08BBE548DFC65F81
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Hi Logan,
Try using onpload instead of onpladm while running the job.
I think their is a bug with Linux platform.
You can use.
onpladm create job tmpjob3 -d /usr/hpltest/stock.unl -D stores_demo -t
stock -fu
onpload -j tmpjob3 -fuonpladm delete job tmpjob3 -fu -R
and let me know if things are working fine.
Also 1 more thing, can you check/send me the permission of onpload bina=
ry.
Regards,
Pravin.
=
"Logan, Davi...." =
<david.logan@hp.c =
om> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
High Performance Load question =
04/06/2005 02:59 [4675] =
AM =
=
=
=
=
=
Hi Folks,
Hopefully this won't have the =3D20 at the end of the line 8-)
IBM Informix Dynamic Server Version 9.40.UC2E1
Linux hostname 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
I have an issue with HPL when trying to run a job. I can create the job=
successfully, run unsuccessfully and then delete the job successfully.
This is the version downloaded from iiug.org and installed on a linux
box. Is this limited perhaps and I'm unable to use this feature?
The commands I'm using are :
onpladm create job tmpjob3 -d /usr/hpltest/stock.unl -D stores_demo -t
stock -fu <----- works
onpladm run job tmpjob3 -fu <----- doesn't work
onpladm delete job tmpjob3 -fu -R <----- works
I am using the examples from the paper by John Carlson that I found on
the IBM website so can't understand why it wouldn't work.
The onpload database has been created and as the create and delete jobs=
will attest, is reachable. There is nothing in the log files but they
are created in /tmp with a length of 0.
The messages are :
Successfully created Job tmpjob3 <----- from the create job
Connecting to onpload, Please wait...
Timeout error trying to connect to onpload <----- from the run job
Successfully deleted Job tmpjob3 <----- from the delete job
I have also tried the run job with a -S <my instance name> with no
success.
Any assistance or ideas where to look greatly appreciated.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
=
--1__=08BBE548DFC65F818f9e8a93df938690918c08BBE548DFC65F81
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi Logan,<br>
<br>
Try using onpload instead of onpladm while running the job.<br>
I think their is a bug with Linux platform.<br>
<br>
You can use.<br>
<br>
<tt>onpladm create job tmpjob3 -d /usr/hpltest/stock.unl -D stores_demo=
-t stock -fu <br>
onpload -j tmpjob3 -fu <br>
onpladm delete job tmpjob3 -fu -R </tt><br>
<br>
<tt>and let me know if things are working fine.</tt><br>
<br><tt>Also 1 more thing, can you check/send me the permission of onpload =
binary.</tt><br>
<br>
<tt>Regards,</tt><br>
<tt>Pravin.<br>
</tt><br>
<img src=3D"cid:10__=3D08BBE548DFC65F818f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Logan, Davi..=
.." <david.logan@hp.com>">"Logan, Davi...." <da=
vid.logan@hp.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__=3D08BBE54=
8DFC65F818f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Logan, Davi...." <david.logan@hp.=
com></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">04/06/2005 02:59 AM</font></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__=3D08BBE548DFC65F818f9e8a93df938@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__=3D08BBE548DFC65F818f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE548DFC65F818f9e8a93df938@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__=3D08BBE548DFC65F818f9e8a93df938@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__=3D08BBE548DFC65F818f9e8a93df938@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__=3D08BBE548DFC65F818f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">High Performance Load question [4675]</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__=3D08BBE548DFC6=
5F818f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE548DFC65F818f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hi Folks,<br>
<br>
Hopefully this won't have the =3D20 at the end of the line 8-) <br>
<br>
IBM Informix Dynamic Server Version 9.40.UC2E1 <br>
Linux hostname 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386<=
br>@