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



Ok, I like technical humor but I admit that sometimes it can whoosh by. Don't ask me how long it took me to find the humor in "Mother's board, Dad's Unix".
Can you explain
ori 0,0,0
?

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Krill, Coy
Sent: Wednesday, April 24, 2019 2:56 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 ... "

Can't you just trust that they removed a couple of these embedded in some loops and that sped things up?

ori 0,0,0

:-)

Coy Krill
Core Processing Team Lead
Washington Trust Bank


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Wednesday, April 24, 2019 11:48
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 ... "
Importance: Low

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.