Re: Performance and iAsp

Thanks, I'll try.

Best regards
--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco


Il giorno lun 1 gen 2024 alle ore 19:26 Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> ha scritto:

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.

--
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.