Job is running with no response!!!

Vignesh Sid · New User Joined: 04 Sep 2017 Posts: 43 Location: India

Hi all,

My DB2 module is running for more than half an hour without any response. I get the following in sysout but the job is still running.

0200-MAIN-PROCESS
9810-GET-CURRENT-TIMESTAMP
SQLCODE
0000000000
WS-CURRENT-TIMESTAMP 2017-10-27-08.52.21.879405

This DB2 module actually writes some 301K records to a PS file.

Could anyone suggest me how to know whether the job will complete or to know the progress?

Thanks,
Viky.

Robert Sample · Posted: Fri Oct 27, 2017 6:33 pm

You do NOT tell us:
- what the program is doing
- how many rows the program will manipulate
- how long you THINK it should run
- WHY you think it will run that long

The program may write 301,000 records to output but if it has to read 100 million rows to extract those 301,000 records then yes the job will take quite some time.

In other words, you are providing us no information and expecting us to guess. My guess is the job will time out (eventually) and you may discover you have an infinite loop in your code -- or the job is retrieving 100 million rows and runs out of disk space / cpu time -- or something else is going on. For production jobs, it is not at all unusual for a job to run for 30 minutes without producing any output.

If you want to see the progress, you should write something every so many records / rows so you have output to monitor.

Robert Sample · Posted: Fri Oct 27, 2017 6:49 pm

Also, why are you posting here instead of talking to your site support group? They know your site and could tell you if a monitoring tool like Omegamon or Mainview is installed at your site; if so, they may be able to help pinpoint what is going on. For questions like this, you should ALWAYS start with your site support group!

Rohit Umarjikar · Posted: Mon Oct 30, 2017 4:34 pm

Get the sql stats from your DBA For this job, and then you shall be able to figure it out why is it running for so long.