Connection to CCMS 

SAPDBA records changes to the database due to reorganization, extension, or creation of a tablespace, resetting or restoring and recovering a database not only in the main log reorg<DBSID>.log , but also in database tables SDBAH and SDBAD. These details can therefore also be shown in CCMS. Please use the online help of the Computing Center Management System for detailed information on using CCMS.

SDBAH and SDBAD are also used by the SAP utilities BRBACKUP and BRARCHIVE (see BRBACKUP, BRARCHIVE, and BRRESTORE Logs).

Furthermore, the results of the analyses (Compute/Estimate statistics, validate structure) are stored in the relevant database tables, so that these statistics can also be viewed from CCMS.

These database tables should only be supplemented or changed by the SAP utilities SAPDBA, BRBACKUP, and BRARCHIVE, or by the CCMS of the R/3 System.

The information from the main log, for example, are stored in the following fields of SDBAH and SDBAD (the following is background information of interest to the DBA and given here for the sake of completeness. CCMS presents this data in a more user-friendly way, so that exact knowledge of the structure of these tables is not required):

Database Tables SDBAH and SDBAD

Table

Fields

Contents of the fields when used by SAPDBA

SDBAH

BEG

BEGIN

 

FUN

FID

 

OBJ

OBJECT

 

RC

RC

 

ENDE

END

 

ACTID

LOG_TIME

     

SDBAD

BEG

BEGIN

 

FUN

FID

 

POS

D(ata)/I(ndex)

 

LINE

MODE SIZE_B SIZE_A SIZE_T Number_of_rows Error

 

See also Computing Center Management System.