i5/OS and OS/400 (5722-SS1): Architecture 529
Draft Document for Review October 18, 2004 5486OpS.fm
New with V5R3
Enhancements that promote globalization and portability through adherence
to standards:
– UTF-8 and UTF-16 support within the database
– SEQUENCE Object support enabled DB2 to handle key value (for
example, order ID) generation on behalf of your application
– EXCEPT/INTERSECT SQL set operators
– New BINARY/VARBINARY data type support
– More robust error handling with GET DIAGNOSTICS SQL statement
– Encryption capabilities enhanced with DB2 Family Column Encryption
functions
– NATIVE Microsoft .NET provider
– CLI column-wise binding
– Availability of Materialized Query Tables (MQTs) as a technology preview
with the ability to create and refresh MTQs
– Additional SQL enhancements that satisfy ISO and ANSI standards
Performance improvements to DB2 UDB for iSeries including:
– Parallel Concurrent table reorganize
– SQL Query Engine enhancements that have performance improvements
on a variety of customer queries
– Star Join enhancements
– Faster SQL deletes
– Faster stored procedure call processing
– On demand statistics generation
Improved server consolidation and enterprise growth by increasing limits on
the system and providing additional Migration Toolkits for moving data and
queries from other databases; example of limits that increased are:
– 1.7 TB tables
– Partitioned table support
– Larger decimal presision
– 256 tables (members) in a view
Refer to “Summary of today’s iSeries” on page 81 to see a source of
documentation identifying these and other software limits for i5/OS and
OS/400.
To Next Page
