The DBMSGDB2 table in SAP ERP or S/4HANA stores DB2/390 System Check Messages data. There are total 14 fields in DBMSGDB2 table. The DB2/390 System Check Messages table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DBMSGDB2 table. It is in CCMS for DB2 for OS/390 (STU2) ABAP package and is part of the DB2 for z/OS (BC-DB-DB2) module.
SAP DBMSGDB2 Table Fields
Following is the list of fields that are available in SAP DBMSGDB2 table. The primary key fields of DB2/390 System Check Messages table in SAP are CHECKCLASS (DB2 for OS/390 check class for system check), CHECKNAME (DB2 for OS/390 DB system check – name of a check), CHKDATE (DB2 for OS/390: Date of the check), CHKTIME (DB2 for OS/390: Time of the check), ERRNO (DB2 for OS/390: Number of error reported by DB system check).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CHECKCLASS | DB2 for OS/390 check class for system check | DB2CKCLASS | CHAR (4) | |
| CHECKNAME | DB2 for OS/390 DB system check – name of a check | DB2CHKNAME | CHAR (50) | |
| CHKDATE | DB2 for OS/390: Date of the check | DB2CHKDATE | DATS (8) | |
| CHKTIME | DB2 for OS/390: Time of the check | DB2CHKTIME | TIMS (6) | |
| ERRNO | DB2 for OS/390: Number of error reported by DB system check | DB2ERRNO | NUMC (5) | |
| OBJECTTYPE | DB2 for OS/390: Type of object checked in DB system check | DB2CHKOBJ | CHAR (4) | |
| OBJQUAL1 | DB2 for OS/390: Qualifier of check object | DB2CHKQUAL | CHAR (50) | |
| OBJQUAL2 | DB2 for OS/390: Qualifier of check object | DB2CHKQUAL | CHAR (50) | |
| OPERATOR | DB2 for OS/390: check operator (system check) | DB2CKOP | CHAR (2) | |
| CHECKVALUE | DB2 for OS/390: Parameter value in DB system check | DB2CHKVAL_REC | CHAR (50) | |
| UNIT | Unit of Check Value | CHKUNIT | CHAR (1) | |
| SEVERITY | DB2 for OS/390: Severity of error detected | DB2CHKSEV | CHAR (1) | |
| ERRORTXT | DB2 OS/390: Description of error reported by DB system check | DB2CHKDESC | CHAR (80) | |
| CORRTXT | DB2 OS/390: corrective action for error in DB system check | DB2CHKCORR | CHAR (80) |
