IBM i 7.5: New System Limits and More Hidden Gems
From no-charge features to new system limits, Dawn May highlights more hidden gems from the IBM i 7.5 announcements
Historical Data Collection Is on by DefaultI submitted an IBM Idea asking that Collection Services enable historical data by default. I am happy to report this feature is now a part of 7.5. I found this gem hidden in the Memo to Users. However, it is limited to new installations of IBM i 7.5. If you are upgrading from a prior release, the existing historical data configuration will not be changed.
Tip: Enable historical data collection on your IBM i partitions.
Maximum Capacities: Number of Entries in a User ProfileSeveral system limits were increased, one of which was the maximum number of entries in a user profile. I had written about this limit in “When Does a User Profile Becomes a Bottleneck?” This larger limit is a good change, particularly if you have user profiles own a lot of objects in the IFS.
Related to the number of entries in a user profile, the QSYS2.USER_STORAGE service, is now able to return several additional columns of information about the authority-related entries in the user profile. This provides valuable information to help understand why a user profile has a large number of entries.
Asynchronous Bring Default Is Now *YESAnother tidbit hidden in the Memo to Users, the Asynchronous Bring (ASYNCBRING) parameter for IFS saves is now changed to a default of *YES. This parameter was introduced several years ago and *YES generally improves the performance of IFS saves. My “Achieve Faster IFS Save Times with ASYNCBRING” blog post originally described this feature.
No-Charge FeaturesIn his post, “What’s New with Db2 for i 7.5” Kent Milligan wrote that several options of the OS that used to be chargeable are now no-charge features. Db2 Multisystem, Db2 SMP and HA Journal Performance are included for no charge with 7.5. It is great to have these features available, but Db2 SMP and Db2 Multisystem need planning before you use them.
I know of many smaller shops that will benefit from HA Journal Performance (journal caching), but could not justify the additional cost to purchase the product.
IBM has also added additional controls for Db2 SMP. In my experience, Db2 SMP can consume a lot of system resources, in particular, CPU, and additional knobs to better control Db2 SMP resource consumption is a good thing.
QSYS2.MTI_INFOOf all the many new services to pick from, QSYS2.MTI_INFO requires special mention. I recently worked with several clients that have huge amounts of temporary storage consumed by Maintained Temporary Indexes (MTIs). MTI_INFO is very useful for evaluating the MTIs and determining if creating permanent indexes is beneficial. I expect to utilize this feature quite a bit in the future.
About the author
Dawn May is an IBM i consultant. She owns Dawn May Consulting, LLC in the Greater Boston area. Dawn is a former IBM senior technical staff member.
See more by Dawn May