View previous topic :: View next topic
|
Author |
Message |
grem
New User
Joined: 06 May 2009 Posts: 14 Location: philippines
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
grem
New User
Joined: 06 May 2009 Posts: 14 Location: philippines
|
|
|
|
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 |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
Only the job G586476 is having the problem or every other job that is using the database is taking more time. |
|
Back to top |
|
|
grem
New User
Joined: 06 May 2009 Posts: 14 Location: philippines
|
|
|
|
all our jobs are using the same database but only Job G586476 having a problem. |
|
Back to top |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 Location: banglore
|
|
|
|
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 |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
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 |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
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 |
|
|
grem
New User
Joined: 06 May 2009 Posts: 14 Location: philippines
|
|
|
|
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 |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 Location: banglore
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|