SAP DB2 for z/OS Tables
Are you looking for the right table related to SAP DB2 for z/OS 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 z/OS (BC-DB-DB2) module.
Top 10 tables in DB2 for z/OS
| Table | Description |
|---|---|
| DB2CCDL_PARMS | DSNACCDL: History of execution parameters for DB13 jobs |
| DB2TBLX | RFC - Table Extents |
| DB2ALERTSLIMITS | Table needed for collecting data for DB2 limits alert monit. |
| DB2LRUR | RFC - Long Running URs |
| DB2CCHOUR | List of TS/IXS needing utility treatment (DSNACCOR Hourly) |
| DBSTAIHDB2 | DB2/390 Statistics for Indexes |
| DB2TREORG | Information for Database reorgcheck: Tables |
| IADB2 | DB2/390: TABART <-> Index storage parameters |
| DB2LOGS | RFC - Active Log Shortage |
| DB2CCMO_PARMS | History of execution parameters for DB13 jobs via DSNACCMO |
List of tables in DB2 for z/OS
| Table | Description |
|---|---|
| DB2CCDL_PARMS | DSNACCDL: History of execution parameters for DB13 jobs |
| DB2TBLX | RFC - Table Extents |
| DB2ALERTSLIMITS | Table needed for collecting data for DB2 limits alert monit. |
| DB2LRUR | RFC - Long Running URs |
| DB2CCHOUR | List of TS/IXS needing utility treatment (DSNACCOR Hourly) |
| DBSTAIHDB2 | DB2/390 Statistics for Indexes |
| DB2TREORG | Information for Database reorgcheck: Tables |
| IADB2 | DB2/390: TABART <-> Index storage parameters |
| DB2LOGS | RFC - Active Log Shortage |
| DB2CCMO_PARMS | History of execution parameters for DB13 jobs via DSNACCMO |
| DB2CCMO_OUTTS | History of output table for DB13 jobs executed via DSNACCMO |
| DB2DB02TSDYN | Tx DB02: Dynamics of the size of tablespaces |
| DB2REOIX | REORG of Indexes |
| DB2LODRS | RFC - Deadlock Resources |
| DB2DB02TBSIZE | Transaction DB02: List of tables and tablespace (Details) |
| DB2DB02TBTOPGROW | Tx DB02: Top Twenty of table growth for fast access |
| DB2RFCCONN | RFC - Connection |
| DB2DB02MISSOBJ | Tx DB02: Missing objects |
| DB2UTILS_OUT | History of output table for DB13 jobs executed via DSNUTILS |
| DB2BPTUNE | DB2/390: Buffer Pool Tuning Settings |
| TPDB2 | DB2/390: Pagesize <-> table storage parameters |
| DB2DB02TS_HIS | Tx DB02: Short history of TS info |
| DB2IREORG | Information for Database Reorgcheck: Indexes |
| DB2LODLK | RFC - Deadlock Table |
| DB2CCMO_IN2 | History of input table 2 for DB13 jobs executed via DSNACCMO |
| SDBADDB2 | Detail Table for DBA Logs |
| DB2JSTATUS | Status of Submitted JCL Jobs |
| DB2CCACCOR | Parameters of Control Center stored procedure DSNACCOR |
| DB2DB02TSSIZE | Transaction DB02: List of tablespace datasets |
| DBSTATTDB2 | DB2/390 Statistics for Tables |
| DB2JSINF | Header Table of JCL Administration |
| DB2DB02CONTROL | Control table for information in DB02 |
| STU3COTABC | Definition of DB2 OS/390 and OS/390 Commands(Customer Table) |
| DB2CCDS_PARMS | DSNACCDS: History of execution parameters for DB13 jobs |
| IGDB2 | DB2/390: TABKAT <-> Index storage parameters |
| STU3COTABS | Definition of DB2 for OS/390 and OS/390 Commands (SAP Table) |
| DB2DB02TS_SUM | Tx DB02: Summary of TS info. Partitions are summed up |
| DBMSGDB2 | DB2/390 System Check Messages |
| TADB2 | DB2/390: TABART <-> Table storage parameters |
| DB2CCMO_IN1 | History of input table 1 for DB13 jobs executed via DSNACCMO |
| DB2LOTHW | RFC - Timeout Waiter and Holder |
| DB2MISC | Miscellaneous CCMS on DB2 for z/OS settings and properties |
| DB2NORUN | Exclude table spaces from RUNSTATS ALL |
| DB2CONVTOOL | DB2 z/OS: Recommendations for data conversions |
| DB2CCMO_ERROR | DSNACCMO: History of error info with length > 255 CHAR |
| DBSYCHKDB2 | DB2/390: Global Information for Database System Check |
| DB2JOB | JCL Jobs for OS/390 |
| DB2DB02IX_SUM | Tx DB02: Summary of Index info. Partitions are summed up |
| TGDB2 | DB2/390: TABKAT <-> Table storage parameters |
| DB2JU | TSO User on OS/390 |
| DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes |
| DB2MON | DB2/390 Monitor Table |
| DB2TSBACK | List of tablespaces that need a backup |
| DBCHECKDB2 | Configuration of DB2/390 System Check Parameters |
| DD12DB2 | DB2/390: Index Parameters |
| DB2CCACCOX | Parameters stored procedure DSNACCOX |
| DB2CCDL_OUTTS | DSNACCDL: History of output table |
| DB2DB02VOLFREE | Tx DB02: Volume freespace list |
| DB2TSSIZE_T | DB2/390: Storage Information on R/3 Tablespaces |
| DB2LOTRS | RFC - Timeout Resources |
| DB2COPYI | DB2 copy information from SYSIBM.SYSCOPY |
| DB2CCDS_IN | DSNACCDS: History of input table for DB13 jobs |
| DB2CCMO_OBJERR | DSNACCMO: History of failed utility executions |
| DB2DB02IXSIZE | Tx DB02: List of indexspace datasets |
| DB2UTILS_PARMS | History of execution parameters for DB13 jobs via DSNUTILS |
| DB2DB02SUMMARY | Tx DB02: Summary information on first screenincl. size histo |
| DB2CCDAILYX | List of TS/IXS needing utility treatment (DSNACCOX Daily) |
| DB2DB02TBDYN | Tx DB02: Dynamics of the size of tables |
| DB2ZPARMCONFIG | ZPARM Configuration Table |
| DB2JOBIDMAP | Maps JCL Job ID for backwards compatibility with FTP JES ID |
| DB2NETSTATS | Contains network statistics collected by DB2 Connect |
| DB2IXBACK | List of indexes that need a backup |
| DBSTATIDB2 | DB2/390 Statistics for Indexes |
| DBSTATHDB2 | DB2/390 Statistics for Tables (History) |
| DD02DB2 | DB2/390: Table Parameters |
| DB2CCDAILY | List of TS/IXS needing utility treatment (DSNACCOR Daily) |
| DB2LSCONFIG | DB2 Landscape Tool Configuration |
| DB2REOTS | REORG of Tablespaces |
| DB2SAPSYS | SAP systems located in one DB2 subsystem |
| DB2UTPARM | DB2/390: Parameters for DB2 Utilities |
| DB2_OPTIM_PROFIL | Configuration table for statement profiles |
| DB2DB02EXTENTS | Tx DB02: Data for DB02's Extent Monitor |