Skip to Content
Product Information
Author's profile photo Stefanie Poliwoda

DBA Cockpit for SAP ASE – New Screens and Enhancements

My name is Steffi. I started to work for SAP as support engineer for SAP Business ByDesign and SAP Cloud for Customer in Galway, Ireland in 2019. After two years, I transitioned to a new role as Developer in St. Leon-Rot, Germany. Here, I am responsible for designing, developing, enhancing, and supporting monitoring and administration tools for SAP Adaptive Server Enterprise database.

In this article, I will provide you an overview of some of the new features and enhancements of the DBA Cockpit for SAP Adaptive Server Enterprise in the past two years.

Missing Statistics

In the Diagnostics Menu, there is a new screen called Missing Statistics. This screen is based on the configuration parameter Capture Missing Statistics and on the system table sysstatistics. Once Capture Missing Statistics is enabled, this screen shows:

  • the Date the statistic was reported as first time missing,
  • the Database,
  • the Table name,
  • the Column name(s), and
  • the Number of times the statistic was counted as missing.

This screen features the possibility to activate and to deactivate Capture Missing Statistics ad-hoc and on an hourly basis (with the help of the SAP ASE Job Scheduler). In addition to it, there is also a possibility to jump to the Single Table Analysis Screen and to update statistics directly from this screen.

Figure%201%3A%20Features%20of%20the%20Screen%20Missing%20Statistics

Figure 1: Features of the Screen Missing Statistics

More information about the topic Missing Statistics will follow in a separate blog article.

SSL Certificates

In the Diagnostics menu, there is another new screen called SSL Certificates that shows:

  • the file path,
  • the start date, and
  • the end date of the SSL certificate.

This information comes from the table master..monSSLCertInfo which provides information about installed SSL certificates. The screen features a filter on end date to sort the end date in a way that the certificate with the smallest end date is at the top of the overview.

Figure%202%3A%20Screen%20SSL%20Certificates

Figure 2: Screen SSL Certificates

Dump Overview & Dump History

The reason for the re-design of the screen Dump History was that a new API to retrieve information on backups has been made available with the introduction of BALDR. The screen Dump Overview located below the Backup & Recovery Menu will provide the time of the last successful dump as well as the time elapsed since the last successful dump for each database of the database server and for each type of dump:

  • database dumps,
  • cumulative dumps,
  • delta dumps, and
  • transaction log dumps.

Figure%203%3A%20Screen%20Dump%20Overview

Figure 3: Screen Dump Overview

The  screen Dump History features a summary of the number of the failed as well as of the successful database and transaction dumps, a filter to get all dumps for a specific database and for a specific status. The overview table is split into Database Dump tab where database dumps, cumulative dumps, and delta dumps and Transaction Dump tab where Transaction Dump can be monitored for a specific time frame.

Figure%204%3A%20Screen%20Dump%20History

Figure 4: Screen Dump History

If a dump with the status failed is selected in the table, it will also display an error code and description.

Figure%205%3A%20Error%20Information

Figure 5: Error Information

Baldr Version

For all database systems where the owner of the DBA Cockpit is Baldr we show the Baldr Version on the Instance Overview Plugin and on the screen Data Collectors and Admin Procedures. For older systems where the owner is not Baldr it shows that the information is not applicable.

Figure%206%3A%20Baldr%20Version

Figure 6: Baldr Version

Synchronisation State & Mode

The Replication Plugin on the Dashboard was split into three views:

  • HADR Overview,
  • HA/DR: HA Status, and
  • HA/DR: DR Standby.

The first view will show the logical host, the HADR State and the HADR Mode. The second view will show the site 1 & site 2 as well as the Synchronisation State and the Synchronisation Mode. The third view will show the same information like the second view, but for the site 3 (if existing).

Figure%207%3A%20Replication%20Plugins

Figure 7: Replication Plugins

IMRS Cache

The screen IMRS Caches located in the Configuration Menu will provide an overview of the IMRS caches that have been created on a specific database system. It shows

  • the Cache name,
  • the Cache size,
  • the Used Size,
  • the database name, and
  • the status.

This information comes from the table master..monIMRSCache. On this screen, you can create a new IMRS cache, change the current size of an existing IMRS cache or change the assigned database, and remove an existing IMRS cache.

Figure%208%3A%20IMRS%20Cache%20Configuration

Figure 8: IMRS Cache Configuration

Information on memory usage such as the number of rows in the cache, number of rows packed by the pack operation can be accessed via the IMRS Cache Usage screen located below the Performance Menu. This information comes from the table master..monIMRSCacheActivity which stores statistics related to In-Memory data caches.

ATM Queue

It is possible to select and delete multiple rows at the same time on this screen.

This was a short overview of some of the new screens and enhancements of the DBA Cockpit for SAP Adaptive Server Enterprise. Which of these features and enhancement do you like? And which of these features are you planning to use? Would you like to get more information about one of these topics? Let me know in the comments. To stay current about SAP Adaptive Server Enterprise, please consider following the topic page here. Or you can also read other blogs related to SAP Adaptive Server Enterprises here. If you have a question related to this topic, you can post it here.

 

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Hector Ganga
      Hector Ganga

      Hi Stefanie, great blog. Very useful information. I am interested by now in the monitoring capabilities for ASE HA/DR of the DBACOCKPIT. We have a Solution Manager 7.2 SPS12 (02/2021). I have configured the Dashbord for the HA/DR information, but the information provided by my dashbord is very basic, not like the picture you posted here, and for the DR node, my DBACOCKPIT not recognizes as DR Standby Node (i think this is for the version of Netweaver of Solution Manager):

      * we have installed the latest version of BALDR (20221215121208 - SAP Note 2502193).

      Could you please share the infomation about the version of the system where the pictures came out? May be it is a Netweaver 7.5 last SPS?

       

      Thanks and best regards.

      Author's profile photo Stefanie Poliwoda
      Stefanie Poliwoda
      Blog Post Author

      Hi Hector,

      Thank you for your reply!

      The updated plugins for HA/DR will be available soon. I will let you know once it is available. I will also post the version.

      Regards,

      Steffi