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



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.