IBM I 7.1 manual DB2 for i - Additional Enhancements, ƒ Column Level Encryption, ƒ Performance

IBM Power Systems

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

First	Last	City	State	Credit
Name	Name			Card#
Megan	Jones	Minneapolis	Minnesota	*&^%$*
Casey	Smith	Ames	Iowa	$%@^

ƒ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

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

11 © 2010 IBM Corporation