DSXchange

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

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.

check the job status using the dsjob command.

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

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.)