How to use DB6DB21 - DB6: RUNSTATS Control

SAP Transaction Code - Details

• Transaction Code: DB6DB21

  Description: DB6: RUNSTATS Control

  Release: S/4HANA and ECC 6

• • Program: SAPLSDB6CCMS

    Screen: 150

    Authorization Object: S_ADMI_FCD

  • Development Package: STU6

    Package Description:

    Parent Package:

  • Module/Component:

    Description:

Smart SAP Assistant

• SAP Tcode: DB6DB21 - DB6: RUNSTATS Control

  
  Overview:
  DB6DB21 is a SAP transaction code used to control the RUNSTATS process in the DB6 database. It is used to collect statistics about the database and its objects, which can then be used to optimize the performance of the database. 
  
  Functionality: 
  The DB6DB21 transaction code allows users to control the RUNSTATS process in the DB6 database. This process collects statistics about the database and its objects, such as tables, indexes, and columns. The collected statistics can then be used to optimize the performance of the database. 
  
  Step-by-step How to Use: 
  1. Log into SAP and enter transaction code DB6DB21. 
  2. Select the database you want to run RUNSTATS on. 
  3. Select the objects you want to collect statistics for (e.g., tables, indexes, columns). 
  4. Select the type of statistics you want to collect (e.g., cardinality, density). 
  5. Select the type of RUNSTATS process you want to run (e.g., full, incremental). 
  6. Click “Execute” to start the RUNSTATS process. 
  7. Once the process is complete, click “Back” to return to the main screen. 
  
  Other Recommendations: 
  It is recommended that users run RUNSTATS regularly in order to keep their databases optimized for performance. Additionally, users should ensure that they have adequate disk space available before running RUNSTATS, as it can require a large amount of disk space depending on the size of the database and objects being analyzed.