RE: V7R5 SQL Engine Performance Issue

More information...

We are hoping PTF 71405 will address this issue. Going to apply it later this week. Fingers crossed.

https://www.ibm.com/support/pages/ptf/MF71405

We are continuing to research this issue.

Rich


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg Wilburn
Sent: Thursday, October 5, 2023 7:50 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: V7R5 SQL Engine Performance Issue

Rich,
Thanks for the report... I have a ticket open currently. I have a Job Watcher Monitor running (since yesterday afternoon). Of course the system is really fast right now.
Greg

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rich Marion
Sent: Wednesday, October 4, 2023 11:32 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: V7R5 SQL Engine Performance Issue

Thanks for all the comments.

Current status:

IBM is seeing a memory pool being overloaded. So they have recommend to add more memory to that pool.

They are still looking into it.

Rich



-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Charles Wilt
Sent: Tuesday, October 3, 2023 7:35 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: V7R5 SQL Engine Performance Issue

Have you opened a case with IBM?

This is why you pay for support.

Hopefully you captured performance data prior to the upgrade that you can compare the post upgrade performance to.

Charles


On Mon, Oct 2, 2023 at 8:45 PM Rich Marion <DPCMarion@xxxxxxxxxxxxxxxxx>
wrote:

I recently upgraded from V7R3 to V7R5 and noticed many of my SQLRPGLE
program are now taking a super long time to complete. The program stack
points to the SQL EXEC or the FETCH statements.



Today, one program was doing a simply "Insert Into" with the "select"
having
a "Group By" over a single table (no joins or subqueries). It was
supposed to insert about 1.2 million records into a table that had over 700 million.
I let it run for 3 hours before I canceled it. It was adding about 25
records/second.



I manually executed the same "Select-Group by" and created a table
with the
1.2 million records. Then I wrote an Old fashion read/write program via
RLA. This entire process took less than a half an hour.



Has anyone noticed performance issues with the V7R5 SQL Engine?



TIA

Rich



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


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