×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
