Show TOC

AS ABAPLocate this document in the navigation structure

Use

This section describes all new functions, enhancements, and changes for AS ABAP for Support Package Stack 8.

DBA Cockpit for IBM DB2 for Linux, UNIX, and Windows

Function

Type of Change

Description

Support of DB2 Version 10.1

New

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

Automatic Maintenance Queue/Requests for Real-Time Statistics

New

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 for Linux, UNIX, and Windows (DB2 for LUW) as of version 10.1.

Diagnostics: Extended Latch Waits

New

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

This screen is available for DB2 for LUW as of version 10.1.

Configuration History

Enhanced

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

Database Utility History

New

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 DB2 for LUW as of version 10.1.

Tables and Indexes: Compression Status

Enhanced

The Compression Status screen has been enhanced with information about adaptive compression for DB2 for LUW 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

Enhanced

As of DB2 for LUW 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 DB2 for LUW. 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

Changed

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

  • Start of the navigation path Performance Next navigation step History Next navigation step Database End of the navigation path

  • Start of the navigation path Performance Next navigation step History Next navigation step Tables End of the navigation path

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

Self-Monitoring

New

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

New

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

This screen is available for DB2 for LUW as of version 10.1 with the pureScale feature.

Snapshots: Transaction Log

New

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

This screen is available for DB2 for LUW as of version 10.1.

Prefetcher I/O Analysis

Enhanced

As of DB2 for LUW 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 Start of the navigation path Performance Next navigation step Snapshots End of the navigation path:

  • Database

  • Buffer Pools

  • Tablespaces

  • SQL Cache

  • Applications

Note

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/ instguidesnw70Information published on SAP site Start of the navigation path Operations Next navigation step Database-Specific Guides End of the navigation path.

DBA Cockpit for SAP HANA

Function

Type of Change

Description

Additional Status Information Displayed

New

Start of the navigation path Current Status Next navigation step Overview End of the navigation path now shows the following information:

  • Database Memory and CPU

    Here, you can see the memory used relative to the allocated memory, and the actual CPU usage and available CPUs. Choose either option to go to the Services overview.

  • Database Disk Usage

    Choose either option to go to the Disks overview.

Landscape Section

New

To check that your system is running and the status of its hosts and processes, choose Start of the navigation path Current Status Next navigation step Landscape End of the navigation path.

Display Statement String

New

You can display a complete statement, with its structure.

In DBA Cockpit, choose Start of the navigation path Current Status Next navigation step Threads Next navigation step Display Statement String End of the navigation path. The Explain function displays the access strategy and the execution plan. This information can be displayed as a graphic.

Trace Configuration

New

In DBA Cockpit, choose Start of the navigation path Current Status Next navigation step Trace Configuration End of the navigation path. Here, you can see the status, and configure the traces. If you have authorization, you can change the options for each trace type. If a user trace exists, the options User Trace and Delete User Trace are available. Otherwise these options are grayed out.

To see the output of the database trace, go to Start of the navigation path Diagnostics Next navigation step Database Trace End of the navigation path.

To see the output of the SQLDBC trace, go to Start of the navigation path Diagnostics Next navigation step SQLDBC Trace End of the navigation path.

Analyzing Expensive Statements

New

In DBA Cockpit, choose Start of the navigation path Performance Next navigation step Expensive Statements End of the navigation path. New functionality is available to explain, explain (graphically), and trace the execution of SQL statements.

SQL Plan Cache

New

In DBA Cockpit, choose Start of the navigation path Performance Next navigation step SQL Plan Cache End of the navigation path.

Tables/Views

Changed

In DBA Cockpit, choose Start of the navigation path Diagnostics Next navigation step Tables/Views End of the navigation path. DBA Cockpit displays the estimated maximum size in memory for a table and its size on disk.

Merged Diagnosis Files

New

In DBA Cockpit, choose Start of the navigation path Diagnostics Next navigation step Merged Diagnosis Files End of the navigation path. You can merge trace and log files into one file. This allows you, for example, to search for traces from a specific date.

Note

For more information, see the documentation for DBA Cockpit for SAP HANA on SAP Help Portal at:

http://help.sap.com/saphelp_nw73/helpdata/de/47/87bfe9cb044ef3a1811a7ff235d0d3/frameset.htm

DBA Cockpit for SAP Sybase ASE

Function

Type of Change

Description

Performance: System Load

Changed/Enhanced

The calculation and presentation of the system load has been enhanced for the thread based database kernel. It is now possible to display data on thread, threadpool, and database levels.

Performance: Device I/O

New

On the Device I/O screen, you can display information on read and write access to database devices and how this changes over time. The data is provided by the new Devices data collector. This screen is available for SAP Sybase ASE as of version 15.7.0.000. The level of available information is increased with SAP Sybase ASE 15.7.0.020.

Performance: Spinlocks

New

On the Spinlocks screen, you can display information on spinlock contention and how this changes over time. The data is provided by the new Spinlocks data collector. This screen is available for SAP Sybase ASE as of version 15.7.0.020

Performance: SQL Statements: Top SQL Statements

New

On the Top SQL Statements screen, you can identify the most expensive SQL statements for a selected period of time. The data is provided by the new Statement Cache data collector. This screen is available for SAP Sybase ASE as of version 15.7.0.000. The level of available information is increased with SAP Sybase ASE 15.7.0.020.

Performance: SQL Statements: Statement Cache

Enhanced

The Statement Cache screen has been enhanced with a short-term history of execution metrics. This data is provided by the new Statement Cache data collector. Additionally, the level of available information has increased with Sybase ASE 15.7.0.020.

Space: File Systems

Enhanced

On the File Systems screen, you can now display history information about file system size and free space. The data is provided by the new File Systems data collector.

Space: Devices

Enhanced

On the Devices screen, you can now display history information about device growth. This information is accessed by selecting a device and using the Show Growth button. The data is provided by the new Devices data collector.

Space: Databases

Enhanced

On the Databases screen, you can now display history information about database growth. This information is accessed by selecting a database and using the Show Growth button. The data is provided by the new Devices data collector.

Space: Deferred Table Creation

New

The Deferred Table Creation screen shows a list of empty tables that were created with deferred allocation, as well as a list of candidates conversion into a table with deferred allocation. The minimum required version of Sybase ASE is 15.7.0.020.

Configuration: Data Caches

Enhanced

On the Data Caches screen, you can now create, delete, and change data caches. On the cache pools tab of the Details screen that is visible when you select a data cache, you can now create, delete and change cache pools.

Configuration: Collector Configuration

Changed

The Devices and File Systems data collectors have been added. All other data collectors have been changed and need to be repaired after applying Support Package stack 12.

Self-Monitoring

New

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.

For more information, refer to the SAP DBA Guide: SAP Sybase Adaptive Server Enterprise on SAP Service Marketplace at http://service.sap.com/instguidesInformation published on SAP site Start of the navigation path SAP NetWeaver Next navigation step <Release> Next navigation step Operations Next navigation step Database-Specific Guides End of the navigation path