HPL,Cannot execute "onpladm run job"
Lu Juan could not run onpladm run job as a non-informix user on IDS 10.00.FC3R1 on HP-UX, getting 'Cannot execute stored procedure start_onpload' with SQL error -668, though it worked on Linux with FC6. Jack Parker said -668 means an OS command cannot run or the user is not authenticated, and suggested checking public access to the onpload database. Lu Juan confirmed privileges and granted DBA to public, but it still failed. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
When I use HPL utility to load the data,and the execute user is not
"informix",I encounter a problem,the error message is:
Cannot execute stored procedure start_onpload SQL ERROR -668
If use the user "informix" to execute onpladm,everything is ok.
OS: HP-UX B.11.11 U 9000/800
DATABASE version: IDS10.00.FC3R1
The Method:
a)onpladm create job crbt_user -d /home/csp/lujuan/user20080317.unl -D csp -t
crbt_user1 -fl;
b)onpladm run job crbt_user -fl;
In the lab,I use HPL utility in a Linux machine,and the DATABASE version is
IDS10.00 FC6,the execute user is not "informix",but execute "onpladm run job
crbt_user -fl" is ok.
I can't reslove and understand this problem, please help,thanks in advance.
668 is either that you cannot run an OS command - unlikely in this case, or
that you have not authenticated to the database in question. Check whether
public has access to the onpload database (whatever you've named it).
j.
Sane ego te vocavi. Forsitan capedictum tuum desit.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of LU
JUAN
Sent: Tuesday, March 18, 2008 2:33 AM
To: ids@iiug.org
Subject: HPL,Cannot execute "onpladm run job" [11634]
When I use HPL utility to load the data,and the execute user is not
"informix",I encounter a problem,the error message is:
Cannot execute stored procedure start_onpload SQL ERROR -668
If use the user "informix" to execute onpladm,everything is ok.
OS: HP-UX B.11.11 U 9000/800
DATABASE version: IDS10.00.FC3R1
The Method:
a)onpladm create job crbt_user -d /home/csp/lujuan/user20080317.unl -D
csp -t
crbt_user1 -fl;
b)onpladm run job crbt_user -fl;
In the lab,I use HPL utility in a Linux machine,and the DATABASE version is
IDS10.00 FC6,the execute user is not "informix",but execute "onpladm run job
crbt_user -fl" is ok.
I can't reslove and understand this problem, please help,thanks in advance.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/0307car
lson/0307carlson.html
bye
The freedom of Linux ... The power of Informix
> To: ids@iiug.org
> From: lujuan_nc@163.com
> Subject: HPL,Cannot execute "onpladm run job" [11634]
> Date: Tue, 18 Mar 2008 03:33:23 -0400
>
> When I use HPL utility to load the data,and the execute user is not
> "informix",I encounter a problem,the error message is:
>
> Cannot execute stored procedure start_onpload SQL ERROR -668
>
> If use the user "informix" to execute onpladm,everything is ok.
>
> OS: HP-UX B.11.11 U 9000/800
> DATABASE version: IDS10.00.FC3R1
> The Method:
> a)onpladm create job crbt_user -d /home/csp/lujuan/user20080317.unl -D csp -t
> crbt_user1 -fl;
> b)onpladm run job crbt_user -fl;
>
> In the lab,I use HPL utility in a Linux machine,and the DATABASE version is
> IDS10.00 FC6,the execute user is not "informix",but execute "onpladm run job
> crbt_user -fl" is ok.
>
> I can't reslove and understand this problem, please help,thanks in advance.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> See you at the IIUG Informix 2008 Conference
> The Power Conference for Informix Professionals
> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
> http://www.iiug.org/conf
> Registration Now Open!!
_________________________________________________________________
Ingresá ya a MSN Deportes y enterate de las últimas novedades del mundo
deportivo.
http://msn.foxsports.com/fslasc/
I check that the user has the privileges to connect the onpload database.
Today,I drop the onpload database,and grant dba to public,and create a new
onpladm job,but the problem is also exist.
Maybe some configure is not right?? Please give me some advice,thanks.