SAP DB2 Universal Database for UNIX / NT Tables
Are you looking for the right table related to SAP DB2 Universal Database for UNIX / NT Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in DB2 Universal Database for UNIX / NT (BC-DB-DB6) module.
Top 10 tables in DB2 Universal Database for UNIX / NT
| Table | Description |
|---|---|
| DBSTATHDB6 | DB6: Statistical History of Application Monitor |
| DB6PMHXP | DB6: Detail Record of Tablespace and DB Space Statistics |
| DB6PMHXPHD | DB6: Summary Record of Tablespace And DB Space Statistics |
| DB6PMCK_P | DB6: All Backed Up Tablespaces of History File |
| DB6_MDC_ADV_STAT | DB6 MDC Advisor: Status Table |
| DB6MON | DB6: Datacluster for monitor reset data |
| LADB6 | DB6: Tablespaces for LOB data |
| DB6PMHXTHD | DB6: Summary Rec. of Tablespace and DB Table/Index Stats |
| DB6_MDC_ADV_TSHL | DB6 MDC Advisor: Save Query and TempTab Thresholds |
| DB6JOBTAB | DB6: parallel processing of tables through jobs |
List of tables in DB2 Universal Database for UNIX / NT
| Table | Description |
|---|---|
| DBSTATHDB6 | DB6: Statistical History of Application Monitor |
| DB6PMHXP | DB6: Detail Record of Tablespace and DB Space Statistics |
| DB6PMHXPHD | DB6: Summary Record of Tablespace And DB Space Statistics |
| DB6PMCK_P | DB6: All Backed Up Tablespaces of History File |
| DB6_MDC_ADV_STAT | DB6 MDC Advisor: Status Table |
| DB6MON | DB6: Datacluster for monitor reset data |
| LADB6 | DB6: Tablespaces for LOB data |
| DB6PMHXTHD | DB6: Summary Rec. of Tablespace and DB Table/Index Stats |
| DB6_MDC_ADV_TSHL | DB6 MDC Advisor: Save Query and TempTab Thresholds |
| DB6JOBTAB | DB6: parallel processing of tables through jobs |
| DB6TREORG | DB6: Database REORG Check Information: Tables |
| DB6_MDC_ADV_TMPT | DB6 MDC Advisor: Storage of temporary BW tables |
| DBSTATIDB6 | DB6: Statistics for Indexes (Application Monitor) |
| DB6_BW_HEALTH | DB6: Results of BW Health Checks |
| DB6PM_TIME | DB6: Protocol Record of Statistical Data Collection |
| DB6PMHT | DB6: Detail Record of Table and Index Space Statistics |
| DBSTATTDB6 | DB6: Table Statistics for Application Monitor |
| DB6_OPTPROFILE | Optimizer Profiles for SQL Statements |
| DB6PMSQ_DBS | DB6: Temporary database store for SQL Cache |
| DB6_RESET_DATA | DB6: Datacluster for monitor reset data |
| DB6_MDC_ADV_RES | DB6 MDC Advisor: Result Table |
| DB6PMHSD | DB6: Database Performance Statistics History |
| DB6IREORG | DB6: Database REORG Check Information: Indexes |
| DB6_PC_INTENDED | DB6: Approved Deviations from Parameter Check |
| DB6PMHSB | DB6: Buffer Pool Statistics History |
| DB6_MDC_ADV_PART | DB6 MDC Advisor: Table for Restriction on PARTTIM |
| DB6PMHCDM | DB6: Database and Database Manager Parameter Changes |
| DB6INSPECT | DB6: DB2INSPECT Results |
| TSDB6 | DB6: Table With Tablespaces Allowed for DB2 Universal Databa |
| DB6PMHST | DB6: Snapshot Table History |
| TADB6 | DB6: Current DB2 UDB Tablespaces (Mapp.: Table Type->Table C |
| DB6PMHT_HD | DB6: Summary Record of Table and Index Space Statistics |
| DB6PMHXT | DB6: Detail Record of Tablespace and DB Table/Index Stats |
| IADB6 | DB6: Table Type -> Index for DB2 Universal Database |
| DB6HISTBS | DB6: Cumulated Table-Specific Snapshot Data |
| DB6GSDTBS | DB6: Cumulated Table-Specific Snapshot Data |
| DB6PM_DLK | DB6: Table to Store the Output of Detected Deadlocks |
| DB6CSTRACE | DB6: Results Table for DB6 CS Trace (Cumulative DBSL Trace) |