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
 

 

Slow Performance of the job after upgrade

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

New User


Joined: 06 May 2009
Posts: 14
Location: philippines

PostPosted: Fri Aug 14, 2009 8:44 am    Post subject: Slow Performance of the job
Reply with quote

Hi..

one of my program are connecting on DB2 Unix databse, last july we had upgraded the Database after the upgrade one of my program are encountering slowness in performance. because before the program just executing in 20 to 30 minutes but after the upgrade of our DB2, its executing time is now almost 90 to 100 minutes.

Can someone help me..

July 31
---+----1----+----2----+----3----+----
28 CARDS READ
266 SYSOUT PRINT RECORDS
0 SYSOUT PUNCH RECORDS
1 SYSOUT PAGE RECORDS
18 SYSOUT SPOOL KBYTES
23.35 MINUTES EXECUTION TIME
************ BOTTOM OF PAGE **********

Aug 3
----+----1----+----2----+----3----+----
28 CARDS READ
266 SYSOUT PRINT RECORDS
0 SYSOUT PUNCH RECORDS
1 SYSOUT PAGE RECORDS
18 SYSOUT SPOOL KBYTES
94.03 MINUTES EXECUTION TIME
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: Fri Aug 14, 2009 9:08 am    Post subject:
Reply with quote

Hello and welcome to the forum,

When you have a question, it is best to start a new topic for your question rather than post a reply to some existing topic.

Quote:
connecting on DB2 Unix databse
The statistics appear to be from a mainframe batch job. Please clarify where the job is running, where the database is running, and how the connection is established.

How many code changes were needed because of the upgrade? Does the slowness happen with other code or only this process? What happens if you issue similar database requests from other code?
Back to top
View user's profile Send private message
grem

New User


Joined: 06 May 2009
Posts: 14
Location: philippines

PostPosted: Fri Aug 14, 2009 9:19 am    Post subject:
Reply with quote

hi,

Our Job G586476 is running on DB0P environment means it can run on test and production environment. and that job is connecting on a UNIX DB2 Database.

During the upgrade we didnt change or add code to our job..
Yup the job G586476 only encounters the slowness the other job have still the same time of execution before and after the upgrade.
Back to top
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Fri Aug 14, 2009 10:40 am    Post subject:
Reply with quote

Only the job G586476 is having the problem or every other job that is using the database is taking more time.
Back to top
View user's profile Send private message
grem

New User


Joined: 06 May 2009
Posts: 14
Location: philippines

PostPosted: Fri Aug 14, 2009 11:31 am    Post subject:
Reply with quote

all our jobs are using the same database but only Job G586476 having a problem.
Back to top
View user's profile Send private message
bhairon singh rathore

New User


Joined: 19 Jun 2008
Posts: 91
Location: banglore

PostPosted: Fri Aug 14, 2009 11:50 am    Post subject:
Reply with quote

Why don't you ask your DBA to check which query of this program is taking time....Then you will be in better position to analyse the problem.
Back to top
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Fri Aug 14, 2009 11:53 am    Post subject:
Reply with quote

or is possible go for the strobe analysis for the job and check for the tables that the job is using and check for cluster ratio and other such pram . also check for the frequency of the reorg and runstat jobs for those tables
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1226
Location: Israel

PostPosted: Fri Aug 14, 2009 11:58 am    Post subject:
Reply with quote

Hello and Mabuhay, grem

You will have to investigate a little before you contact your DBA:
- You already said it's the only job affected.
- Can you run queries on the same table(s) to check if it's a DB2 problem?
- Run an EXPLAIN on the program. is it using indexes?
Check with your DBA that all indexes are present and that statistics are up to date.
Back to top
View user's profile Send private message
grem

New User


Joined: 06 May 2009
Posts: 14
Location: philippines

PostPosted: Fri Aug 14, 2009 4:13 pm    Post subject:
Reply with quote

Hi Marso,

i have ran a queries in the same table and it took 1 hr.
hmm..wat do you mean by "- Run an EXPLAIN on the program. is it using indexes? ", because im not so good in mainframe.
i contacted now our DBA to check that check. because i think the issue is not on the program.
Back to top
View user's profile Send private message
bhairon singh rathore

New User


Joined: 19 Jun 2008
Posts: 91
Location: banglore

PostPosted: Fri Aug 14, 2009 5:48 pm    Post subject:
Reply with quote

Hi Grem,

'EXPLAIN' which is basically used to check query path, indexes used while execution,......etc.

Please take help from your company seniors.
or
Please google it....you will find many useful links

Thanks
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: Fri Aug 14, 2009 8:24 pm    Post subject:
Reply with quote

Hello,

Quote:
because i think the issue is not on the program
Can you make a copy of this program and do a new BIND? It may be that with the upgrade, the "old" optimization is no longer working as it did previously. . .

Your dba should be able to provide the needed analysis.
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 CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm


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