Filter
Top Products
© 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
$%@^IowaAmesSmithCasey
*&^%$*MinnesotaMinneapolisJonesMegan
Credit
Card#
StateCityLast
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