Recently, we engaged a client who only applies PTFs when there is an actual problem encountered. That means, almost never. In other words, no proactive or preventive maintenance. No periodic updates or upgrades. And yes, they do have several planned maintenance windows available per year.
Another set of clients have just migrated to IBM i 7.1. That, after waiting several years to finally get "current". Unfortunately, they are miles away from current.
More and more we see IBM i shops who are in some kind of analysis paralysis as they attempt to make a decision to stay with IBM i or move off to some "other" platform. All the while their business is changing, expanding and branching out in ways that require a non-linear approach to information management and data processing. My experience shows that virtually all of these shops have business requirements that can be met very nicely using current technology available via the combination of Power+IBM i+DB2. Technology that is readily available to them, I might add.
Presently, the IBM i user community enjoys significant stability, as well as tremendous flexibility when it comes to OS and RDBMS features and functions. Not only are there three OS releases available and supported (7.1, 7.2 and 7.3), there are also periodic enhancements available in the form of a technology refresh or update. While a given update is typically delivered as a robust set of PTFs, you certainly should not view a Technology Refresh (TR) as a simple set of "fixes".
Hey Look, Another Technology Refresh!
Today, IBM is announcing yet another technology refresh, specifically 7.3 TR1 and 7.2 TR5.
Alas, if you are using 7.1, you are falling behind. There is no TR available for the n-2 release.
The general availability for the 7.3 and 7.2 updates should be in about a month, so you have time to begin your testing and installation planning process.
From the database point of view, what are some of the items we can expect from this TR?
As usual, the focus is on increasing capabilities around data centric processing and enhancing database engineer productively...
Provides a way to include (pull source code into) another SQL procedure/function.
PERCENT_RANK as an ordered OLAP specification (7.3 only)
A distribution function that returns a relative percentile rank of a row within an OLAP window.
Additional Services (via SQL)
Retrieve data from QHST
Retrieve a list of jobs by user(s)
Analyze an SQL statement and extract information about the DB object(s), column(s) and UDF(s)
Misc. Performance Improvements
UDF in-lining (more complex UDFs can now be inline)
STATEMENT DETERMINISTIC (a new form of DETERMINISTIC for functions)
IBM Access Client Solutions - Database GUI
Enhancements to SQL Performance Center, Visual Explain and Run SQL Scripts
For more details on the new DB2 for i Technology Refresh, the illustrious Mr. Scott Forstie has what you need here.
For more information on all various TRs, go here.
What Should You Do Now?
Regardless of any future and far off "migration plans", get current with PTFs and TRs. That includes HIPER, Group and the latest Technology Refresh for your particular release, even 7.1.
While the various IT "leaders" are off trying to identify your future platform, you can get on with solving current business problems and providing immediate value with IBM i.
To facilitate keeping current (and relevant), stand up a DB2 for i sandbox. This can be a small but balanced LPAR or stand alone system running 7.3 plus TR1.
Take some dedicated time every week to discover, experiment, and try new database features and functions. Show off your work to the higher ups. Be a hero.
Please secure the personal identifiable information (PII) stored in your files and tables.
Start by asking, and answering the following question:
Who has *ALLOBJ authority on any system where PII is stored?
After you get over the shock and awe of finding out just how exposed you are, embark on the serious journey of securing the at risk data. Begin with the correct application of IBM i object based security, then continue with separating roles and responsibilities (the security officer and the database engineer should have different levels of authority based on their respective responsibilities).
Take a good look at using DB2 Row and Column Access Control. It will allow you to apply a more granular level of security on the sensitive data. DB2 RCAC is available in 7.2 and 7.3, so yet another reason to get current.
Identify, train, and support an IBM i database engineer. Ensure this person has not only the responsibility, but also the authority to do the job.
The database engineer is the font of knowledge and skill around DB2 for i features, functions and benefits. The database engineer will not only keep your organization current, but also be the trusted advisor for when and how DB2 technology can be applied to solving data centric business problems!
Start using modern tools and modern techniques immediately.
Go get IBM Data Studio and learn to use it.
Go get Access Client Solutions and try it out.
And finally, do more with your data, right now.
Go get DB2 Web Query, create some compelling visualizations and demonstrate the value to your business leaders. You can use that IBM i 7.3 sandbox to check out the advanced aggregation functions and OLAP specifications. Again, be a hero.
If you need more information or assistance with DB2 for i features and/or data centric programming technique, please do not hesitate to reach out.