SAP Table DBMSGDB2

DB2/390 System Check Messages

DBMSGDB2 (DB2/390 System Check Messages) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DBMSGDB2 to other SAP tables.

DBMSGDB2 table fields

Field Data element Checktable Datatype Length Decimals
CHECKCLASS DB2 for OS/390 check class for system check DB2CKCLASS CHAR 4 0
CHECKNAME DB2 for OS/390 DB system check - name of a check DB2CHKNAME CHAR 50 0
CHKDATE DB2 for OS/390: Date of the check DB2CHKDATE DATS 8 0
CHKTIME DB2 for OS/390: Time of the check DB2CHKTIME TIMS 6 0
ERRNO DB2 for OS/390: Number of error reported by DB system check DB2ERRNO NUMC 5 0
OBJECTTYPE DB2 for OS/390: Type of object checked in DB system check DB2CHKOBJ CHAR 4 0
TS Tablespace
TB Table
IX Index
PARM Installation parameter
CLAS Check class
OBJQUAL1 DB2 for OS/390: Qualifier of check object DB2CHKQUAL CHAR 50 0
OBJQUAL2 DB2 for OS/390: Qualifier of check object DB2CHKQUAL CHAR 50 0
CURRVALUE CHAR 50 0
OPERATOR DB2 for OS/390: check operator (system check) DB2CKOP CHAR 2 0
== equal to
<> not equal to
< less than
<= less than or equal to
> greater than
>= greater than or equal to
>< between
CHECKVALUE DB2 for OS/390: Parameter value in DB system check DB2CHKVAL_REC CHAR 50 0
UNIT Unit of Check Value CHKUNIT CHAR 1 0
K Kilo
M Mega/Minutes
G Giga
P Percentage
S Seconds
H Hours
D Days
R Rate
SEVERITY DB2 for OS/390: Severity of error detected DB2CHKSEV CHAR 1 0
E Error
W Warning
I Information
ERRORTXT DB2 OS/390: Description of error reported by DB system check DB2CHKDESC CHAR 80 0
CORRTXT DB2 OS/390: corrective action for error in DB system check DB2CHKCORR CHAR 80 0