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
 
Need to know why program took longer than usual -

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
saurabh39
Warnings : 1

Active User


Joined: 11 Apr 2008
Posts: 144
Location: Jamshedpur

PostPosted: Mon Sep 27, 2010 2:25 pm    Post subject: Need to know why program took longer than usual -
Reply with quote

Hi,

I have recieved a weird request. On friday, one of the program which runs for 2 hrs..took more than usual to run.

Client wants me to find the reason for the same.

Moreover, since it was taking time, they cancelled the job. And the record at the time of cancellation was put on bypass file. And somehow after that, the job run fine. They suspect, the record in bypass file as culprit.

But when, program was run with same record in test, the record was processed fine. There was nothing unusal about the data.

Now, I need some pointers as to how to start. But before that i need to find out, whether I can do something about the request.

So please tell me how to go about it?
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


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

PostPosted: Mon Sep 27, 2010 4:34 pm    Post subject:
Reply with quote

Contact your site support group and ask for their assistance. The elapsed time a job takes can vary depending upon time of day run, other jobs in the system, the service classes of each job in the system, the WLM (Workload Manager) rules used by the system, the number of initiators assigned, and on and on ... there are many, many, many possible reasons. Only someone working at your site can analyze the available data and determine which reason(s) applied to your particular job.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2442
Location: Netherlands, Amstelveen

PostPosted: Mon Sep 27, 2010 5:41 pm    Post subject:
Reply with quote

It is of course a manual tape mount or an operator reply not answered.
Its a known fact that operators are the weakest link in IT.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 27, 2010 8:32 pm    Post subject:
Reply with quote

Hello,

Quote:
Its a known fact that operators are the weakest link in IT.
It is not a fact - just an opinion. . .

Many "operations" problems are caused by imcompetently/improperly implemented processes or documentation. Many are also caused by the necessity to manually change the job before each submission (again, part of the process that the operators did not define).

Quote:
But when, program was run with same record in test, the record was processed fine. There was nothing unusal about the data.
If the entire set of production data was not used for the test, the test was incomplete. . .

The problem may have been because of a combination of bad code combined with an unexpected combination of data elements causing the code to go into a loop.

How much cpu and i/o does the job usually take? How much cpu and i/o did the problem run take?

As was suggested, you should look for a missed console reply (there should not be console messages from an application unless it regards device allocation).
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Tue Sep 28, 2010 5:08 pm    Post subject:
Reply with quote

You could possibly get help from DBAs at your site to investigate if the row you have tried to access could have been subject to a lock issued by another process. That would explain that the row processed fine in test.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Sep 28, 2010 6:22 pm    Post subject:
Reply with quote

Looking at the JESMSGLG of canceled Job might help also.
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Tue Sep 28, 2010 6:47 pm    Post subject:
Reply with quote

PeterHolland wrote:
It is of course a manual tape mount or an operator reply not answered.
Its a known fact that operators are the weakest link in IT.

Many shops has eliminated these operator tasks completely, replaced manual tape mounts with tape robots or virtual tape storage and by minimizing/removing operator interaction with application programmes.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Sep 29, 2010 9:06 am    Post subject:
Reply with quote

Tushar,

Assuming this is a DB2 program,

In our place this sometimes happen during the month-end cycle, the daily DB2 batch programs runs few extra hours causing a bit of delay, when analyzed we found DB2 unaccounted Time be being high that was due to high CPU utilization and jobs waiting for CPU cycles.

Hope this helps,
Sushanth
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 How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm

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