Plan the installation and migration to DB2 9.7 for Linux, UNIX, and Windows

Describe the new functions and options for administration of DB2 databases provided by DB2 9.7

Assess the applicability of the DB2 9.7 features and functions in your application environment to maximize the performance, recoverability, security and operational management

Discuss the advantages and potential impact of this release of DB2 to your environment

This is an intermediate course for database administrators, application designers, technical support, and technical specialists who require information about the features and functions of DB2 9.7 for Linux, UNIX, and Windows.

DB2 9.7 Security Features

• Explain the privileges associated with the SYSADM, SECADM and DBADM authorities
• Describe the expanded role of the security administrator in a DB2 9.7 database system
• Grant database privileges, including ACCESSCTRL, DATAACESS, SQLADM and EXPLAIN to provide limited authorities to perform database support tasks
• List the steps required to implement Secured Socket Layer (SSL) connections for DB2 database servers
• Configure Java and non Java client systems for SSL connections
• Set the alternate_auth_enc DBM configuration option to select the encryption used for SERVER_ENCRYPT authentication

DB2 9.7 Application Concurrency Enhancements

• Evaluate setting the CUR_COMMIT database configuration option to reduce lock waits, lock timeouts or deadlocks
• Explain how DB2 can access the committed version of a data row that is currently being updated by another application
• Define a LOCKING Event monitor to capture deadlocks, lock timeout or lock waits
• Configure a DB2 database to control information captured for deadlocks, lock timeouts or extended lock waits
• Use the DB2 provided tools to analyze lock related problems based on data captured by a locking event monitor

DB2 9.7 Compression Enhancements

• Describe how DB2's Index compression option can reduce disk storage requirements for indexes
• Explain how DB2 can compress temporary data to improve application performance
• List the options for implementation of compression for the XML and Large Object data columns in a DB2 table
• Utilize the DB2 provided tools and functions to estimate compression results for Indexes and XML data

DB2 9.7 Space Management Enhancements

• Describe the steps a database administrator could use to adjust the disk storage paths assigned to a DB2 database and to rebalance table spaces to make more efficient use of new storage paths
• Convert an existing DMS database managed table space to take advantage of automatic storage management
• Reduce the High Water Mark for database managed and automatic storage managed table spaces reclaim unused disk space.
• Utilize the ADMIN_MOVE_TABLE stored procedure to move the data in a table to a new table object of the same name, but with possibly different storage characteristics, while the data remains online and available for access.

DB2 9.7 Large Table Management Enhancements

• Describe some of the DB2 9.7 changes that support larger databases and larger tables, including increased size limits for large and temporary table spaces and larger distribution maps for DPF database partitioning
• Use the START DATABASE MANAGER command to add new database partition servers to a multi-partition database environment without having to stop and restart the instance.
• Explain the difference between partitioned and non-partitioned indexes for a range partitioned table
• Implement partitioned indexes to improve performance when you roll data out or roll data into a range partitioned table
• Utilize the REORG utility with the RECLAIM EXTENTS ONLY option to efficiently free unused extents in a MDC table while applications have full read write access to the table

DB2 9.7 Database Monitoring Enhancements

• Utilize the new relational monitoring interfaces in DB2 9.7, that can be accessed directly by SQL, resulting in enhanced reporting and monitoring of the database system, data objects, and the package cache to help you quickly identify issues that might be causing problems
• Configure the DB2 Database configuration opti

You should have working knowledge of DB2 9 for Linux, UNIX, and Windows.