DBA Cockpit for IBM Db2 for Linux, UNIX, and Windows (New and Changed)

Support of DB2 Version 10.1

You can now use the DBA Cockpit to monitor and administrate IBM Db2 for Linux, UNIX, and Windows (IBM Db2) databases with version 10.1.

Automatic Maintenance Queue/Requests for Real-Time Statistics

On the new Automatic Maintenance Queue/RTS Requests screen, you can display information about objects that are in the queue for automatic maintenance, about RUNSTATS candidates, and about requests for real-time statistics.

This screen is available for IBM Db2 as of version 10.1.

Diagnostics: Extended Latch Waits

On the new Extended Latch Waits screen, you can display a list of current and past extended latch waits.

This screen is available for IBM Db2 as of version 10.1.

Configuration History

The Configuration History screen has been enhanced so that you can also display the configuration history of IBM Db2 databases as of version 10.1.

Database Utility History

On the new Database Utility History screen, you can display an overview of past database utility runs such as reorganizations, backups, restores, or RUNSTATS. This screen replaces the existing Database History screen for IBM Db2 as of version 10.1.

Tables and Indexes: Compression Status

The Compression Status screen has been enhanced with information about adaptive compression for IBM Db2 as of version 10.1.

Furthermore, the global compression option has been integrated. This option is available as of DB2 V9.5 or higher.

Space: Automatic Storage

As of IBM Db2 10.1, multi-temperature storage is available, that is, you can classify and store data according to its temperature. The temperature of data is based on its relevance and on how often it is accessed. Then you can use faster, more expensive storage devices for hot data and slower, less expensive storage devices for cold data.

To move the hot, warm, and cold data automatically to the appropriate storage device, you can create storage groups in IBM Db2. You can assign the storage paths to the relevant storage group on the Automatic Storage screen of the DBA Cockpit.

Data Collection for History Screens

The data collection method has been changed for the following screens:

• Performance  History  Database

• Performance  History  Tables

Instead of the job SAP Collector for Performance Monitor ( sap_collector_for_perfmonitor), the data collection framework is now used.

Self-Monitoring

You can use the self-monitoring function of the DBA Cockpit to identify and repair issues related to the setup and configuration of the DBA Cockpit itself.

Snapshots: Cluster Caching Facility

On the new Cluster Caching Facility screen, you can display status information about cluster caching facilities on the system.

This screen is available for IBM Db2 as of version 10.1 with the pureScale Feature.

Snapshots: Transaction Log

On the new Transaction Log screen, you can display key figures related to transaction logging for a monitored database.

This screen is available for IBM Db2 as of version 10.1.

Prefetcher I/O Analysis

As of IBM Db2 version 10.1, new performance counters for the analysis of prefetcher I/O have been introduced. These new performance counters are available for the following screens under Performance  Snapshots:

• Database

• Buffer Pools

• Tablespaces

• SQL Cache

• Applications

HADR Monitoring

You can use the new HADR screen to monitor the current and past status of standby databases including multiple standby databases with replay delay.

This screen is available for IBM Db2 as of version 10.1.

Configuration History

The Configuration History screen was enhanced so that you can now also display changes to the database, buffer pools, partition groups, storage groups, and tablespaces.

This screen is available for IBM Db2 as of version 10.1.

Support of Storage Groups in the Monitoring and Alerting Infrastructure (MAI)

If you use the monitoring and alerting infrastructure (MAI), you now also get alerts when the fill ratio of a storage group is too low.

I/O Metrics for the Local and Global Buffer Pool (pureScale)

On the following screens under Performance  Snapshots, you can now display I/O metrics for the local and global buffer pool of DB2 databases with the pureScale Feature:

• Database

• Buffer Pools

• Tablespaces

• Applications

• SQL Cache

This information is available for IBM Db2 as of version 10.1.

Data Consumption of SAP GUI History Screens

The following SAP GUI history screens can now also show history data collected by the data collection framework (DCF) if history data from the job sap_collector_for_perfmonitor is unavailable:

• Space  History  Database and Tablespaces

• Space  History  Tables and Indexes

• Configuration  Configuration History

Collector Configuration

In previous releases and support packages, the Collector Configuration screen was available for the Web Dynpro user interface only. This screen is now also available for SAP GUI. You can use this screen to configure the data collectors for the DCF.

Screens for Tables and Indexes in SAP GUI

The following screens, which have been available for the Web Dynpro user interface in previous releases and support packages, are now also available for SAP GUI under Space  Tables and Indexes:

• Top Space Consumers

• REORG Candidates

• Compression Status

• Virtual Tables

• Indexes

Monitoring of Memory Consumption

You can use the new Memory screen to monitor the current and past memory consumption of the database.

Self-Monitoring of the DBA Cockpit

If there are issues with the setup and infrastructure of the DBA Cockpit, error messages are displayed on the relevant screens.

Jobs in the DBA Planning Calendar

The new job Reduce High-Water Mark for Tablespaces can be regularly scheduled to reduce the high-water mark for tablespaces and to reclaim and return space to the file system.

This job is available for IBM Db2 as of version 9.7.

More Information

For more information about the DBA Cockpit and its functions, see Database Administration Using the DBA Cockpit - IBM DB2 for Linux, UNIX, and Windows on SAP Service Marketplace at http://service.sap.com/%0A%0Ainstguidesnw70 Operations  Database-Specific Guides.