DB12 - detailed information

DB12 - detailed information

This page provides detailed information about transaction DB12 and where this transaction gets the displayed information.

Sources of Information
What happens when I press 'Refresh'?
Further information

Sources of Information

SAP basis release 3.1I to 4.6D

• Button List of Logs (3.1I to 4.6B and 4.6C SP < 51 and 4.6D SP < 42)
  • overview: system table CNHIST
  • details: system table CNREPRT
    
    
• Button List of Logs (4.6C SP >= 51 and 4.6D SP >= 42)
  • overview: file dbm.knl (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE)
  • details: file dbm.utl (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE)
    
    
• Button Log Area
  • function module GET_LOG_STATE
    
    
• Button Optimizer Statistics -> List of Logs
  • overview: table SDBAADAUPD,
  • details: log file read from the work directory of the SAP system
    
    
• Button Consistency Check -> List of Logs
  • only tables
    • overview: table SDBAADAUPD,
    • details: log file read from the work directory of the SAP system
  • all objects (3.1I to 4.6B and 4.6C SP <51 and 4.6D SP <42)
    • overview: table CNREPRT,
    • details: CNREPRT
  • all objects (4.6C SP >= 51 and 4.6D SP >= 42)
    • overview: file dbm.utl (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE)
    • details: file dbm.utl (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE)

SAP basis release 6.10 SP < 44, 6.20 SP < 53, 6.40 SP < 13

• Button List of Logs
  • overview: file dbm.knl (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE)
  • details: file dbm.utl (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE)
    
    
• Button Log Area
  • function module GET_LOG_STATE
    
    
• Button Optimizer Statistics -> List of Logs
  • overview: tables DBAML & DBAOPTL
  • details: log file read from the work directory of the SAP system
    
    
• Button Consistency Check -> List of Logs
  • only tables
    • overview: table SDBAADAUPD
    • details: log file read from the work directory of the SAP system
  • all objects
    • not displayed. See transaction DB50 for these actions.

SAP basis release 6.10 SP >= 44, 6.20 SP >= 53, 6.40 SP >= 13

• Button DBA Actions -> List of Logs
  • Backup/Recovery (DBMServer)
    • overview: table SDBAHSDB
    • details: One file per action in directory dbahist (e.g. file 20050101220000.sda)
  • Backup/Recovery (Kernel)
    • overview: file dbm.knl in the rundirectory of the database instance (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE)
    • details: file dbm.utl in the rundirectory of the database instance (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE)
  • Optimizerstatistics
    • overview: table SDBAHSDB
    • details: read from work directory of SAP System
  • Database Structure Check
    • overview: table SDBAHSDB.
    • details: one file per action in directory dbahist or read from the work directory of the SAP System (XPU actions)
  • Archive Version Files
    • overview: table SDBAHSDB.
    • details: one file per action in directory dbahist
      
      
• Button Memory Areas -> Log/Data Area
  Using this button no log files or status information of jobs is displayed but the status of the data or log area. This is the same information as in transaction DB50 -> current state -> memory areas -> data/log area

back to top

What happens when I press 'Refresh'?

SAP basis release 3.1I to 4.6B, 4.6C SP < 51 and 4.6D SP < 42

• Performs load_r3tab which loads
  • file dbm.knl into table CNHIST
  • file dbm.utl into table CNREPRT
• Reads information from tables CNHIST (Backup History) and SDBAADAUPD (Update Statistics, DB Structure Checks) again.

SAP basis release 4.6C SP >= 51, 4.6D SP >= 42, 6.10 SP < 44, 6.20 SP < 53, 6.40 SP < 13

• Reads information directly from file dbm.knl (function module SAPDB_DB_GETF reads the file from the database server with dbmrfc function DBM_GETFILE) and and from table SDBAADAUPD again.

SAP basis release 6.10 SP >= 44, 6.20 SP >= 53, 6.40 SP >= 13

• For actions of the basis database of the SAP System: function module UPDATE_SDBAHSDB_SDB is called, which:
  • loads data of file DBAHIST into table SDBAHSDB (backup actions, verify with dbmcli, ....)
  • loads update statistics entries of SDBAH into SDBAHSDB
  • loads update statistics and verify entries of SDBAADAUPD into SDBAHSDB

back to top

Further information

As you can see, transaction DB12 reads the displayed information form different tables and log files. How this information gets into these tables and log files is described on page DB13 - detailed information - as the actions which generate this information can be scheduled there.
Further information about the dbahist directory can be found on page DBA History.

back to top