Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
Jobs Hangs
You are in luck. I believe the Informix basically have the hanging problem cracked.
Questions...
What version of DataStage?
Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel
stages?)
Do you use a multi processor server?
Depending on your answers (ie is it the usual hanging problem that others have experienced), the solution may be a patch to 4.01 the soon to be released 4.02.
-----Original Message-----
From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 16:50
To: informix-datastage@oliver.com
Subject: Jobs Hangs
Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
Questions...
What version of DataStage?
Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel
stages?)
Do you use a multi processor server?
Depending on your answers (ie is it the usual hanging problem that others have experienced), the solution may be a patch to 4.01 the soon to be released 4.02.
-----Original Message-----
From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 16:50
To: informix-datastage@oliver.com
Subject: Jobs Hangs
Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
Hi David
1. We are using DataStage 3.6.
2. Yes multiple jobs run in parallel
3. No we are not using a multi processor server
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History ----------------------------------------
From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
You are in luck. I believe the Informix basically have the hanging problem cracked.
Questions...
What version of DataStage?
Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel
stages?)
Do you use a multi processor server?
Depending on your answers (ie is it the usual hanging problem that others have experienced), the solution may be a patch to 4.01 the soon to be released 4.02.
-----Original Message-----
From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 16:50
To: informix-datastage@oliver.com
Subject: Jobs Hangs
Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
1. We are using DataStage 3.6.
2. Yes multiple jobs run in parallel
3. No we are not using a multi processor server
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History ----------------------------------------
From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
You are in luck. I believe the Informix basically have the hanging problem cracked.
Questions...
What version of DataStage?
Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel
stages?)
Do you use a multi processor server?
Depending on your answers (ie is it the usual hanging problem that others have experienced), the solution may be a patch to 4.01 the soon to be released 4.02.
-----Original Message-----
From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 16:50
To: informix-datastage@oliver.com
Subject: Jobs Hangs
Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
When a job hangs, does a monitor show one or more stages with a status of "Starting"?
If so, probably you are going to need the patch I was referring to. Definitely time to log it with Informix (hopefully you have done this already - I have found their DataStage support very good, at least in Australia, anyway). However, I believe it is fairly difficult (but not
impossible) to get this error on a single CPU server unless you deliberately design a job to do it. Is it a very fast single CPU?
-----Original Message-----
From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 17:18
To: informix-datastage@oliver.com
Subject: RE: Jobs Hangs
Hi David
1. We are using DataStage 3.6.
2. Yes multiple jobs run in parallel
3. No we are not using a multi processor server
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History
----------------------------------------
From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
You are in luck. I believe the Informix basically have the hanging problem
cracked.
Questions...
What version of DataStage?
Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel
stages?)
Do you use a multi processor server?
Depending on your answers (ie is it the usual hanging problem that others
have experienced), the solution may be a patch to 4.01 the soon to be
released 4.02.
-----Original Message-----
From: avinash.tadwalkar@db.com
[SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 16:50
To: informix-datastage@oliver.com
Subject: Jobs Hangs
Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
*************************************************************************
This e-mail and any files transmitted with it may be confidential
and are intended solely for the use of the individual or entity to
whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this
e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
If so, probably you are going to need the patch I was referring to. Definitely time to log it with Informix (hopefully you have done this already - I have found their DataStage support very good, at least in Australia, anyway). However, I believe it is fairly difficult (but not
impossible) to get this error on a single CPU server unless you deliberately design a job to do it. Is it a very fast single CPU?
-----Original Message-----
From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 17:18
To: informix-datastage@oliver.com
Subject: RE: Jobs Hangs
Hi David
1. We are using DataStage 3.6.
2. Yes multiple jobs run in parallel
3. No we are not using a multi processor server
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History
----------------------------------------
From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
You are in luck. I believe the Informix basically have the hanging problem
cracked.
Questions...
What version of DataStage?
Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel
stages?)
Do you use a multi processor server?
Depending on your answers (ie is it the usual hanging problem that others
have experienced), the solution may be a patch to 4.01 the soon to be
released 4.02.
-----Original Message-----
From: avinash.tadwalkar@db.com
[SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 16:50
To: informix-datastage@oliver.com
Subject: Jobs Hangs
Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
*************************************************************************
This e-mail and any files transmitted with it may be confidential
and are intended solely for the use of the individual or entity to
whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this
e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
Hi David,
When job hangs monitor shows the states of running and doing nothing means shows same figure of num of rows. We tried with support Australia, but havent got anything fullproof solution.
Server is :
HA config. two processor server
cpu speed 332Mgh
0.5 GB Ram
Having AIX 4.3.2
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History ----------------------------------------
From: David.Barham@anglocoal.com.au on 18/08/2000 07:27 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
When a job hangs, does a monitor show one or more stages with a status of "Starting"?
If so, probably you are going to need the patch I was referring to. Definitely time to log it with Informix (hopefully you have done this already - I have found their DataStage support very good, at least in Australia, anyway). However, I believe it is fairly difficult (but not
impossible) to get this error on a single CPU server unless you deliberately design a job to do it. Is it a very fast single CPU?
-----Original Message-----
From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 17:18
To: informix-datastage@oliver.com
Subject: RE: Jobs Hangs
Hi David
1. We are using DataStage 3.6.
2. Yes multiple jobs run in parallel
3. No we are not using a multi processor server
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History
----------------------------------------
From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
You are in luck. I believe the Informix basically have the hanging problem
cracked.
Questions...
What version of DataStage?
Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel
stages?)
Do you use a multi processor server?
Depending on your answers (ie is it the usual hanging problem that others
have experienced), the solution may be a patch to 4.01 the soon to be
released 4.02.
-----Original Message-----
From: avinash.tadwalkar@db.com
[SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 16:50
To: informix-datastage@oliver.com
Subject: Jobs Hangs
Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
*************************************************************************
This e-mail and any files transmitted with it may be confidential
and are intended solely for the use of the individual or entity to
whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this
e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
When job hangs monitor shows the states of running and doing nothing means shows same figure of num of rows. We tried with support Australia, but havent got anything fullproof solution.
Server is :
HA config. two processor server
cpu speed 332Mgh
0.5 GB Ram
Having AIX 4.3.2
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History ----------------------------------------
From: David.Barham@anglocoal.com.au on 18/08/2000 07:27 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
When a job hangs, does a monitor show one or more stages with a status of "Starting"?
If so, probably you are going to need the patch I was referring to. Definitely time to log it with Informix (hopefully you have done this already - I have found their DataStage support very good, at least in Australia, anyway). However, I believe it is fairly difficult (but not
impossible) to get this error on a single CPU server unless you deliberately design a job to do it. Is it a very fast single CPU?
-----Original Message-----
From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 17:18
To: informix-datastage@oliver.com
Subject: RE: Jobs Hangs
Hi David
1. We are using DataStage 3.6.
2. Yes multiple jobs run in parallel
3. No we are not using a multi processor server
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History
----------------------------------------
From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
You are in luck. I believe the Informix basically have the hanging problem
cracked.
Questions...
What version of DataStage?
Do you run multiple jobs in parallel? (Or have jobs with a lot of parallel
stages?)
Do you use a multi processor server?
Depending on your answers (ie is it the usual hanging problem that others
have experienced), the solution may be a patch to 4.01 the soon to be
released 4.02.
-----Original Message-----
From: avinash.tadwalkar@db.com
[SMTP:avinash.tadwalkar@db.com]
Sent: Friday, 18 August 2000 16:50
To: informix-datastage@oliver.com
Subject: Jobs Hangs
Hi,
We have around 1000 jobs running in production,
We are facing the problem of jobs hanging.
Some jobs hangs and there after all our process stops.
Is there anyone who knows solution for this.
Regards
Avinash
*************************************************************************
This e-mail and any files transmitted with it may be confidential
and are intended solely for the use of the individual or entity to
whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this
e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
Alternately, does the Monitor show all stages with a status of Finished, yet the status view show the job status as Running? This is a symptom of a different problem, yet one that you might perceive as a "job hang". Alas, the original note is not very informative about what is meant by "hung" - for example are any of the processes involved consuming CPU (see Windows NT Task Manager - Processes tab if youre on WinNT).
Thanks, David, for your imprimatur for our support organization. Australia provides DataStage support for the whole of the Asia-Pacific region. Curiously, perhaps, there have been no calls logged by DB Singapore in the past three months.
> ----------
> From: David Barham[SMTP:David.Barham@anglocoal.com.au]
> Reply To: informix-datastage@oliver.com
> Sent: Friday, 18 August 2000 17:27
> To: informix-datastage@oliver.com
> Subject: RE: Jobs Hangs
>
> When a job hangs, does a monitor show one or more stages with a status
> of "Starting"?
>
> If so, probably you are going to need the patch I was referring to.
> Definitely time to log it with Informix (hopefully you have done this
> already - I have found their DataStage support very good, at least in
> Australia, anyway). However, I believe it is fairly difficult (but
> not
> impossible) to get this error on a single CPU server unless you
> deliberately
> design a job to do it. Is it a very fast single CPU?
>
> -----Original Message-----
> From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
> Sent: Friday, 18 August 2000 17:18
> To: informix-datastage@oliver.com
> Subject: RE: Jobs Hangs
>
> Hi David
>
> 1. We are using DataStage 3.6.
> 2. Yes multiple jobs run in parallel
> 3. No we are not using a multi processor server
>
>
> Thanks & Regards
> Avinash Tadwalkar
>
>
> ---------------------------------------- Message History
> ----------------------------------------
>
>
> From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
>
> Please respond to informix-datastage@oliver.com
>
> To: informix-datastage@oliver.com
> cc:
> Subject: RE: Jobs Hangs
>
>
>
> You are in luck. I believe the Informix basically have the hanging
> problem
> cracked.
>
> Questions...
> What version of DataStage?
> Do you run multiple jobs in parallel? (Or have jobs with a lot of
> parallel
> stages?)
> Do you use a multi processor server?
>
> Depending on your answers (ie is it the usual hanging problem that
> others
> have experienced), the solution may be a patch to 4.01 the soon to be
> released 4.02.
>
> -----Original Message-----
> From: avinash.tadwalkar@db.com
> [SMTP:avinash.tadwalkar@db.com]
> Sent: Friday, 18 August 2000 16:50
> To: informix-datastage@oliver.com
> Subject: Jobs Hangs
>
> Hi,
>
> We have around 1000 jobs running in production,
> We are facing the problem of jobs hanging.
> Some jobs hangs and there after all our process stops.
>
> Is there anyone who knows solution for this.
>
> Regards
> Avinash
>
>
>
>
> *************************************************************************
> This e-mail and any files transmitted with it may be confidential
> and are intended solely for the use of the individual or entity to
> whom they are addressed. If you have received this e-mail in
> error, please notify the sender by return e-mail, and delete this
> e-mail from your in-box. Do not copy it to anybody else
>
>
> **********************************************************************
> ***
>
>
>
>
Thanks, David, for your imprimatur for our support organization. Australia provides DataStage support for the whole of the Asia-Pacific region. Curiously, perhaps, there have been no calls logged by DB Singapore in the past three months.
> ----------
> From: David Barham[SMTP:David.Barham@anglocoal.com.au]
> Reply To: informix-datastage@oliver.com
> Sent: Friday, 18 August 2000 17:27
> To: informix-datastage@oliver.com
> Subject: RE: Jobs Hangs
>
> When a job hangs, does a monitor show one or more stages with a status
> of "Starting"?
>
> If so, probably you are going to need the patch I was referring to.
> Definitely time to log it with Informix (hopefully you have done this
> already - I have found their DataStage support very good, at least in
> Australia, anyway). However, I believe it is fairly difficult (but
> not
> impossible) to get this error on a single CPU server unless you
> deliberately
> design a job to do it. Is it a very fast single CPU?
>
> -----Original Message-----
> From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
> Sent: Friday, 18 August 2000 17:18
> To: informix-datastage@oliver.com
> Subject: RE: Jobs Hangs
>
> Hi David
>
> 1. We are using DataStage 3.6.
> 2. Yes multiple jobs run in parallel
> 3. No we are not using a multi processor server
>
>
> Thanks & Regards
> Avinash Tadwalkar
>
>
> ---------------------------------------- Message History
> ----------------------------------------
>
>
> From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
>
> Please respond to informix-datastage@oliver.com
>
> To: informix-datastage@oliver.com
> cc:
> Subject: RE: Jobs Hangs
>
>
>
> You are in luck. I believe the Informix basically have the hanging
> problem
> cracked.
>
> Questions...
> What version of DataStage?
> Do you run multiple jobs in parallel? (Or have jobs with a lot of
> parallel
> stages?)
> Do you use a multi processor server?
>
> Depending on your answers (ie is it the usual hanging problem that
> others
> have experienced), the solution may be a patch to 4.01 the soon to be
> released 4.02.
>
> -----Original Message-----
> From: avinash.tadwalkar@db.com
> [SMTP:avinash.tadwalkar@db.com]
> Sent: Friday, 18 August 2000 16:50
> To: informix-datastage@oliver.com
> Subject: Jobs Hangs
>
> Hi,
>
> We have around 1000 jobs running in production,
> We are facing the problem of jobs hanging.
> Some jobs hangs and there after all our process stops.
>
> Is there anyone who knows solution for this.
>
> Regards
> Avinash
>
>
>
>
> *************************************************************************
> This e-mail and any files transmitted with it may be confidential
> and are intended solely for the use of the individual or entity to
> whom they are addressed. If you have received this e-mail in
> error, please notify the sender by return e-mail, and delete this
> e-mail from your in-box. Do not copy it to anybody else
>
>
> **********************************************************************
> ***
>
>
>
>
Hi Ray,
Sorry to say, but we contacted Datastage Australia,
The representative Jonathan Evans attended on phone and on mails. He send some patch but it doesnt work at all.
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History ----------------------------------------
From: ray.wurlod@informix.com on 18/08/2000 07:53 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
Alternately, does the Monitor show all stages with a status of Finished, yet the status view show the job status as Running? This is a symptom of a different problem, yet one that you might perceive as a "job hang". Alas, the original note is not very informative about what is meant by "hung" - for example are any of the processes involved consuming CPU (see Windows NT Task Manager - Processes tab if youre on WinNT).
Thanks, David, for your imprimatur for our support organization. Australia provides DataStage support for the whole of the Asia-Pacific region. Curiously, perhaps, there have been no calls logged by DB Singapore in the past three months.
> ----------
> From: David Barham[SMTP:David.Barham@anglocoal.com.au]
> Reply To: informix-datastage@oliver.com
> Sent: Friday, 18 August 2000 17:27
> To: informix-datastage@oliver.com
> Subject: RE: Jobs Hangs
>
> When a job hangs, does a monitor show one or more stages with a status
> of "Starting"?
>
> If so, probably you are going to need the patch I was referring to.
> Definitely time to log it with Informix (hopefully you have done this
> already - I have found their DataStage support very good, at least in
> Australia, anyway). However, I believe it is fairly difficult (but
> not
> impossible) to get this error on a single CPU server unless you
> deliberately
> design a job to do it. Is it a very fast single CPU?
>
> -----Original Message-----
> From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
> Sent: Friday, 18 August 2000 17:18
> To: informix-datastage@oliver.com
> Subject: RE: Jobs Hangs
>
> Hi David
>
> 1. We are using DataStage 3.6.
> 2. Yes multiple jobs run in parallel
> 3. No we are not using a multi processor server
>
>
> Thanks & Regards
> Avinash Tadwalkar
>
>
> ---------------------------------------- Message History
> ----------------------------------------
>
>
> From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
>
> Please respond to informix-datastage@oliver.com
>
> To: informix-datastage@oliver.com
> cc:
> Subject: RE: Jobs Hangs
>
>
>
> You are in luck. I believe the Informix basically have the hanging
> problem
> cracked.
>
> Questions...
> What version of DataStage?
> Do you run multiple jobs in parallel? (Or have jobs with a lot of
> parallel
> stages?)
> Do you use a multi processor server?
>
> Depending on your answers (ie is it the usual hanging problem that
> others
> have experienced), the solution may be a patch to 4.01 the soon to
> be
> released 4.02.
>
> -----Original Message-----
> From: avinash.tadwalkar@db.com
> [SMTP:avinash.tadwalkar@db.com]
> Sent: Friday, 18 August 2000 16:50
> To: informix-datastage@oliver.com
> Subject: Jobs Hangs
>
> Hi,
>
> We have around 1000 jobs running in production,
> We are facing the problem of jobs hanging.
> Some jobs hangs and there after all our process stops.
>
> Is there anyone who knows solution for this.
>
> Regards
> Avinash
>
>
>
>
> *************************************************************************
> This e-mail and any files transmitted with it may be confidential
> and are intended solely for the use of the individual or entity to
> whom they are addressed. If you have received this e-mail in
> error, please notify the sender by return e-mail, and delete this
> e-mail from your in-box. Do not copy it to anybody else
>
>
> **********************************************************************
> ***
>
>
>
>
Sorry to say, but we contacted Datastage Australia,
The representative Jonathan Evans attended on phone and on mails. He send some patch but it doesnt work at all.
Thanks & Regards
Avinash Tadwalkar
---------------------------------------- Message History ----------------------------------------
From: ray.wurlod@informix.com on 18/08/2000 07:53 GMT
Please respond to informix-datastage@oliver.com
To: informix-datastage@oliver.com
cc:
Subject: RE: Jobs Hangs
Alternately, does the Monitor show all stages with a status of Finished, yet the status view show the job status as Running? This is a symptom of a different problem, yet one that you might perceive as a "job hang". Alas, the original note is not very informative about what is meant by "hung" - for example are any of the processes involved consuming CPU (see Windows NT Task Manager - Processes tab if youre on WinNT).
Thanks, David, for your imprimatur for our support organization. Australia provides DataStage support for the whole of the Asia-Pacific region. Curiously, perhaps, there have been no calls logged by DB Singapore in the past three months.
> ----------
> From: David Barham[SMTP:David.Barham@anglocoal.com.au]
> Reply To: informix-datastage@oliver.com
> Sent: Friday, 18 August 2000 17:27
> To: informix-datastage@oliver.com
> Subject: RE: Jobs Hangs
>
> When a job hangs, does a monitor show one or more stages with a status
> of "Starting"?
>
> If so, probably you are going to need the patch I was referring to.
> Definitely time to log it with Informix (hopefully you have done this
> already - I have found their DataStage support very good, at least in
> Australia, anyway). However, I believe it is fairly difficult (but
> not
> impossible) to get this error on a single CPU server unless you
> deliberately
> design a job to do it. Is it a very fast single CPU?
>
> -----Original Message-----
> From: avinash.tadwalkar@db.com [SMTP:avinash.tadwalkar@db.com]
> Sent: Friday, 18 August 2000 17:18
> To: informix-datastage@oliver.com
> Subject: RE: Jobs Hangs
>
> Hi David
>
> 1. We are using DataStage 3.6.
> 2. Yes multiple jobs run in parallel
> 3. No we are not using a multi processor server
>
>
> Thanks & Regards
> Avinash Tadwalkar
>
>
> ---------------------------------------- Message History
> ----------------------------------------
>
>
> From: David.Barham@anglocoal.com.au on 18/08/2000 07:11 GMT
>
> Please respond to informix-datastage@oliver.com
>
> To: informix-datastage@oliver.com
> cc:
> Subject: RE: Jobs Hangs
>
>
>
> You are in luck. I believe the Informix basically have the hanging
> problem
> cracked.
>
> Questions...
> What version of DataStage?
> Do you run multiple jobs in parallel? (Or have jobs with a lot of
> parallel
> stages?)
> Do you use a multi processor server?
>
> Depending on your answers (ie is it the usual hanging problem that
> others
> have experienced), the solution may be a patch to 4.01 the soon to
> be
> released 4.02.
>
> -----Original Message-----
> From: avinash.tadwalkar@db.com
> [SMTP:avinash.tadwalkar@db.com]
> Sent: Friday, 18 August 2000 16:50
> To: informix-datastage@oliver.com
> Subject: Jobs Hangs
>
> Hi,
>
> We have around 1000 jobs running in production,
> We are facing the problem of jobs hanging.
> Some jobs hangs and there after all our process stops.
>
> Is there anyone who knows solution for this.
>
> Regards
> Avinash
>
>
>
>
> *************************************************************************
> This e-mail and any files transmitted with it may be confidential
> and are intended solely for the use of the individual or entity to
> whom they are addressed. If you have received this e-mail in
> error, please notify the sender by return e-mail, and delete this
> e-mail from your in-box. Do not copy it to anybody else
>
>
> **********************************************************************
> ***
>
>
>
>