I’m hoping that you saw the big DB2 10 for Linux, UNIX, and Windows announcement or will be attending the virtual conference The Future of Database and Data Warehousing Software today through Thursday. Concurrent with the upcoming delivery of DB2 10, scheduled for April 30th, our InfoSphere Optim tools team is planning a set of releases designed to provide support for the new DB2 10 features. We hope these enhancements will help you get going with new features including time travel query, row and column access control, multi-temperature storage, adaptive compression, and query performance improvements. The new releases are:
- Data Studio V3.1.1
- InfoSphere Data Architect V8.1
- InfoSphere Optim Query Workload Tuner V3.1.1
- InfoSphere Optim pureQuery Runtime V3.1.1
- InfoSphere Optim Performance Manager V5.1.1
- InfoSphere Optim Configuration Manager V2.1.1
- InfoSphere Optim High Performance Unload V4.2.1
- DB2 Merge Backup V1.1.1
- DB2 Recovery Expert V3.1.1
The new capabilities help developers, DBAs, or security administrators
- Design, develop, and deploy temporal tables, develop and validate time travel queries, or access and view row history.
- Get recommendations for adaptive compression use, deploy compression, and validate compression savings.
- Collaborate to safeguard data enabling security administrators to define, view, and deploy row and column access control and DBAs to analyze the impact of new security controls and update routines accordingly.
- Enhance the value of multi-temperature storage by monitoring storage group access, analyzing storage group growth and contents, enabling WLM configurations to prioritize queries against high performing storage, and automating period roll-off for range partitioned tables to lower cost storage.
- Analyze access plan improvements and regressions based on new optimization strategies and get actionable recommendations for improvements.
- Monitor multiple standby availability and alert availability risks.
Furthermore, InfoSphere Optim tools continue to extend support for production deployments of DB2 pureScale environments with added configuration, administration, and monitoring capabilities. Developers will benefit from new tool support that facilitates application migration and co-existence, with added support for PL/SQL procedure profiling and Oracle database federation definition.
And those are just the enhancements focused on DB2 10. Over the next few weeks, we’ll be blogging on the releases in detail including enhancements not mentioned here.
And more BIG news: DB2 Advanced Enterprise Server Edition now includes more of the InfoSphere Optim portfolio: specifically InfoSphere Data Architect, InfoSphere Optim Query Workload Tuner, InfoSphere Optim pureQuery Runtime, InfoSphere Optim Performance Manager Extended Edition, and InfoSphere Optim Configuration Manager. The Fillmore Group is doing a webcast April 5th titled DB2 Advanced Enterprise Server Edition -Why You Should Consider it. Check it out.
And stay tuned!