AS/400e Advanced Technology 59
AS/400e Advanced Technology
• Applications - Cluster Proven: The AS/400 implementation of high availability solutions
involves the active participation of cluster middleware business partners who provide
cluster management and data resiliency tools, and Solution Developers who must design
applications that can maintain application states across an outage. Cluster management
and enhanced data resilience applications, both provided by high-availability business
partners, complete the total solution.
More detail on clustering is found in “Continuous Availability Clustering” on page 502.
• Availability services and support: As a world leading enterprise computing vendor, IBM
has a wealth of products and services to assist the customer in developing and
maintaining a high availability environment. These products are reviewed and links
provided to other sites.
Logical Partitioning (LPAR) enhances the role of the AS/400e as a consolidated server. With
LPAR, companies have both the power and flexibility to address multiple system
requirements in a single machine. LPAR is of value to customers that need server
consolidation, business unit consolidation, mixed production, and a test environment, as well
as integrated clusters. More detail on LPAR is found in “Continuous Availability Clustering” on
page 502.
Database
While DB2 for AS/400 has long provided facilities to address most customer requirements,
with V4R4, the AS/400e support has been extended to support new forms of information
previously stored on the AS/400e but not managed by DB2 for AS/400. With this release, DB2
Universal Database (UDB) for AS/400 now supports the storing, managing, and indexing of
all forms of information including binary objects (such as spreadsheets, word processing
documents, and multimedia objects) within the database. This support includes features such
as Binary Large Objects (BLOBs), user-defined functions, complex objects, query by image
content, and even spatial extenders. All of these features allow customers to use one
database management system to store, retrieve, and manage all of their corporate
information.
Performance and functional enhancements to the DB2 Universal Database for AS/400
improve the processing of business intelligence queries. These improvements include:
• The hash “group by” algorithm improves performance of grouping queries for a large
number of groups.
• The performance of MIN and MAX functions is improved with a suitable index, if
available, to determine the minimum or maximum value of a query.
• Derived tables and common table expression support allow complex business
intelligence queries to be written without the use of views.