DB2 Version 9.7 for Linux, UNIX, and Windows

Manageability enhancements

Version 9.7 provides enhancements that make it easier to manage DB2® environments, reduce the total cost of ownership (TCO), reduce the impact of performing system management tasks, and extend the capabilities of the autonomic features introduced in previous releases.

Version 9.7 includes the following automatic storage enhancements:

Automatic storage support for existing databases and DMS table spaces
Table space rebalancing when you add or remove storage paths
A new ALTER DATABASE statement option for dropping storage paths
New monitoring elements for storage paths and a new administrative view, SNAPSTORAGE_PATHS

Unused storage extents are also easier to reclaim. You can reclaim storage from the following objects:

DMS or automatic storage table spaces
Multidimensional clustering (MDC) tables

The following enhancements are also included:

Numerous new administrative views and table functions
The ability to move table data online
Increased capacity for large and temporary table spaces
Larger data warehouses support
Reduced downtime when adding database partition servers
Additional index information from the DESCRIBE command
Reorganization of data or indexes for a specific data partition of a data partitioned table
Easier to relocate databases
The ability to restrict database connections within quiesced instances
The db2look command generates DDL statements for database objects and dependents in different schemas
Access control, error checking, and table exclusion during data redistribution have been improved.