SAP BW DB2 for OS/390 Tables
Are you looking for the right table related to SAP BW DB2 for OS/390 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 BW DB2 for OS/390 (BW-SYS-DB-DB2) module.
Top 10 tables in BW DB2 for OS/390
| Table | Description |
|---|---|
| RSDB2A_PENDING | DB2 Accelerator: Pending table loads |
| RSDAREFTABDB2_OU | DB2-z/OS HiPe NLS: Template for version table |
| RSDB2A_TABSTAT | DB2 Accelerator: Table statistics (load and read) |
| RSDB2A_STA_STD | DB2 Accelerator: current table data status in accelerator |
| RSDB2A_STA_FCT | DB2 Accelerator: data status of fact tables |
| RSDB2A_SKEWDATA | DB2 Accelerator: Skew data |
| RSDB2A_CTRLTXT | DB2 Accelerator: language dependent texts |
| RSDB2A_ACCELPROP | DB2 Accelerator: Accelerator properties |
| RSDB2A_SETTINGS | DB2 Accelerator: Settings |
| RSDB2LOCKTABLE | Lock Table for DB2-z/OS Tables |
List of tables in BW DB2 for OS/390
| Table | Description |
|---|---|
| RSDB2A_PENDING | DB2 Accelerator: Pending table loads |
| RSDAREFTABDB2_OU | DB2-z/OS HiPe NLS: Template for version table |
| RSDB2A_TABSTAT | DB2 Accelerator: Table statistics (load and read) |
| RSDB2A_STA_STD | DB2 Accelerator: current table data status in accelerator |
| RSDB2A_STA_FCT | DB2 Accelerator: data status of fact tables |
| RSDB2A_SKEWDATA | DB2 Accelerator: Skew data |
| RSDB2A_CTRLTXT | DB2 Accelerator: language dependent texts |
| RSDB2A_ACCELPROP | DB2 Accelerator: Accelerator properties |
| RSDB2A_SETTINGS | DB2 Accelerator: Settings |
| RSDB2LOCKTABLE | Lock Table for DB2-z/OS Tables |
| RSDB2STAR_TABDEP | STAR aggregates: Tables referred to by chache ID |
| RSDB2A_CTRLINFO | DB2 Accelerator: control center table info |
| RSDB2STAR_IPROV | STAR aggregates: InfoProvider mapping & entryno maintenance |
| RSDB2NLS_QUEUE | DB2-z/OS HiPe NLS: Partitions waiting for archiving |
| RSDB2STAR_LOG | STAR aggregates: log |
| RSDB2STAR_CACHID | DB2 STAR aggregates: Current cache ID |
| RSDB2NLS_CONTROL | DB2-z/OS HiPe NLS: Table of Content |
| RSDB2A_STAT | DB2 Accelerator: Load statistics |
| RSDB2NLS_CHKRSLT | DB2-z/OS HiPe NLS: Check results |
| RSDB2A_SKEWADMIN | DB2 Accelerator: Skew monitor administrative data |
| RSDB2A_EXCLUDE | DB2 Accelerator: tables excluded |
| RSDB2A_JOB | DB2 Accelerator: currently running load jobs |
| RSDB2STAR_DIR | DB2 STAR aggregates: directory |
| RSDB2STAR_QUERY | STAR aggregates: Current cache ID |
| RSDAREFTABDB2_OR | DB2-z/OS HiPe NLS: Template for reqstate table |
| RSDB2A_STATUS | DB2 Accelerator: current table data status in accelerator |
| RSDB2A_STA_HIE | DB2 Accelerator: hierarchy status table |
| RSDB2NLS_TEMPBUF | DB2-z/OS HiPe NLS: Directory of IN list substitution tables |
| RSDB2STAR_LOCK | STAR aggregates: Database lock on hash key |
| RSDB2A_CONTROL | DB2 Accelerator: conrol center TOC |
| RSDB2FEMSTAB | DB2-z/OS: Table for FEMSn resolution |
| RSDB2A_UTIL | DB2 Accelerator: Utilization |