DB2 Version 10.1 for Linux, UNIX, and Windows

Autonomic computing overview

The DB2® autonomic computing environment is self-configuring, self-healing, self-optimizing, and self-protecting. By sensing and responding to situations that occur, autonomic computing shifts the burden of managing a computing environment from database administrators to technology.

Automatic features provides a high-level summary of the capabilities that comprise the DB2 autonomic computing environment; the following table provides a more detailed, categorized overview of the product's autonomic capabilities:

Table 1. Overview of autonomic computing information
Category	Related topics
Self-tuning memory	Memory usage Self-tuning memory Self-tuning memory overview auto_maint - Automatic maintenance configuration parameter db_storage_path - Automatic storage path monitor element num_db_storage_paths - Number of automatic storage paths monitor element tablespace_using_auto_storage - Using automatic storage monitor element Configuring memory and memory heaps Agent, process model, and memory configuration overview Shared file handle table Running vendor library functions in fenced-mode processes ADMIN_GET_MEM_USAGE table function - Get total memory consumption for instance Agent and process model configuration Configuring databases across multiple partitions
Automatic storage	Databases use automatic storage by default Automatic storage table spaces Automatic re-sizing of DMS table spaces
Data compression	Data compression Table compression Index compression Backup compression Table-level compression dictionary creation Compression dictionary creation during load operations
Automatic database backup	Automatic database backup Enabling automatic backup Developing a backup and recovery strategy
Automatic reorganization	Automatic reorganization
Automatic statistics collection	Automatic statistics collection Using automatic statistics collection Storage used by automatic statistics collection and profiling Automatic statistics collection activity logging
Configuration Advisor	Generating database configuration recommendations Tuning configuration parameters using the Configuration Advisor Example: Requesting configuration recommendations using the Configuration Advisor AUTOCONFIGURE command AUTOCONFIGURE command using the ADMIN_CMD procedure db2AutoConfig API - Access the Configuration Advisor Quick-start tips for performance tuning
Health monitor	Health monitor Health indicator process cycle Enabling health alert notification Configuring health indicators using a client application Health indicators summary
Utility throttling	Utility throttling Asynchronous index cleanup Asynchronous index cleanup for MDC tables LIST UTILITIES command SET UTIL_IMPACT_PRIORITY command util_impact_lim - Instance impact policy configuration parameter utility_priority - Utility Priority monitor element