IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Job is running with no response!!!


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Vignesh Sid

New User


Joined: 04 Sep 2017
Posts: 43
Location: India

PostPosted: Fri Oct 27, 2017 6:28 pm
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: 8569
Location: Dubuque, Iowa, USA

PostPosted: Fri Oct 27, 2017 6:33 pm
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: 8569
Location: Dubuque, Iowa, USA

PostPosted: Fri Oct 27, 2017 6:49 pm
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

Global Moderator


Joined: 21 Sep 2010
Posts: 2573
Location: NYC,USA

PostPosted: Mon Oct 30, 2017 4:34 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts APCT Abend while running an online CI... CICS 1
No new posts Running rexx on zOS with JCL CLIST & REXX 3
No new posts Running a REXX exec program using ZOSMF CLIST & REXX 3
No new posts S0C7 abend while running a Cobol Program COBOL Programming 2
No new posts Reading mainframe job spool while the... JCL & VSAM 7
Search our Forums:

Back to Top