The DB2NORUN table in SAP ERP or S/4HANA stores Exclude table spaces from RUNSTATS ALL data. There are total 2 fields in DB2NORUN table. The Exclude table spaces from RUNSTATS ALL 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 DB2NORUN 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 DB2NORUN Table Fields
Following is the list of fields that are available in SAP DB2NORUN table. The primary key fields of Exclude table spaces from RUNSTATS ALL table in SAP are DBNAME (Database name), TSNAME (Name of the tablespace).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| DBNAME | Database name | DB2DBNAME | CHAR (8) | |
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR (8) |


