problem with HPL
Robin could not run an HPL job from ISA on IDS 2000 and Windows 2000. It failed with error -668 because user informix did not connect with a password. Helmut Leininger asked whether informix had a password. Earle Long said to log in to ISA as informix, not a read-only user, with the ISA install password. Robin found he had forgotten the Setnet32 configuration and it then worked.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello!
I have problem with executing HPL jobs from ISA (IDS 2000 on WIN2000)
output of ISA window:
Command Output
onpladm run job robertw.state -p robwol -fu -l
"/tmp/robertw.state.log"
Cannot execute stored procedure start_onpload SQL ERROR -668
onstat -m:12:54:27 System() command
"/usr/informix/bin/onpload -Sol_robertw -r14 -fb"in SPL routine cannot be executed because user "informix" did not connect
with a password.
Robert
Robin wrote:
> Hello!
> I have problem with executing HPL jobs from ISA (IDS 2000 on WIN2000)
>
> output of ISA window:
> Command Output
> onpladm run job robertw.state -p robwol -fu -l
> "/tmp/robertw.state.log"
> Cannot execute stored procedure start_onpload SQL ERROR -668
>
>
>
>
>
> onstat -m:> 12:54:27 System() command
> "/usr/informix/bin/onpload -Sol_robertw -r14 -fb"> in SPL routine cannot be executed because user "informix" did not connect
> with a password.
>
> Robert
Does the user informix have a password ?
--
Helmut Leininger
Bull AG / Vienna
Open Systems Support
Email: h.leininger@bull.at
This opinion is mine and not necessarily that of my employer.
No guarantees whatsoever.
Close your ISA Session and relogin as informix not a read-only user. The
informix password is the one you setup when installing ISA on the host
machine not the hosts informix password.
Yours
--
Earle A Long (Senior DBA)
SinglePoint Limited
"Robin" <robertw@szczecin.pekao.com.pl> wrote in message
news:96gi0i$iih$1@news.tpi.pl...
> Hello!
> I have problem with executing HPL jobs from ISA (IDS 2000 on WIN2000)
>
> output of ISA window:
> Command Output
> onpladm run job robertw.state -p robwol -fu -l
> "/tmp/robertw.state.log"
> Cannot execute stored procedure start_onpload SQL ERROR -668
>
>
>
>
>
> onstat -m:> 12:54:27 System() command
> "/usr/informix/bin/onpload -Sol_robertw -r14 -fb"> in SPL routine cannot be executed because user "informix" did not connect
> with a password.
>
> Robert
>
>
>
>
U'ytkownik "Earle A Long" <earle@btclick.com> napisa' w wiadomo'ci
news:JH8j6.18219$bP4.31687@NewsReader...
> Close your ISA Session and relogin as informix not a read-only user. The
> informix password is the one you setup when installing ISA on the host
> machine not the hosts informix password.
>
> Yours
> --
> Earle A Long (Senior DBA)
> SinglePoint Limited
>
>
> "Robin" <robertw@szczecin.pekao.com.pl> wrote in message
> news:96gi0i$iih$1@news.tpi.pl...
> > Hello!
> > I have problem with executing HPL jobs from ISA (IDS 2000 on WIN2000)
> >
> > output of ISA window:
> > Command Output
> > onpladm run job robertw.state -p robwol -fu -l
> > "/tmp/robertw.state.log"
> > Cannot execute stored procedure start_onpload SQL ERROR -668
> >
> >
> >
> >
> >
> > onstat -m:> > 12:54:27 System() command
> > "/usr/informix/bin/onpload -Sol_robertw -r14 -fb"> > in SPL routine cannot be executed because user "informix" did not
connect
> > with a password.
> >
> > Robert
> >
> >
> >
> >
>
>
I forgot about Setnet32 configuration. Now it's working.
Robert