IBM I 7.1 - Manual (Page 11)

© 2010 IBM Corporation
IBM Power Systems
11
DB2 for i - Additional Enhancements
ƒ
Column Level Encryption
– Allows for transparent (no application changes) encryption of a
specific column in a database table accessed through SQL or
native
– Solutions from tool providers including Patrick Townsend, and
Linoma Software supply encryption algorithms
ƒ
Application Developers
– MERGE, Array support, Global Variables, and consuming
result sets in RPG allows for more powerful and efficient
programming
ƒ
Performance
– Adaptive Query Processing can modify query plan while the
query is running to significantly improve performance
– Advanced SQE query optimizer now supports native logical
files
ƒ
Management
– New tooling to monitor long running operations
– SQL_CANCEL procedure to cancel long running queries.
– Random or Sequential I/O statistics to identify tables that can
benefit from SSDs
$%@^ Iowa Ames Smith Casey
*&^%$* Minnesota Minneapolis Jones Megan
Credit
Card#
State City Last
Name
First
Name
DB2 is an integrated database supporting transaction
processing and business intelligence applications
On-Demand Performance
Center
– Rich tools for DB2 for i
– Including Visual Explain
– Adaptive Query Processing
can automatically build an
index to replace table scan
…taking queries from
30 minutes to 1 minute