Re: Performance and iAsp

This sounds a lot like other performance complaints after a V7R5 upgrades on this list. I doubt it has much to do with the source on the QSYS2 tables, since the system would need them all to give complete answers.

I’m doubtful that a conversion to all iASP or no iASP would make much difference either.

I suggest you open a case with IBM.


Jim Oberholtzer
Agile Technology Architects
Office: 414-433-4363
Mobile: 414-915-1445
Sent from mobile device

On Jan 1, 2024, at 8:31 AM, Marco Facchinetti <marco.facchinetti@xxxxxxxxx> wrote:

Few months ago we added 10 spinning disks in our IBM 5030E. The main
purpose is to provide a separate disk pool for large, rarely used libraries
and a staging area for creating SAVF's for nightly saves.
Of course we made a new pool on the SAN and we decided to use iAsp instead
of a normal Asp only because iAsp cannot spill into system Asp.
The majority of basic users don't see the new iASP because they don't need
it, on the contrary all the higher profiles use the iASP (via
INLASPGRP). For these profiles the problem I noticed is that all functions
that somehow use tables (or Sql functions) in QSYS2 have become slower.
Checking how they are executed it is quite clear that both the programs and
tables used are from the iASP rather than the system ASP.

So my questions are:
- If instead of using an iASP I had used a normal ASP would the problem
still occur?
- Could transforming the iASP into a normal ASP extend the problem to all
other users of the system?

The operating system is version 7.5 with recent ptfs.

Tia
--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.