V4R5 Interactive Performance QRY/SQL & CFINT

[Guest.Visitor]

[dbrunner@co.kenosha.wi.us]

No, the programs were TRACT from New World Systems. They build open queries on the fly from DSPF input data, to search image data. Dale

[Guest.Visitor]

In January we installed 4 9406 Model 170's in our E911 communications centers. We have 4R5 on these machines and use New World Systems Axis Computer Aided Dispatch software. We replaced 4 9402 units running 3R2. I just noticed this message starting to pop up and have been searching for an answer. Our vendor said he could analyze the interactive jobs and tell me what was using so much of the capacity for 150.00 per hour and it would take him three hours. After I read you post I think you gave me the solution. We never had these messages before so it kind of threw me when the message said that we might have to upgrade to fix the problem when I just did upgrade things.

[David Abramowitz]

Too often, I have seen server models sold to customers. Customers who really needed system models. Server models are far less expensive, and make for an easier sell than system models. This is particularly harmful to purchasers who are unaware that there are differences, and never get a full explanation. Suffice it to say, that if you use QINTER for more than just a relatively few jobs, you should be using a system model. The principle difference is that the server model deliberately kicks in CFINTxx jobs when a certain level of interactive processing is reached. There are other stories of frustration within these fora, and many more that are not. I've heard of one shop that lost its AS/400 altogether because of poor interactive performance. The manager never knew that there were model differences within a single model, he just thought that the AS/400 was terribly inefficient. Dave

[Guest.Visitor]

At one of our clients place, 720 system with INS card is installed. JDE Oneworld has been installed and ERP is in its infant stage, at the start of one department accessing the system we are recving complains that access is slow, though system is on 100 MBPS link. I hv chked with WRKSYSACT, where I find QSERVER/QZDASOINIT jobs taking most of the CPU and also CFINT job is displayed. System OS is at V4R4 and Having 153 GB of disk space and 1.2 GB of Main storage. Any inputs appreciated. TIA Rajesh

[Guest.Visitor]

We have 720 system with INS card. JDE Oneworld has been installed and ERP is in its infant stage, at the start of one department accessing the system we are recving complains that access is slow, though system is on 100 MBPS link. I hv chked with WRKSYSACT, where I find QSERVER/QZDASOINIT jobs taking most of the CPU and also CFINT job is displayed. System OS is at V4R4 and Having 153 GB of disk space and 1.2 GB of Main storage. TIA Rajesh

[dbrunner@co.kenosha.wi.us]

Rajesh, What is most important is the machines Interactive Card Feature. Check sysval QPRCFEAT. This card determines how much overall CPW your system has, and how much is allocated to interactive jobs. ie.. 206B means you have 240 total and 70 interactive. You should also check values QDYNPTYADJ and QDYNPTYSCD. If you reach the knee of the interactive curve, and Dynamic Priority Adjustment is set "on", your offending interactive jobs will automatically have their priorities downgraded. I think IBM's word is deprioritized!

[dbrunner@co.kenosha.wi.us]

I'm going to have to bite the bullet on this one and apologize for all my previous rantings about the V4R5 upgrade kicking in the Interactive knee limitation. I have just installed the latest, C1100450, cumulative PTF package, and was suprised to see that the problem has disappeared. I knew that the knee was getting kicked by our interactive QRY/SQL, but these programs were third party software routines, and we could not touch them. Further analysis of the 1100 cume revealed that there were 2 PTFs that probably addressed this issue, MF26039, and SF65231. These have been superceded by MF26393, and SF65647. Since installing the cume, the interactive CPW level, and performance, has returned to normal. If you are experiencing the same performance issues, due to problems with interactive QRY/SQL, I advise getting the C1100450 fix PTFs. Thanks for letting me vent, then letting me set the story straight. Dale

[David Abramowitz]

I don't think that your ODBC job and the fact that CFINTxx is running are releated. Dave