Hi, All
I have a job which call unix script to extract data from csv file being in Unix.
For some reason, this job kept running serval hours last night, but did nothing. This morning, I tried to stop it by command dsjob -stop ..., its status was still "RUNNING",
Then I went to Cleanup Resources, logout process, back to Unix, I found it was still running.
Now, even I have killed its process against unix. I still couldnt compile this job.
Anybody have experienced this problem, could you please give me some idea?
Thanks in advance
Xiong
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.
How to stop datastage job running
The job status is not the actual status, but the status the last time the status was recorded. This is a value in the RT_STATUS table for the particular job in the DataStage repository. So the job may actually be finished or stopped (possibly abnormally), but didnt get the chance to update its status information. This is one case where you would check the processes that are/were involved in the job run then, having ascertained that theyre no longer there, either adjust the job status in the table or clear the status file (from Director).
-----Original Message-----
From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
Sent: Wednesday, 15 August 2001 09:05
To: datastage-users@oliver.com
Subject: How to stop datastage job running
Hi, All
I have a job which call unix script to extract data from csv file being in Unix. For some reason, this job kept running serval hours last night, but did nothing. This morning, I tried to stop it by command dsjob -stop ..., its status was still "RUNNING", Then I went to Cleanup Resources, logout process, back to Unix, I found it was still running. Now, even I have killed its process against unix. I still couldnt compile this job. Anybody have experienced this problem, could you please give me some idea?
Thanks in advance
Xiong
DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Carter Holt Harvey is not responsible for any changes made to this message and / or any attachments after sending by Carter Holt Harvey. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
-----Original Message-----
From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
Sent: Wednesday, 15 August 2001 09:05
To: datastage-users@oliver.com
Subject: How to stop datastage job running
Hi, All
I have a job which call unix script to extract data from csv file being in Unix. For some reason, this job kept running serval hours last night, but did nothing. This morning, I tried to stop it by command dsjob -stop ..., its status was still "RUNNING", Then I went to Cleanup Resources, logout process, back to Unix, I found it was still running. Now, even I have killed its process against unix. I still couldnt compile this job. Anybody have experienced this problem, could you please give me some idea?
Thanks in advance
Xiong
DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Carter Holt Harvey is not responsible for any changes made to this message and / or any attachments after sending by Carter Holt Harvey. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
Thanks, Ray. I know "RUNNING" is not the actual status, the issue is I couldnt compile this job even I am surely it had stopped just now. Now, its status has automatically changed to be "Compiled", but I cant compile it, because of "Cannot get exclusive access to executable file for job......", the Show Error prompt me the message "(40908) A request for object with a NULL ID was made",
So, how should I do next?
> -----Original Message-----
> From: Ray Wurlod [SMTP:ray.wurlod@Informix.Com]
> Sent: Wednesday, 15 August 2001 13:20
> To: datastage-users@oliver.com
> Subject: RE: How to stop datastage job running
>
> The job status is not the actual status, but the status the last time
> the status was recorded. This is a value in the RT_STATUS table for
> the particular job in the DataStage repository. So the job may
> actually be finished or stopped (possibly abnormally), but didnt get
> the chance to update its status information. This is one case where
> you would check the processes that are/were involved
> in the job run then, having ascertained that theyre no longer there,
> either
> adjust the job status in the table or clear the status file (from
> Director).
>
> -----Original Message-----
> From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
> Sent: Wednesday, 15 August 2001 09:05
> To: datastage-users@oliver.com
> Subject: How to stop datastage job running
>
>
> Hi, All
>
> I have a job which call unix script to extract data from csv file
> being in Unix. For some reason, this job kept running serval hours
> last night, but did nothing. This morning, I tried to stop it by
> command dsjob -stop ..., its status was still "RUNNING",
> Then I went to Cleanup Resources, logout process, back to Unix, I found
> it
> was still running.
> Now, even I have killed its process against unix. I still couldnt compile
> this job.
> Anybody have experienced this problem, could you please give me some idea?
>
> Thanks in advance
>
> Xiong
>
>
> DISCLAIMER: This electronic message together with any attachments is
> confidential. If you are not the intended recipient, do not copy,
> disclose or
> use the contents in any way. Please also advise us by return e-mail that
> you
> have received the message and then please destroy. Carter Holt Harvey is
> not
> responsible for any changes made to this message and / or any attachments
> after
> sending by Carter Holt Harvey. We use virus scanning software but exclude
> all
> liability for viruses or anything similar in this email or any attachment.
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.
So, how should I do next?
> -----Original Message-----
> From: Ray Wurlod [SMTP:ray.wurlod@Informix.Com]
> Sent: Wednesday, 15 August 2001 13:20
> To: datastage-users@oliver.com
> Subject: RE: How to stop datastage job running
>
> The job status is not the actual status, but the status the last time
> the status was recorded. This is a value in the RT_STATUS table for
> the particular job in the DataStage repository. So the job may
> actually be finished or stopped (possibly abnormally), but didnt get
> the chance to update its status information. This is one case where
> you would check the processes that are/were involved
> in the job run then, having ascertained that theyre no longer there,
> either
> adjust the job status in the table or clear the status file (from
> Director).
>
> -----Original Message-----
> From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
> Sent: Wednesday, 15 August 2001 09:05
> To: datastage-users@oliver.com
> Subject: How to stop datastage job running
>
>
> Hi, All
>
> I have a job which call unix script to extract data from csv file
> being in Unix. For some reason, this job kept running serval hours
> last night, but did nothing. This morning, I tried to stop it by
> command dsjob -stop ..., its status was still "RUNNING",
> Then I went to Cleanup Resources, logout process, back to Unix, I found
> it
> was still running.
> Now, even I have killed its process against unix. I still couldnt compile
> this job.
> Anybody have experienced this problem, could you please give me some idea?
>
> Thanks in advance
>
> Xiong
>
>
> DISCLAIMER: This electronic message together with any attachments is
> confidential. If you are not the intended recipient, do not copy,
> disclose or
> use the contents in any way. Please also advise us by return e-mail that
> you
> have received the message and then please destroy. Carter Holt Harvey is
> not
> responsible for any changes made to this message and / or any attachments
> after
> sending by Carter Holt Harvey. We use virus scanning software but exclude
> all
> liability for viruses or anything similar in this email or any attachment.
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.
Use the other maintenance tool in Director (Cleanup Resources) to determine what is locked (and thus causing the "cannot get exclusive access" message. I am travelling at the moment, so dont have all my usual resources to hand. Contact support to get more information about what error code 40908 means, and how to release locks held by aborted/redundant processes.
-----Original Message-----
From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
Sent: Wednesday, 15 August 2001 09:53
To: datastage-users@oliver.com
Subject: RE: How to stop datastage job running
Thanks, Ray. I know "RUNNING" is not the actual status, the issue is I couldnt compile this job even I am surely it had stopped just now. Now, its status has automatically changed to be "Compiled", but I cant compile it, because of "Cannot get exclusive access to executable file for job......", the Show Error prompt me the message "(40908) A request for object with a NULL ID was made",
So, how should I do next?
> -----Original Message-----
> From: Ray Wurlod [SMTP:ray.wurlod@Informix.Com]
> Sent: Wednesday, 15 August 2001 13:20
> To: datastage-users@oliver.com
> Subject: RE: How to stop datastage job running
>
> The job status is not the actual status, but the status the last time
> the status was recorded. This is a value in the RT_STATUS table for
> the particular job in the DataStage repository. So the job may
> actually be finished or stopped (possibly abnormally), but didnt get
> the chance to update its status information. This is one case where
> you would check the processes that are/were involved
> in the job run then, having ascertained that theyre no longer there,
> either
> adjust the job status in the table or clear the status file (from
> Director).
>
> -----Original Message-----
> From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
> Sent: Wednesday, 15 August 2001 09:05
> To: datastage-users@oliver.com
> Subject: How to stop datastage job running
>
>
> Hi, All
>
> I have a job which call unix script to extract data from csv file
> being in Unix. For some reason, this job kept running serval hours
> last night, but did nothing. This morning, I tried to stop it by
> command dsjob -stop ..., its status was still "RUNNING",
> Then I went to Cleanup Resources, logout process, back to Unix, I found
> it
> was still running.
> Now, even I have killed its process against unix. I still couldnt compile
> this job.
> Anybody have experienced this problem, could you please give me some idea?
>
> Thanks in advance
>
> Xiong
>
>
> DISCLAIMER: This electronic message together with any attachments is
> confidential. If you are not the intended recipient, do not copy,
> disclose or
> use the contents in any way. Please also advise us by return e-mail that
> you
> have received the message and then please destroy. Carter Holt Harvey is
> not
> responsible for any changes made to this message and / or any attachments
> after
> sending by Carter Holt Harvey. We use virus scanning software but exclude
> all
> liability for viruses or anything similar in this email or any attachment.
DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Carter Holt Harvey is not responsible for any changes made to this message and / or any attachments after sending by Carter Holt Harvey. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
-----Original Message-----
From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
Sent: Wednesday, 15 August 2001 09:53
To: datastage-users@oliver.com
Subject: RE: How to stop datastage job running
Thanks, Ray. I know "RUNNING" is not the actual status, the issue is I couldnt compile this job even I am surely it had stopped just now. Now, its status has automatically changed to be "Compiled", but I cant compile it, because of "Cannot get exclusive access to executable file for job......", the Show Error prompt me the message "(40908) A request for object with a NULL ID was made",
So, how should I do next?
> -----Original Message-----
> From: Ray Wurlod [SMTP:ray.wurlod@Informix.Com]
> Sent: Wednesday, 15 August 2001 13:20
> To: datastage-users@oliver.com
> Subject: RE: How to stop datastage job running
>
> The job status is not the actual status, but the status the last time
> the status was recorded. This is a value in the RT_STATUS table for
> the particular job in the DataStage repository. So the job may
> actually be finished or stopped (possibly abnormally), but didnt get
> the chance to update its status information. This is one case where
> you would check the processes that are/were involved
> in the job run then, having ascertained that theyre no longer there,
> either
> adjust the job status in the table or clear the status file (from
> Director).
>
> -----Original Message-----
> From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
> Sent: Wednesday, 15 August 2001 09:05
> To: datastage-users@oliver.com
> Subject: How to stop datastage job running
>
>
> Hi, All
>
> I have a job which call unix script to extract data from csv file
> being in Unix. For some reason, this job kept running serval hours
> last night, but did nothing. This morning, I tried to stop it by
> command dsjob -stop ..., its status was still "RUNNING",
> Then I went to Cleanup Resources, logout process, back to Unix, I found
> it
> was still running.
> Now, even I have killed its process against unix. I still couldnt compile
> this job.
> Anybody have experienced this problem, could you please give me some idea?
>
> Thanks in advance
>
> Xiong
>
>
> DISCLAIMER: This electronic message together with any attachments is
> confidential. If you are not the intended recipient, do not copy,
> disclose or
> use the contents in any way. Please also advise us by return e-mail that
> you
> have received the message and then please destroy. Carter Holt Harvey is
> not
> responsible for any changes made to this message and / or any attachments
> after
> sending by Carter Holt Harvey. We use virus scanning software but exclude
> all
> liability for viruses or anything similar in this email or any attachment.
DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Carter Holt Harvey is not responsible for any changes made to this message and / or any attachments after sending by Carter Holt Harvey. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
Try the Clear Status File .. this should work.
"Li, Xiong (Corporate Manukau)" on 08/14/2001 09:05:09 PM
Please respond to datastage-users@oliver.com
To: "datastage-users@oliver.com"
cc: (bcc: Lisa Hamilton/COL/OH/NCS_HealthCare)
Subject: How to stop datastage job running
Hi, All
I have a job which call unix script to extract data from csv file being in Unix. For some reason, this job kept running serval hours last night, but did nothing. This morning, I tried to stop it by command dsjob -stop ..., its status was still "RUNNING", Then I went to Cleanup Resources, logout process, back to Unix, I found it was still running. Now, even I have killed its process against unix. I still couldnt compile this job. Anybody have experienced this problem, could you please give me some idea?
Thanks in advance
Xiong
DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Carter Holt Harvey is not responsible for any changes made to this message and / or any attachments after sending by Carter Holt Harvey. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
"Li, Xiong (Corporate Manukau)" on 08/14/2001 09:05:09 PM
Please respond to datastage-users@oliver.com
To: "datastage-users@oliver.com"
cc: (bcc: Lisa Hamilton/COL/OH/NCS_HealthCare)
Subject: How to stop datastage job running
Hi, All
I have a job which call unix script to extract data from csv file being in Unix. For some reason, this job kept running serval hours last night, but did nothing. This morning, I tried to stop it by command dsjob -stop ..., its status was still "RUNNING", Then I went to Cleanup Resources, logout process, back to Unix, I found it was still running. Now, even I have killed its process against unix. I still couldnt compile this job. Anybody have experienced this problem, could you please give me some idea?
Thanks in advance
Xiong
DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Carter Holt Harvey is not responsible for any changes made to this message and / or any attachments after sending by Carter Holt Harvey. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
Apart from killing the main process you will also have to look for Phantom processes.
ps -ef|grep -i phantom
Also, check netstat -a|grep uv and look for CLOSE_WAIT processes. Killing the phantom processes should clear any close_waits.
.. You can also clear the &PH& directory (found under the project directory). Ensure that there arent any jobs running when you do this.
Naren
-----Original Message-----
From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
Sent: Tuesday, August 14, 2001 8:53 PM
To: datastage-users@oliver.com
Subject: RE: How to stop datastage job running
Thanks, Ray. I know "RUNNING" is not the actual status, the issue is I couldnt compile this job even I am surely it had stopped just now. Now, its status has automatically changed to be "Compiled", but I cant compile it, because of "Cannot get exclusive access to executable file for job......", the Show Error prompt me the message "(40908) A request for object with a NULL ID was made",
So, how should I do next?
> -----Original Message-----
> From: Ray Wurlod [SMTP:ray.wurlod@Informix.Com]
> Sent: Wednesday, 15 August 2001 13:20
> To: datastage-users@oliver.com
> Subject: RE: How to stop datastage job running
>
> The job status is not the actual status, but the status the last
time the
> status was recorded. This is a value in the RT_STATUS table for
the
> particular job in the DataStage repository. So the job may
actually be
> finished or stopped (possibly abnormally), but didnt get the
chance to
> update its status information.
> This is one case where you would check the processes that
are/were
> involved
> in the job run then, having ascertained that theyre no longer
there,
> either
> adjust the job status in the table or clear the status file (from
> Director).
>
> -----Original Message-----
> From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
> Sent: Wednesday, 15 August 2001 09:05
> To: datastage-users@oliver.com
> Subject: How to stop datastage job running
>
>
> Hi, All
>
> I have a job which call unix script to extract data from csv file
being in
> Unix.
> For some reason, this job kept running serval hours last night,
but did
> nothing. This morning, I tried to stop it by command dsjob -stop
..., its
> status was still "RUNNING",
> Then I went to Cleanup Resources, logout process, back to Unix,
I found
> it
> was still running.
> Now, even I have killed its process against unix. I still
couldnt compile
> this job.
> Anybody have experienced this problem, could you please give me
some idea?
>
> Thanks in advance
>
> Xiong
>
>
> DISCLAIMER: This electronic message together with any
attachments is
> confidential. If you are not the intended recipient, do not
copy,
> disclose
> or
> use the contents in any way. Please also advise us by return
e-mail that
> you
> have received the message and then please destroy. Carter Holt
Harvey is
> not
> responsible for any changes made to this message and / or any
attachments
> after
> sending by Carter Holt Harvey. We use virus scanning software
but exclude
> all
> liability for viruses or anything similar in this email or any
attachment.
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.
ps -ef|grep -i phantom
Also, check netstat -a|grep uv and look for CLOSE_WAIT processes. Killing the phantom processes should clear any close_waits.
.. You can also clear the &PH& directory (found under the project directory). Ensure that there arent any jobs running when you do this.
Naren
-----Original Message-----
From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
Sent: Tuesday, August 14, 2001 8:53 PM
To: datastage-users@oliver.com
Subject: RE: How to stop datastage job running
Thanks, Ray. I know "RUNNING" is not the actual status, the issue is I couldnt compile this job even I am surely it had stopped just now. Now, its status has automatically changed to be "Compiled", but I cant compile it, because of "Cannot get exclusive access to executable file for job......", the Show Error prompt me the message "(40908) A request for object with a NULL ID was made",
So, how should I do next?
> -----Original Message-----
> From: Ray Wurlod [SMTP:ray.wurlod@Informix.Com]
> Sent: Wednesday, 15 August 2001 13:20
> To: datastage-users@oliver.com
> Subject: RE: How to stop datastage job running
>
> The job status is not the actual status, but the status the last
time the
> status was recorded. This is a value in the RT_STATUS table for
the
> particular job in the DataStage repository. So the job may
actually be
> finished or stopped (possibly abnormally), but didnt get the
chance to
> update its status information.
> This is one case where you would check the processes that
are/were
> involved
> in the job run then, having ascertained that theyre no longer
there,
> either
> adjust the job status in the table or clear the status file (from
> Director).
>
> -----Original Message-----
> From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz]
> Sent: Wednesday, 15 August 2001 09:05
> To: datastage-users@oliver.com
> Subject: How to stop datastage job running
>
>
> Hi, All
>
> I have a job which call unix script to extract data from csv file
being in
> Unix.
> For some reason, this job kept running serval hours last night,
but did
> nothing. This morning, I tried to stop it by command dsjob -stop
..., its
> status was still "RUNNING",
> Then I went to Cleanup Resources, logout process, back to Unix,
I found
> it
> was still running.
> Now, even I have killed its process against unix. I still
couldnt compile
> this job.
> Anybody have experienced this problem, could you please give me
some idea?
>
> Thanks in advance
>
> Xiong
>
>
> DISCLAIMER: This electronic message together with any
attachments is
> confidential. If you are not the intended recipient, do not
copy,
> disclose
> or
> use the contents in any way. Please also advise us by return
e-mail that
> you
> have received the message and then please destroy. Carter Holt
Harvey is
> not
> responsible for any changes made to this message and / or any
attachments
> after
> sending by Carter Holt Harvey. We use virus scanning software
but exclude
> all
> liability for viruses or anything similar in this email or any
attachment.
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.