IDS 11 Performance Tuning
We're about to upgrade from IDS 9.40 to 11.50. We were told that the calculations used for version 7 & 9 are different than version 11. I looked every where for version 11 configuration tuning, but with not much luck. Whatever info I got back was fairly simple and did not cover the details for tuning, especially with the onconfig file. If you have any tips and hints on performance tuning, especially any methods/formula/calculation for the version 11 onconfig file, I would greatly appreciate if you can share them with me. By the way, I searched the IBM web site for IDS 11 performance tuning class, but didn't see any being offered. Any ideas? Thanks so much for your help! Regards, Lynn Nguyen Database Administrator The 401(k) Company, a Charles Schwab Company Phone: (512)344-3095 Warning: All email sent to or from the Charles Schwab corporate email system is subject to archiving, monitoring and/or review by Schwab personnel.
Hi Lynn, You may find IDS 11 Performance Guide at http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.p erf.doc/perf.htm Thanks, Sunil --- On Sun, 8/17/08, Nguyen, Lynn <Lynn.Nguyen@the401kcompany.com> wrote: From: Nguyen, Lynn <Lynn.Nguyen@the401kcompany.com> Subject: IDS 11 Performance Tuning [13139] To: ids@iiug.org Date: Sunday, August 17, 2008, 11:36 AM We're about to upgrade from IDS 9.40 to 11.50. We were told that the calculations used for version 7 & 9 are different than version 11. I looked every where for version 11 configuration tuning, but with not much luck. Whatever info I got back was fairly simple and did not cover the details for tuning, especially with the onconfig file. If you have any tips and hints on performance tuning, especially any methods/formula/calculation for the version 11 onconfig file, I would greatly appreciate if you can share them with me. By the way, I searched the IBM web site for IDS 11 performance tuning class, but didn't see any being offered. Any ideas? Thanks so much for your help! Regards, Lynn Nguyen Database Administrator The 401(k) Company, a Charles Schwab Company Phone: (512)344-3095 Warning: All email sent to or from the Charles Schwab corporate email system is subject to archiving, monitoring and/or review by Schwab personnel. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
The only big changes between tuning for 9.40 and 11.50 is that since 11.50's checkpoints are true non-blocking (not FUZZY - but full checkpoints that do not block updaters) you can increase the LRU_MIN_DIRTY and LRU_MAX_DIRTY significantly to take advantage of the more efficient CHUNK writes at checkpoint time. These were normally to be avoided in all earlier IDS releases because even FUZZY checkpoints blocked out transactions for a time and even the FUZZY checkpoint versions had to perform full checkpoints periodically. Beyond that there are new tunables to let the engine control the checkpoint related variables to either reduce checkpoint time or to make sure that recovery time after a system crash meets the specified time limit. The engine in 11.50 can also be configured to automatically add and drop AIO VPs to maintain IO efficiency for COOKED chunks and other cooked IO that cannot use KAIO. The addition of DIRECT IO in version 11.10 means that you can use KAIO for cooked chunks under certain conditions and that these reads and writes bypass the system buffer cache making them ALMOST as quick as RAW IO. Read the Administrators Reference and Performance Guide manuals for more details. Art On Sun, Aug 17, 2008 at 2:36 PM, Nguyen, Lynn < Lynn.Nguyen@the401kcompany.com> wrote: > We're about to upgrade from IDS 9.40 to 11.50. We were told that the > calculations used for version 7 & 9 are different than version 11. I > looked every where for version 11 configuration tuning, but with not > much luck. Whatever info I got back was fairly simple and did not cover > the details for tuning, especially with the onconfig file. > > If you have any tips and hints on performance tuning, especially any > methods/formula/calculation for the version 11 onconfig file, I would > greatly appreciate if you can share them with me. > > By the way, I searched the IBM web site for IDS 11 performance tuning > class, but didn't see any being offered. Any ideas? > > Thanks so much for your help! > > Regards, > > Lynn Nguyen > Database Administrator > The 401(k) Company, a Charles Schwab Company > Phone: (512)344-3095 > > Warning: All email sent to or from the Charles Schwab corporate email > system is subject to archiving, monitoring and/or review by Schwab > personnel. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.