Yesterday was an exciting day with some very important announcements. IBM announced DB2 for Linux, UNIX and Windows Version 10.5 with the new column-organized tables that utilize BLU Acceleration; a unique and advanced columnar data store with advanced compression and hardware exploitation. IBM also announced updates to a number of database management solutions to help develop, monitor, manage and tune your DB2 LUW database. All of these solutions support the new column-organized tables.
With IBM InfoSphere Data Architect V9.1 you will be able to model column-organized tables.
IBM Data Studio V4.1 includes support for creating, altering, dropping and converting tables to column-organization. It also has enhanced support for multiple high availability disaster recovery (HADR) standbys, new checkpoint support in the script editor, and a wizard for creating federated objects.
A new advisor in IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows V4.1 helps identify which row-organized tables could benefit from being converted to column-organization.
IBM InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows V5.3 includes new statistics to support monitoring of column-organized tables. A significant usability enhancement has also been made to allow Optim Performance Manager users to tune queries using InfoSphere Query Workload Tuner within the Optim Performance Manager browser user interface.
IBM InfoSphere Optim Configuration Manager for DB2 for Linux, UNIX, and Windows V3.1 supports configuration management of column-organized tables as well as monitoring of the new DB2 pureScale rolling updates and application isolation for DB2’s pureScale clustering technology. Users can also use Optim Configuration Manager to determine how frequently database objects are accessed, making it easier to leverage the DB2 multi-temperature storage capabilities.
IBM InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows V3.3 includes enhancements to SQL management as well as improved error reporting.
All these tools are now bundled with both the Advanced Enterprise Server Edition of DB2 and the new Advance Workgroup Edition as well.
A new DB2 Advance Recovery feature includes these updated solutions:
IBM DB2 Merge Backup for Linux, UNIX, and Windows V2.1 which has been enhanced to support column-organized tables.
IBM DB2 Recovery Expert for Linux, UNIX, and Windows V4.1 which now supports the DB2’s pureScale clustering technology, adaptive compression, multi-temperature storage, and remote log analysis.
IBM InfoSphere Optim High Performance Unload for DB2 for Linux, UNIX, and Windows V5.1 includes support for DB2 10.5 and integration with IBM InfoSphere Optim Data Masking Solution.
As we get closer to the release date, we will publish more detail about these exciting new enhancements. Stay tuned.