SAP DB2 for AS/400 Tables
Are you looking for the right table related to SAP DB2 for AS/400 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 for AS/400 (BC-DB-DB4) module.
Top 10 tables in DB2 for AS/400
| Table | Description |
|---|---|
| DBSTATIDB4 | Index Sizes in the Database |
| SQ3000_DB4 | iSeries: Table Scans (Database Monitor) |
| DB4_CLUSTER | iSeries: Temporary Statistics Data |
| DB4BACKUP | Store DB4 Backup Data |
| DB4OX | iSeries: CCMS Object Existence Check |
| DB4TABLE_STAT | Table Sizes in the Database |
| SQ3004_DB4 | iSeries: Temporary Files (Database Monitor) |
| SQ1000_DB4 | iSeries: SQL Information (Database Monitor) |
| SQ3001_DB4 | iSeries: Used Indexes (Database Monitor) |
| SQHVAR_DB4 | iSeries: Host Variable Values for Most Exp. Exec. of a Stmt. |
List of tables in DB2 for AS/400
| Table | Description |
|---|---|
| DBSTATIDB4 | Index Sizes in the Database |
| SQ3000_DB4 | iSeries: Table Scans (Database Monitor) |
| DB4_CLUSTER | iSeries: Temporary Statistics Data |
| DB4BACKUP | Store DB4 Backup Data |
| DB4OX | iSeries: CCMS Object Existence Check |
| DB4TABLE_STAT | Table Sizes in the Database |
| SQ3004_DB4 | iSeries: Temporary Files (Database Monitor) |
| SQ1000_DB4 | iSeries: SQL Information (Database Monitor) |
| SQ3001_DB4 | iSeries: Used Indexes (Database Monitor) |
| SQHVAR_DB4 | iSeries: Host Variable Values for Most Exp. Exec. of a Stmt. |
| DBSTAIHDB4 | History of Index Sizes in the Database |
| SQ1000_RST | iSeries: SQL Information (Database Monitor ) |
| SQ3007_DB4 | iSeries: Optimizer Timed Out (Database Monitor) |
| DBSTATHDB4 | History of Table Sizes in the Database |
| SQTEXT_DB4 | iSeries: SQL Statement Text (Database Monitor) |
| SQ3002_DB4 | iSeries: Created Indexes (Database Monitor) |
| SQ3008_DB4 | iSeries: Subqueries (Database Monitor) |
| DB4INDEX_STAT | Index Sizes in the Database |
| DB4INDEX_HIST | History of Index Sizes in the Database |
| SQ3003_DB4 | iSeries: Sorts (Database Monitor) |
| DB4TABLE_HIST | History of Table Sizes in the Database |
| DBSTATTDB4 | Table Sizes in the Database |