How to use DB21 - Configure DB Statistics

DB21 - Overview

• Transaction Code: DB21

  Description: Configure DB Statistics

  Release: S/4HANA and ECC 6

  Menu Path:

  • Tools > CCMS > DB Administration > Cost-Based Optimizer > Configuration

• • Program: RSDBACBO

    Screen: 1000

    Authorization Object: S_ADMI_FCD

  • Development Package: SDBA

    Package Description:

    Parent Package:

  • Module/Component:

    Description:

DB21 - Details

• SAP Tcode: DB21 - Configure DB Statistics

  
  Overview:
  The SAP transaction code DB21 is used to configure database statistics. This code allows users to view and analyze the performance of their database system. It provides information about the number of records, the size of the database, and other important metrics. 
  
  Functionality: 
  DB21 provides users with a comprehensive overview of their database system. It allows users to view and analyze the performance of their database system. It provides information about the number of records, the size of the database, and other important metrics. Additionally, it can be used to identify potential problems with the system and take corrective action. 
  
  Step-by-step How to Use: 
  1. Enter transaction code DB21 in the command field. 
  2. Select “Configure Database Statistics” from the menu that appears. 
  3. Select the type of statistics you want to view (e.g., number of records, size of database). 
  4. Select “Display” to view the statistics for your database system. 
  5. Select “Analyze” to analyze the performance of your database system. 
  6. Select “Save” to save any changes you have made to your configuration settings. 
  7. Select “Exit” to exit the transaction code DB21. 
  
  Other Recommendations: 
  It is recommended that users regularly review their database statistics in order to ensure optimal performance and identify any potential problems with their system. Additionally, users should ensure that they have adequate disk space available for their database