RE: 7.4: "In this release, IBM Db2® for i is focused on improving ... performance of SQL as well as ... " -- MIDRANGE-L

IBM's update:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DB2%20for%20i%20Functional%20Enhancements

You can drill down into each one listed. For example this one:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/SQE%20Improvements%20for%20IBM%20i%207.4

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Wednesday, April 24, 2019 3:29 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: 7.4: "In this release, IBM Db2® for i is focused on improving ... performance of SQL as well as ... "

IBM replied off list. They are working on a new page with the performance enhancements. I was given permission to share now but it would look prettier to wait until a page is updated, so I'll wait.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Wednesday, April 24, 2019 2:48 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: 7.4: "In this release, IBM Db2® for i is focused on improving ... performance of SQL as well as ... "

I was asked about this from my boss. Working closely with him I can guess he’s thinking stuff like:
How did they improve performance of SQL? Did they do something along the lines of:
- SQE vs CQE?
- SQL Plan cache?
- SQL optimizer?
- what?
So I did some research and I find ONE item listed in “Db2 for i - Performance Enhancements”. And that item is: “IASP vary on performance is improved”. Now this may be a big thing for some of you but we really don’t find it applicable to our operations.

Is there something else I am missing in how 7.4 improved the performance of SQL?

Bibliography
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/IBM%20i%207.4%20-%20Base%20Enhancements
https://www-01.ibm.com/common/ssi/ShowDoc.wss?docURL=/common/ssi/rep_ca/4/897/ENUS219-214/index.html&request_locale=en

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
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@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com
--
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@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com