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