Re: Inconsistent performance

I will check that and let you know
many thanks,
Paul
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Steinmetz, Paul via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Sent: Tuesday, April 30, 2019 9:54 PM
To: 'midrange-l@xxxxxxxxxxxxxxxxxx'
Cc: Steinmetz, Paul
Subject: RE: Inconsistent performance

Paul,

There was recent APAR MA47489 , both V7R2 and V7R3 PTFs, for OPNQRYF INTERMITTENTLY PERFORMS POORLY.

R720 MF65697
R730 MF65699

Possibly could resolve your issue.

MA47489 - OSP-OTHER-PERFM OPNQRYF INTERMITTENTLY PERFORMS POORLY

https://www-01.ibm.com/support/docview.wss?uid=nas2MA47489

Paul



-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Paul Roy
Sent: Tuesday, April 30, 2019 9:39 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Inconsistent performance

Hello,

Since a few weeks after installing cumpack 18249 at V7R2, we face inconsistent performance problems...
the same job can take from 3 to 40 minutes in equivalent situation...
the difference from the component report looks in the number of physical I/O... and the CPU.
job A : 580000 logical I/O ... 222500 Sync I/O ... 117500 Async I/O perm write 95654 CPU 766 sec (0,29%) duration 25 minutes
job B : 570500 logical I/0 ... 73000 Sync I/O ... 27000 Async I/O perm write 19051 CPU 8 sec (0,003%) duration 3 minutes

we have 10 jobs started in parallel (each one is handling 1/10 of the db selected on the last digit of the contract number - the selection is made with an OPNQRYF ) so the volume and the process in roughly the same in all jobs. The same process takes 6 CPU sec one day and 600 CPU secs the other day... this was running smoothly before and the duration is now unpredictable.

I do not understand what can cause the difference.
What can explain the difference ... same process same number of logical I/O but much more physical disk I/O...

any suggestion welcome

Thanks

Paul


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com