HPL Jobs
Hi all, I've reading about HPL features, but I didn't find how to stop a job. Is it posible? thanks in advance
HPL will automatically stop after finish. If you want to stop running job,
just use "ps" command to view pid of onpload process then kill master pid.
But sometime it doesnot clean semaphore correctly.
Regards,
Direk
-----Original Message-----
From: "PAULO RAFAEL PADILLA VELAZQUEZ" <rafaelpadilla@grupomayan.com>
To: ids@iiug.org
Date: Thu, 25 Oct 2007 17:28:19 -0400 (EDT)
Subject: HPL Jobs [10253]
> Hi all,
>
> I've reading about HPL features, but I didn't find how to stop a job.
>
> Is it posible?
>
> thanks in advance
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
You can look for the HPL processes (onpload) and then kill -15 them. Be
aware that there is a flag on the job in the onpload database indicating
that the job is running. You can manually reset that (I forget where it is
though) or just 'connect' to the job through the ipload interface, that will
pause for a minute or so while it attempts to connect to the running job,
when it finds that it cannot, it will reset the flag.
j.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
PAULO RAFAEL PADILLA VELAZQUEZ
Sent: Thursday, October 25, 2007 5:28 PM
To: ids@iiug.org
Subject: HPL Jobs [10253]
Hi all,
I've reading about HPL features, but I didn't find how to stop a job.
Is it posible?
thanks in advance
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
the flag is keep by column name "status" in table "session" on your
DBONPLOAD db.
For running job status='C'. after kill onpload process, if status is not
clear, you can manual update it by following sql:
update session set status='' where jobname='<your job>' ;or
update session set status=null where jobname='<your job>' ;
Regards,
Direk
-----Original Message-----
From: "Jack Parker" <jack.parker4@verizon.net>
To: ids@iiug.org
Date: Fri, 26 Oct 2007 08:15:57 -0400 (EDT)
Subject: RE: HPL Jobs [10265]
> You can look for the HPL processes (onpload) and then kill -15 them. Be
> aware that there is a flag on the job in the onpload database
> indicating
> that the job is running. You can manually reset that (I forget where it
> is
> though) or just 'connect' to the job through the ipload interface, that
> will
> pause for a minute or so while it attempts to connect to the running
> job,
> when it finds that it cannot, it will reset the flag.
>
> j.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
> PAULO RAFAEL PADILLA VELAZQUEZ
> Sent: Thursday, October 25, 2007 5:28 PM
> To: ids@iiug.org
> Subject: HPL Jobs [10253]
>
> Hi all,
>
> I've reading about HPL features, but I didn't find how to stop a job.
>
> Is it posible?
>
> thanks in advance
>
> ***********************************************************************
> *****
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
thx
j.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
direk
Sent: Saturday, October 27, 2007 6:57 AM
To: ids@iiug.org
Subject: RE: HPL Jobs [10277]
the flag is keep by column name "status" in table "session" on your
DBONPLOAD db.
For running job status='C'. after kill onpload process, if status is not
clear, you can manual update it by following sql:
update session set status='' where jobname='<your job>' ;or
update session set status=null where jobname='<your job>' ;
Regards,
Direk
-----Original Message-----
From: "Jack Parker" <jack.parker4@verizon.net>
To: ids@iiug.org
Date: Fri, 26 Oct 2007 08:15:57 -0400 (EDT)
Subject: RE: HPL Jobs [10265]
> You can look for the HPL processes (onpload) and then kill -15 them. Be
> aware that there is a flag on the job in the onpload database
> indicating
> that the job is running. You can manually reset that (I forget where it
> is
> though) or just 'connect' to the job through the ipload interface, that
> will
> pause for a minute or so while it attempts to connect to the running
> job,
> when it finds that it cannot, it will reset the flag.
>
> j.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
> PAULO RAFAEL PADILLA VELAZQUEZ
> Sent: Thursday, October 25, 2007 5:28 PM
> To: ids@iiug.org
> Subject: HPL Jobs [10253]
>
> Hi all,
>
> I've reading about HPL features, but I didn't find how to stop a job.
>
> Is it posible?
>
> thanks in advance
>
> ***********************************************************************
> *****
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.