DSXchange

Posted: **Mon Dec 17, 2007 11:19 am**

There is a job which is running since last month.
I came to know when I executed this command.

 ps -ef|grep -i osh

But When I look for this job it is not in DataStage.

Code: Select all

 cannot find job jobname

Did a grep on the jobnumber

Code: Select all

 The file *3122 does not exist

do I have to run a DS.CHECKER now?
it seems the job does not exist in the project but the process is still running on unix. any ideas how to remove the hanging process?

Thanks

Posted: **Mon Dec 17, 2007 11:39 am**

The output doesn't make sense. What were the 2 other commands you ran?

The output of the "ps -ef | grep osh" should give pids as well as text references to jobs. How did you get from there to job numbers?

Posted: **Mon Dec 17, 2007 11:43 am**

ArndW wrote:The output doesn't make sense. What were the 2 other commands you ran?

The output of the "ps -ef | grep osh" should give pids as well as text references to jobs. How did you get from there to job numbers?

Yeah it did give me pid and some text along with RT_SC3122.
I got the job number and then tried to find the job but couldnt.
in the project dorectory did

Code: Select all

 ls |grep 3122

couldnt find anything.

Posted: **Mon Dec 17, 2007 11:51 am**

Job number 3122 cannot be found that way. From your admin command line try "LIST DS_JOBS WITH JOBNO EQ 3122" to get the job name that corresponds to that job number.

Posted: **Mon Dec 17, 2007 11:53 am**

Andrw...here is the o/p

Code: Select all

 0 records listed

Posted: **Mon Dec 17, 2007 11:56 am**

Odd, then please attach to your project directory from unix and see if there are any files in there with 3122 in their names. There should be several.

Posted: **Mon Dec 17, 2007 12:02 pm**

ls -lrt *3122

ls: 0653-341 The file *3122* does not exist.

Posted: **Mon Dec 17, 2007 12:12 pm**

Code: Select all

ls -lrt *3122*

and make sure you are in the project directory (ls should show hundreds if not thousands of entries, many with 4 digit numbers in their name).

do you have several projects? If so, that job might be related to another project.

Posted: **Mon Dec 17, 2007 2:09 pm**

It seems suspicious that a deleted job is still running - DataStage ordinarily would not permit deletion of a running job. Are you certain that job #3122 was started from the project in question? Does the process that is the running job hold any locks in the DataStage repository (use the LIST.READU command to find out).

It's too early to contemplate using DS.CHECKER.

Have you tried clearing the status file of the "running" job?

Posted: **Mon Dec 17, 2007 3:19 pm**

the list_readu command does not show any locks associated with this job.
i dont see the job anywhere in the director therefore cant clear the status file.

Posted: **Mon Dec 17, 2007 5:12 pm**

Are you certain that job #3122 was started from the project in question? Could it have been started from a different project?