How to check if the job is still running

kirankota79 · Post by **kirankota79** » Thu Jun 26, 2008 6:43 am

Hi Everyone.....I had a job running since 2 days and i don't know if it is really running or is it just showing like that! Can some please tell me how can i check it from datastage side or from database side!

Thanks

ArndW · Post by **ArndW** » Thu Jun 26, 2008 7:06 am

Various methods - try talking to your DBA regarding what is happening on the database side. I think that "truss" is installed as part of the MKS toolkit, so you should be able to use that on your process to see which system calls are being executed, if any.

keshav0307 · Post by **keshav0307** » Thu Jun 26, 2008 6:06 pm

check the job status using the dsjob command.

also check if there is any process running for this job on any compute node

ray.wurlod · Post by **ray.wurlod** » Thu Jun 26, 2008 6:48 pm

Use Monitor to determine what the status of each stage is. Also, is the row count continuing to increase? (Yes would indicate that the job is still running.)