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: 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 :
|
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/ instguidesnw70 .
DBA Cockpit for SAP HANA
Function |
Type of Change |
Description |
---|---|---|
Additional Status Information Displayed |
New |
now shows the following information:
|
Landscape Section |
New |
To check that your system is running and the status of its hosts and processes, choose . |
Display Statement String |
New |
You can display a complete statement, with its structure. In DBA Cockpit, choose Explain function displays the access strategy and the execution plan. This information can be displayed as a graphic. . The |
Trace Configuration |
New |
In DBA Cockpit, choose User Trace and Delete User Trace are available. Otherwise these options are grayed out. . 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 optionsTo see the output of the database trace, go to .To see the output of the SQLDBC trace, go to . |
Analyzing Expensive Statements |
New |
In DBA Cockpit, choose . New functionality is available to explain, explain (graphically), and trace the execution of SQL statements. |
SQL Plan Cache |
New |
In DBA Cockpit, choose . |
Tables/Views |
Changed |
In DBA Cockpit, choose . 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 . You can merge trace and log files into one file. This allows you, for example, to search for traces from a specific date. |
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/instguides