Unable to Run Datastage Jobs

balajee · Post by **balajee** » Wed Jul 15, 2009 9:20 am

Hi All,

We are using Datastage version 7.5.1

Every day the server jobs are scheduled and run in the morning time. Our project is running from the last 1.5 Year or so and jobs run 5 days a week through out the year.
We are facing a strange problem today. None of the jobs are running automatically. Even if we try to run them manually, they are not running.

When we try to compile/reset the Job following is the error message we are getting:

'Job control process (pid 5255) has failed'.

Nothing has changed related to user credentials or anything from yesterday to today. But the jobs are running.
Any early help with any information is greatly appreciated.

Thanks
Balajee

ArndW · Post by **ArndW** » Wed Jul 15, 2009 9:26 am

When you reset the job from the director, do you get a log entry "from previous run..."? If so, what does it contain? From UNIX, see how many processes with the userid you use to run your jobs are actually running ("ps -ef | grep {userid} | wc -l")

balajee · Post by **balajee** » Wed Jul 15, 2009 9:51 am

When i reset the job from the director i am not getting any entries in the log which indicates that the job is not getting reset.
But when i compile the job from Designer, its getting reflected in director on that job that its compiled successfully.

I can see all the jobs previous log information. i mean the log information previous 5 days run.

From UNIX i see that the Datastage server is running.
But i dont see any processes running.

Can anyone help me know, how to run jobs from UNIX?
i want to try this once.

ArndW · Post by **ArndW** » Wed Jul 15, 2009 9:58 am

That problem sounds familiar, I know I have had that once but cannot recall what caused it. You could try "dsjob -mode NORMAL -run Myproject MyJob" from the command line. If possible, do a restart of datastage. I think that is what I did when I had this problem.

balajee · Post by **balajee** » Wed Jul 15, 2009 10:48 am

We restarted our Datastage server several times with no success.
we contacted UNIX SA too for cheking the UNIX server. They verified the UNIX environment and the Cron entries and everything and reported that nothing has changed and UNIX server and is in good shape.

Also we cannot restart UNIX server because there are so many applications residing on it.

Thank you a lot for all the replies, if you can provide any information it will be of great to us.

Thanks once again
Balajee

ArndW · Post by **ArndW** » Thu Jul 16, 2009 2:40 am

Can you start jobs from the command line? Can you reset jobs from the director and does a (force) compile work? Do server jobs run?

balajee · Post by **balajee** » Thu Jul 16, 2009 9:09 am

The issue is resolved now.
We are still not sure what the root cause is.

Our UNIX SA has identified that a core dump file has formed in UNIX.
We have overwritten the UNIX environment with our latest backup. After doing this the problem is resolved.

We are still not sure what could be the cause for core dump file. We logged a ticket with SUN to help us in understanding this file.

Just to answer your questions, we did tried running jobs from command prompt, but they again ended up in error. I already mentioned that reset is not working too. All of our jobs are server jobs and they have the same problem. None of the jobs were running.
Regarding compilation, we were able to compile the jobs and we didnt faced much problem in compilation.

Thanks
Balajee