V7R5 SQL Engine Performance Issue

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