SAP S/4 HANA DB Administration and Monitoring

Administration and Monitoring

DBACockpit Commonly used T-Code for DB Administration and Monitoring 

DBA Cockpit for SAP HANA is a tool to monitor and administer SAP HANA databases in an ABAP environment.

 DBA Cockpit can be used for below list.

• Monitor and administer local or remote SAP HANA databases
  More information: Administration and Monitoring Functions and Central Calendar in Related Information
• Manage central configuration
  DBA Cockpit offers functions to manage the database connections and configurations for an entire system landscape.
  More information: Setting Up Database Connections in Related Information
• Schedule database backups and other actions
  More information: DBA Planning Calendar in Related Information

SAP Transaction Code	Description
DB01	Analyze Exclusive Lockwaits
	Opens Diagnostics: Locks: Blocked Transactions in DBA Cockpit.
	More information: Locks in Related Information
DB02	Tables and Indexes Monitor
	Opens Diagnostics: Missing Tables and Indexes in DBA Cockpit.
	More information: Missing Tables and Indexes in Related Information
DB50	SAP DB Assistant
	Opens Current Status: Overview in DBA Cockpit.
	More information: Overview in Related Information
ST04	DB Performance Monitor
	Opens Current Status: Overview in DBA Cockpit.
	More information: Overview in Related Information
DB13	DBA Planning Calender
	Opens Jobs: DBA Planing Calender in DBA Cockpit.
	More information: DBA Planning Calendar in Related Information
DB13C	Central DBA Planning Calender
	Opens Jobs: Central Calender in DBA Cockpit.
	More information: Central Calendar in Related Information
DB26	DB Profile: Monitor and Configuration
	Opens Configuration: INI Files in DBA Cockpit.
	More information: INI Files in Related Information
DB03	Parameter Changes in Database
	Opens Configuration: INI Files in DBA Cockpit.
	More information: INI Files in Related Information
DB12	DBA Backup Logs
	Opens Diagnostics: Backup Catalog in DBA Cockpit.
	More information: Backup Catalog in Related Information
DBCO	Display and Change Database Connections
	Offers the same functionality as DB Connections in DBA Cockpit.
	More information: Add a Database Connection in Related Information
HDB_SQLDBC	Opens Configuration: Trace Configuration: SQLDBC Trace in DBA Cockpit.
	More information: Trace Configuration in Related Information