Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Program executes very very slowly in production

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

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Thu Oct 08, 2009 6:02 pm    Post subject: Program executes very very slowly in production
Reply with quote

Hi,

We implemented a COBOL DB2 program in production and notice that it takes very long time to execute, however same program executes (with same amount of data) within minutes in Test region.

Please note that we have executed RUNSTATS and REORG utilities on all the DB2 tables in the program.

Please suggest what could be the possible reasons for this.

Thanks & regards
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Oct 08, 2009 6:16 pm    Post subject: Reply to: Program executes very very slowly in production
Reply with quote

duh, like what else is running in production (at the same time) as this new job.
in other words, what else is going on in the box?

same kind of problem when one tests a car on a race track and it goes 200 mph.

but, (gee, i have no idea why) one can not travel at 200 mph on normal highways.
Back to top
View user's profile Send private message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Thu Oct 08, 2009 6:24 pm    Post subject:
Reply with quote

Thanks for the reply,

Actually I thought of such scenarios and executed the program at different times in the production and got the same result.

I am wondering what could be the other possible reasons apart from the heavy traffic?

Thanks

Nitin
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Thu Oct 08, 2009 6:26 pm    Post subject:
Reply with quote

Comparing explains might show a difference.
but probably dbz is right
-cpu contention
-locking
-bufferpools
-kind of disks
-wlm environments
...

All kind of differences besides "same amount of data" can cause this.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Thu Oct 08, 2009 7:44 pm    Post subject:
Reply with quote

If you have a monitoring tool such as STROBE, that can help find the reason(s).
Back to top
View user's profile Send private message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Thu Oct 08, 2009 8:17 pm    Post subject:
Reply with quote

No, we do not have STROBE in our shop, also I executed each query using QMF in production and all of them appears to be executing pretty fast.

Also it can not be CPU contention as my program got around 720 CPU minutes after which it was cancelled.

Any thoughts??????
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Thu Oct 08, 2009 8:25 pm    Post subject:
Reply with quote

720 CPU minutes ???

Did you compare output of explain?

Running a query in QMF is no measurement for accesspath selection.
because in your program you probably have hostvariables and in qmf you have literals.
Back to top
View user's profile Send private message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Thu Oct 08, 2009 8:41 pm    Post subject:
Reply with quote

Thanks for the tip, I'll compare the EXPLAIN
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 SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us