Logging Information in CCMS
Definition
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
central log reorg<DBSID>.log, but also in database tables SDBAH and SDBAD.Use
You can view the details stored in
SDBAH and SDBAD from the Computing Center Management System (CCMS). For more information about CCMS, see
SAP/Oracle DBA in CCMS.
SDBAH
and SDBAD are also used by the SAP utilities BRBACKUP and BRARCHIVE. For more information, see Logs for BRBACKUP, BRARCHIVE, BRRESTORE, and BRCONNECT.The results of the analyses (Compute/Estimate statistics, validate structure) are also stored in the relevant database tables, so that these statistics can also be viewed from CCMS.
It is important that only SAPDBA, BRBACKUP, BRARCHIVE, BRCONNECT, or CCMS writes to these tables.
Structure
The information from the main log, for example, is stored in the following fields of
SDBAH and SDBAD:
The following information is given for completeness. CCMS presents this data in a 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 |