Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Job is running with no response!!!

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Vignesh Sid

New User


Joined: 04 Sep 2017
Posts: 22
Location: India

PostPosted: Fri Oct 27, 2017 6:28 pm    Post subject: Job is running with no response!!!
Reply with quote

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.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8187
Location: East Dubuque, Illinois, USA

PostPosted: Fri Oct 27, 2017 6:33 pm    Post subject: Reply to: Job is running with no response!!!
Reply with quote

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.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8187
Location: East Dubuque, Illinois, USA

PostPosted: Fri Oct 27, 2017 6:49 pm    Post subject:
Reply with quote

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!
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1818
Location: NY,USA

PostPosted: Mon Oct 30, 2017 4:34 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm
No new posts Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us