Server offers support that facilitates query and viewing.
Press Release Summary:
Model i5/OS supports virtual partition management to enable creation and management of Linux(TM) partitions without requirement for Hardware Management Console (HMC). With Virtual Partition Manager, product can support one i5/OS partition and up to 4 Linux partitions, which support virtual I/O resources. DB2® UDB for iSeries(TM) enables query optimizer to automatically recognize and utilize aggregated data in form of materialized query tables (MQTs).
Original Press Release:
Function Added to IBM i5/OS for Easier Query and View
Overview
Virtual Partition Manager
i5/OS supports creation and management of Linux(TM) partitions without the requirement for the Hardware Management Console (HMC)
Support for one i5/OS partition and up to four Linux partitions
Linux partitions support virtual I/O resources
Materialized query tables (MQTs)
DB2® UDB for iSeries(TM) is enhanced to enable the query optimizer to automatically recognize and take advantage of, where possible, aggregated data in the form of an MQT. The query rewrite function, built into DB2 UDB for iSeries, redirects the query to use the MQT, greatly reducing processing time.
INSTEAD OF triggers
Requested insert/update/delete operation against a view can enable a trigger program to execute in lieu of the database insert/update/delete operation.
Key prerequisites
i5/OS V5R3
Planned availability date
April 29, 2005
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
