Select data from sap tables DB2_
Display SAP table details
DB2ACCDL - Parameters of Control Center stored procedure DSNACCDL
DB2ACCDS - Parameters of Control Center stored procedure DSNACCDS
DB2ACCELFILTER - filter for Accelarator System Statistics (Q8ST)
DB2ACCJF - Parameters of Control Center stored procedure DSNACCJF
DB2ACCJP - Parameters of Control Center stored procedure DSNACCJP
DB2ACCJS - Parameters of Control Center stored procedure DSNACCJS
DB2ACCMO - Parameters of Control Center stored procedure DSNACCMO
DB2ACCOR - Parameters of Control Center stored procedure DSNACCOR
DB2ACC_FILTER - filter for view_data of cl_db2_accounting_data
DB2ALERT - DB2/390: Alert Tree: Single Messages
DB2ALERTSLIMITS - Table needed for collecting data for DB2 limits alert monit.
DB2APPSERVERS - Name of the application server
DB2ASUTIL - Performance Values for OS/390 Address Spaces
DB2BACKUP - DB2/390: Backup Needed
DB2BASETAB - structure with base and aux table
DB2BPACT - structure for Bufferpools- Bufferpool Activity
DB2BPCTRL - Buffer Pool Table Control
DB2BPDEFAULTS - Defaults for Bufferpools
DB2BPTUNE - DB2/390: Buffer Pool Tuning Settings
DB2BPTUNE1 - DB2/390: Buffer Pool Tuning
DB2CATINX - Info on Indexes from DB2 Catalog Table SYSIBM.SYSINDEXES
DB2CATTAB - Info on Tables from DB2 Catalog Table SYSIBM.SYSTABLES
DB2CCACCOR - Parameters of Control Center stored procedure DSNACCOR
DB2CCACCOX - Parameters stored procedure DSNACCOX
DB2CCDAILY - List of TS/IXS needing utility treatment (DSNACCOR Daily)
DB2CCDAILYX - List of TS/IXS needing utility treatment (DSNACCOX Daily)
DB2CCDLOUT - Output List of CC/390 Stored Procedure DSNACCDL
DB2CCDL_OUTTS - DSNACCDL: History of output table
DB2CCDL_PARMS - DSNACCDL: History of execution parameters for DB13 jobs
DB2CCDSIN - Structure of global temp DS input table DSNACC.DSNRECORDS
DB2CCDS_IN - DSNACCDS: History of input table for DB13 jobs
DB2CCDS_PARMS - DSNACCDS: History of execution parameters for DB13 jobs
DB2CCEXC - Structure of DSNACCOR exception table (EBCDIC)
DB2CCEXCPT - Like DB2CCEX (using the db table colum names for components)
DB2CCHOUR - List of TS/IXS needing utility treatment (DSNACCOR Hourly)
DB2CCJFOUT - Structure of global temp input table DSNACC.JFRECORDS
DB2CCJSTBL - Structure of global temp input table DSNACC.JSRECORDS
DB2CCMOT1 - Structure of global temp input table DSNACC.MO_TBL
DB2CCMOT2 - Structure of global temp input table DSNACC.MO_TBL2
DB2CCMOUT - Output List of CC/390 Stored Procedure DSNACCMO
DB2CCMO_ERROR - DSNACCMO: History of error info with length > 255 CHAR
DB2CCMO_IN1 - History of input table 1 for DB13 jobs executed via DSNACCMO
DB2CCMO_IN2 - History of input table 2 for DB13 jobs executed via DSNACCMO
DB2CCMO_OBJERR - DSNACCMO: History of failed utility executions
DB2CCMO_OUTTS - History of output table for DB13 jobs executed via DSNACCMO
DB2CCMO_PARMS - History of execution parameters for DB13 jobs via DSNACCMO
DB2CCOUT - Output List of Table-/Indexspace of DB2 SP DSNACCOR
DB2CCOUTIX - Output List of index of CC/390 Stored Procedures
DB2CCOUTTS - Output List of Tablespace of CC/390 Stored Procedures
DB2CCOUTX - Output List of Table-/Indexspace of DB2 SP DSNACCOX
DB2CCREORGIX - DB2CCREOIX without keys
DB2CCREORGTS - DB2CCREORG without keys
DB2CCRESTRICT - DB2CCRESTR without keys
DB2CCRUNSTATS - DB2CCRUNST without keys
DB2CHAR18 - Structure for typing internal tables with one column CHAR18
DB2CHAR8 - Structure for typing internal tables with one column CHAR8
DB2CONDESCR - DB2: Description of a database connection
DB2CONGROUPS - Groups of DB2 connections
DB2CONINI - represents the connect.ini file
DB2CONTEND - Structure for ALV grid (History Content end time)
DB2CONTENT - Structure for list of history content
DB2CONTSTR - Structure for ALV grid (History Content start time)
DB2CONVTOOL - DB2 z/OS: Recommendations for data conversions
DB2COPYI - DB2 copy information from SYSIBM.SYSCOPY
DB2CPYTSC - DB2/390: COPY Parameters for Control Center Stored Procedure
DB2CPYTSP - DB2/390: COPY parameters
DB2CQDBPC - Buffer Manager Dynamic Pool Attributes
DB2DATASET - info on datasets
DB2DATETIME - structure for date & time
DB2DATETIMEMSEC - structure for date, time & msec
DB2DB02CONTROL - Control table for information in DB02
DB2DB02EXTENTS - Tx DB02: Data for DB02's Extent Monitor
DB2DB02HISRG - DB02: Time Range of History, used for FuMo interface
DB2DB02IXDYN - Tx DB02: Dynamics of the size of indexes
DB2DB02IXSIZE - Tx DB02: List of indexspace datasets
DB2DB02IX_SUM - Tx DB02: Summary of Index info. Partitions are summed up
DB2DB02LOB - Tx DB02: Info on LOB TS and their base tables
DB2DB02MISSOBJ - Tx DB02: Missing objects
DB2DB02SUMMARY - Tx DB02: Summary information on first screenincl. size histo
DB2DB02TBDYN - Tx DB02: Dynamics of the size of tables
DB2DB02TBSIZE - Transaction DB02: List of tables and tablespace (Details)
DB2DB02TBTOPGROW - Tx DB02: Top Twenty of table growth for fast access
DB2DB02TSDYN - Tx DB02: Dynamics of the size of tablespaces
DB2DB02TSSIZE - Transaction DB02: List of tablespace datasets
DB2DB02TS_HIS - Tx DB02: Short history of TS info
DB2DB02TS_SUM - Tx DB02: Summary of TS info. Partitions are summed up
DB2DB02VOLFREE - Tx DB02: Volume freespace list
DB2DB13C - Structure to allow RFC parameters with DB13C
DB2DBSIZH - DB2/390: History of R/3 System Size (DB02)
DB2DB_POOL_RESTART_IN_DOC - Proxy Structure (generated)
DB2DB_POOL_RESTART_OUT_DOC - Proxy Structure (generated)
DB2DEADLK - RFC - Deadlock Structure
DB2DEADLKC - RFC - Deadlock Structure
DB2DEADLK_TREE - Structure for Deadlocks ALV Tree
DB2DEADRS - RFC - Deadlock Structure Resources, Holder and Waiter
DB2DEADRSC - RFC - Deadlock Structure Resources, Holder and Waiter
DB2DEFCON - Defined DB2 connections (in connect.ini)
DB2DSCFILTER - Statement Cache Filter
DB2DSCHDR - Header for statement cache statistics
DB2DSINFO - Storage and Catalog Information on DB2 Datasets
DB2DSMEM - Information concerning a DB2 data sharing group member
DB2DSNUC - Control Center stored procedures parameters
DB2DSNUP - DB2/390: Parameters Passed to DSNUTILS Stored Procedure
DB2DSSHDR - Header for Data Set Statistics
DB2DSSTOR - Storage Information on Datasets Allocated by DB2
DB2DSVOL - List of Volumes on which R/3 Datasets Reside
DB2EDMPOOL - Data to be displayed
DB2EXTMON - DB2/390: Structure for DB02's Extent Monitor
DB2EXTMONT - DB2/390: Table Control Structure for DB02's Extent Monitor
DB2FREESPACE - structure for obj Information concerning freespace
DB2FUNC_TYPE - structure for getting obj / function types
DB2GET_CONNECTION_URL_IN_DOC - Proxy Structure (generated)
DB2GET_CONNECTION_URL_OUT_DOC - Proxy Structure (generated)
DB2GET_DB_CONNECTIONS_IN_DOC - Proxy Structure (generated)
DB2GET_DB_CONNECTIONS_OUT_DOC - Proxy Structure (generated)
DB2GET_DB_PROPERTY_IN_DOC - Proxy Structure (generated)
DB2GET_DB_PROPERTY_OUT_DOC - Proxy Structure (generated)
DB2GET_NAME_IN_DOC - Proxy Structure (generated)
DB2GET_NAME_OUT_DOC - Proxy Structure (generated)
DB2GLOTIME - DB2 global times with V8
DB2GLOTIMESSUM - Structure for DB2 Subsystem Summary (Global Times)
DB2GRPCONS - Logical connections of a group
DB2HEADER - Misc. data relevant for the common header area
DB2HISTGRD - DB2 for OS/390: Structure for grid history processing
DB2ICLISRV - DB2/390: ICLI Server Information
DB2IFI313 - DB2/390: Structure for Long-Running Units of Recovery
DB2IFI313C - DB2/390: Structure for Long-Running Units of Recovery
DB2IFIDBTI - DB2/390: IFI DB Trace
DB2IFIDBTR - DB2/390: IFI DB Trace
DB2IFIDEST - Parameters for DB2 IFI destinations
DB2IFITRC - DB2/390: IFI Server Information
DB2INDSTOR - Index parameter for DB2/MVS
DB2INT02 - Test Structure for Integer 2
DB2INT2C - Test Structure for Integer 2
DB2IREORG - Information for Database Reorgcheck: Indexes
DB2IXBACK - List of indexes that need a backup
DB2IXDETL - Detailed Information on a DB2 Index
DB2IXDETLP - Detailed Information on a Partition of a DB2 Index
DB2IXDYN - Dynamics of the Size of Indexes
DB2IXDYNT - Template for List Output: Dynamics of Size of Indexes
DB2IXHIS - DB2/390: Storage Information on R/3 Indexes
DB2IXHISRG - Time Range of the History of Index Sizes
DB2IXINFO - Index Info
DB2IXKEY - DB2/390: Description of the Key of an Index
DB2IXSIZE - DB2/390: Storage Information on R/3 Indexes
DB2IXSIZED - DB2/390: Storage Information on Datasets of Indexes
DB2IXSIZENEW - DB2-z/OS: Storage information on SAP indexes
DB2IXSIZEO - DB2/390: Storage information on R/3 indexes
DB2IXSIZEP - DB2/390: Storage Information on Partitions of Tablespaces
DB2IXSIZEV - DB2/390: Storage Information on R/3 Indexes
DB2IXSTRUC - info on index structure
DB2J2EECONS - Groups of DB2 connections
DB2JCLSS - Types of JCL Submission Services
DB2JCLSTAT - Status of JCL utilities
DB2JOB - JCL Jobs for OS/390
DB2JOBIDMAP - Maps JCL Job ID for backwards compatibility with FTP JES ID
DB2JOBPROFILE - JCL job profiles - old structure - use DB2_JOBPROFILE_DATA
DB2JSINF - Header Table of JCL Administration
DB2JSTATUS - Status of Submitted JCL Jobs
DB2JU - TSO User on OS/390
DB2KPIIX - Index Info
DB2KPITABS - DB02 Table List
DB2KPI_FREESPACE - structure for obj Information concerning freespace
DB2KPI_IXLIMITS - structure with infos on ix near DB2 limits
DB2KPI_IXLIST - Index Info
DB2KPI_LARGIX - Info on largest IX
DB2KPI_MULTITS - info on multi table ts
DB2KPI_PARTLIMIT - structure with information on obj. near part limit
DB2KPI_RANGETABS - List of range partitioned tables
DB2KPI_TABLE - Table List for displaying KPIs concerning tables
DB2KPI_TABLIST - DB02 Table List
DB2KPI_TSLIMITS - structure with infos on ts near DB2 limits
DB2KPI_UNENCRYPTED - DB02: KPI: structure unencrypted objects
DB2LOBS - DB02 structure for LOBs
DB2LOCKESCAL - DB2 alert for lock escalations
DB2LOCKESCALATIONS - Structure for Lock Escalations (Fieldcatalog)
DB2LOCKESCPROC - DB2 for z/OS: Postprocessed lock escalations (IFCID 337)
DB2LOCKRES - Resources locked by a thread
DB2LOCKS - Locked DB2-Resources and their Holders and Waiters
DB2LOCKSC - Locked Resources for a Thread
DB2LOCKSH - Locked Resources for a Thread
DB2LOCKSHC - Locked Resources for a Thread
DB2LOCKS_RESOURCE_THREADS - Locked DB2-Resources and their Holders and Waiters
DB2LODLK - RFC - Deadlock Table
DB2LODLKI - RFC - Deadlock Table for ICLI Alert Router
DB2LODRS - RFC - Deadlock Resources
DB2LODRSI - RFC - Deadlock Resources with ICLI Alert Router
DB2LOGS - RFC - Active Log Shortage
DB2LOGSHORT - Srtucture for Active Log Shortage (Fieldcatalog)
DB2LONGRUN - Structure for Long-Running Transactions (Fieldcatalog)
DB2LOTHW - RFC - Timeout Waiter and Holder
DB2LOTHWI - RFC - Timeout Waiter and Holder with ICLI Alert Router
DB2LOTRS - RFC - Timeout Resources
DB2LOTRSI - RFC - Timeout Resources with ICLI Alert Router
DB2LRUR - RFC - Long Running URs
DB2LRURI - RFC - Long Running URs with ICLI Alert Router
DB2LSCONFIG - DB2 Landscape Tool Configuration
DB2MCPTSP - DB2/390: MERGECOPY Parameters
DB2MISC - Miscellaneous CCMS on DB2 for z/OS settings and properties
DB2MON - DB2/390 Monitor Table
DB2MONIKEY - Key for Access to Table MONI
DB2MULTITS_INFO - info on ts
DB2NETSTATS - Contains network statistics collected by DB2 Connect
DB2NETSTATS_FILTER - view structure for network statistics
DB2NETSTATS_MINMAX - structure for min and max values of db2 network statistics
DB2NETSTATS_SAMPLES - values for min / avg / max samples
DB2NETSTR - Structure for network statistics collected by DB2 Connect
DB2NETWSTATS - structure for db2 network statistics - backend class
DB2NORUN - Exclude table spaces from RUNSTATS ALL
DB2NQW03 - Number of Waiters and Holders on a Resource
DB2NQW03C - Number of Waiters and Holders on a Resource
DB2PARAMETER - db2 system parameter
DB2PARAMETER_CHECK - zParms
DB2PARTS - structure for partition info
DB2PINPR - Page-ins per pages read
DB2PMTRC - DB2PM API trace
DB2PROF - Profile parameters for stored procedure SAPCL
DB2PROTOCOL - structure used for DB2 CCMS protocol in function modules
DB2Q3ST - accumulated statistics for SSSS and SSAM resource manager
DB2Q8ST - structure for Q8ST - Accelerator system statistics
DB2Q9ST - command statistical counters
DB2QACCEL - DB2 Accelerator System Statistics
DB2QALRTLOAD - Load table for alert router part of DB2 IFI collector
DB2QBAC - Buffer Pool Statistics Data
DB2QBACT1 - DB2QBACT1
DB2QBGA - DB2/390: Group Buffer Pool for Given Thread
DB2QBGAT - DB2MONI: thread details
DB2QBGAT1 - DB2QBGAT1
DB2QBGB - DB2/390: Group Buffer Pool Parameters
DB2QBGBC -
DB2QBGBT - DB2QBGBT
DB2QBGL - Statistics Group Buffer Pool
DB2QBGLT - DB2QBGLT
DB2QBST - Buffer Manager Statistics Block
DB2QBSTT - DB2 CL - Buffer manager statitics block
DB2QCLDBT - IFI Collector Table
DB2QCLREQ - DB2 CL - Interface
DB2QCLREQE - Extensions to table DB2QCLREQ
DB2QCLTRC - DB2 IF trace
DB2QCMDRA - DB2QCMDRA
DB2QDBP - Buffer Manager Dynamic Pool Attributes
DB2QDBPC - Buffer Manager Dynamic Pool Attributes
DB2QDBPT1 - DB2 for z/OS buffer pool settings
DB2QDSCCONT - Structure describing content of dynamic statement cache
DB2QDSCCONT_V10 - Structure describing content of dynamic statement cache
DB2QDSCHIST - Content of dynamic statement cache history
DB2QDSCHIST_V10 - Content of dynamic statement cache history
DB2QGLOTIME - New Global Times (IFI 369)
DB2QISE - EDM Pool Statistics
DB2QISJ - DB2 star join pool statistics
DB2QIST - DB2/390 Datamanager Statistics
DB2QJST - log manager statitics block
DB2QLODLK - RFC - Deadlock Table
DB2QLODRS - RFC - Deadlock Resources
DB2QLOGS - RFC - Active Log Shortage
DB2QLOTHW - RFC - Timeout Waiter and Holder
DB2QLOTRS - RFC - Timeout Resources
DB2QLRUR - RFC - Long Running URs
DB2QPLANHIST - History plan table
DB2QPROF - Profile parameters for stored procedure SAPCL
DB2QR4H - DB2 for OS/390: Structure for history processing status
DB2QSST - DB2 Perf. Manag. Data: Storage Manager Data
DB2QSTC - Structure for Statement Trace
DB2QSTCC - Structure for Statement Trace
DB2QSYSW1 - Table holding different DB2 IFI statistics values
DB2QSYSW2 - DB2 statistics (part 2)
DB2QTBLX - RFC - Table Extents
DB2QTGA - DB2/390: Data Sharing Locking for Given Thread
DB2QTGS - DB2/390: Statistics Global Locking
DB2QTHDDSC - content dynamic statement cache
DB2QTHDDSC_V10 - content dynamic statement cache
DB2QTHDDTL - DB2MONI: thread details
DB2QTHDLR - DB2 CL - Locked Resources for a thread
DB2QTHDLST - ST04: DB2 thread overview
DB2QTHDTM - DB2QTHDTM
DB2QTIMSTMP - Timestamp for DB2 dynamic statement cache
DB2QTST - service controller statistics block
DB2QTXA - SSC statitics and accounting data mapping
DB2QVLS - Statistics record latch manager
DB2QVLSSEC - Statistics record latch manager: Per Second
DB2QVLSTAB - Statistics record latch manager: table reference
DB2QW0225 - DB2 IFCID 225 - DBM1 virtual storage monitoring
DB2QW0225_V10 - DB2 IFCID 225 - DBM1 virtual storage monitoring
DB2QW0254 - Statistics CF Cache Structure Data
DB2QW0316 - Structure for Statement Trace
DB2QW0317 - dynamic statement cache: SQL STATEMENT
DB2QW199 - DB2 IFI 199 - Data sets statistics
DB2QW225 - IFCID 0225 shows usage of virtual storage of DBM1
DB2QW225_V10 - IFCID 0225 shows usage of virtual storage of DBM1
DB2QWHC - correlation data mapping
DB2QWHCT - Correlation Data Mapping
DB2QWHS - instrumentation header mapping
DB2QWHSC - instrumentation header mapping
DB2QWORKFILES - DB2/390 Datamanager Statistics
DB2QWOS - CPU Utilization and Storage Counters
DB2QWP1 - Installation Parameters (DSN6SYSP)
DB2QWP124 - DB2 V8 additions to QWP1/2/4
DB2QWP1C - Installation Parameters (DSN6SYSP)
DB2QWP2 - Installation Parameter (LOG)
DB2QWP2C - Installation Parameter (LOG)
DB2QWP3 - DB2/OS390 Installation Parameter (Archive)
DB2QWP3C - DB2/OS390 Installation Parameter (Archive)
DB2QWP4 - Instrumentation Mapping for System Initialization Parameter
DB2QWP4C - Instrumentation Mapping for System Initialization Parameter
DB2QWP5 - Instrumentation Mapping for System Initialization Parameter
DB2QWP5C - Instrumentation Mapping for System Initialization Parameter
DB2QWP6 - VSAM Catalog Qualifier Used for Database Dataset (DB2)
DB2QWP6C -
DB2QWP7 - Flag concerning automatic start of DBs during DBM1 startup
DB2QWP8 - Databases to be Started Automatically During DBM1 Startup
DB2QWP8C -
DB2QWP9 - Facility Start Information (DB2 for z/OS)
DB2QWP9C - Facility Start Information (DB2/OS390)
DB2QWPA - Data Sharing Group Initialization Parameters
DB2QWPAC - Data Sharing Group Initialization Parameters
DB2QWPB - Application Programming Defaults (DB2 for OS390)
DB2QWPBC - Application Programming Defaults (DB2 for OS390)
DB2QWPT1 - DB2 installation parameters (sec. part: DB2QWPT2)
DB2QWPT2 - DB2 installation parameters (first part: DB2QWPT1)
DB2QWSA - Statistics records address space data section
DB2QWSD - instrumentation mapping for statistics information
DB2QXST - RDS Statistics Block
DB2RDI - SQL Statement Data
DB2RDIC - SQL Statement Data
DB2REBIDX - DB2/390: REBUILD INDEX Parameters
DB2RECTSP - DB2/390: RECOVER TABLESPACE Parameters
DB2REMOTECON - Remote Connections
DB2REOIDX - REORG INDEX Parameters
DB2REOIX - REORG of Indexes
DB2REOTS - REORG of Tablespaces
DB2REOTSP - REORG TABLESPACE Parameters
DB2RFCCONN - RFC - Connection
DB2RSTLIST - List of tablespaces on which RUNSTATS is to be run
DB2RSTTSP - DB2/390: RUNSTATS TABLESPACE parameters
DB2RSTTSPI - DB2/390: RUNSTATS TABLESPACE INDEX parameters
DB2RSTTSPT - DB2/390: RUNSTATS TABLESPACE TABLE parameters
DB2RUNST - DB2/390: Runstats Needed
DB2SAPCLINST - structure for sapcl installer - landscape tools
DB2SAPSYS - SAP systems located in one DB2 subsystem
DB2SDBAHI - Internal Table for sdba Results used for RFC purposes
DB2SELCHAR - Structure for character field selection
DB2SELDB - Structure for database selection
DB2SELTB - Structure for table selection
DB2SELTS - Structure for tablespace selection
DB2SET_CONNECTION_URL_IN_DOC - Proxy Structure (generated)
DB2SET_CONNECTION_URL_OUT_DOC - Proxy Structure (generated)
DB2SET_DB_PROPERTY_IN_DOC - Proxy Structure (generated)
DB2SET_DB_PROPERTY_OUT_DOC - Proxy Structure (generated)
DB2SPREBIX - REBUILD INDEX Parameters for Stored Procedures
DB2SPRUNTS - RUNSTATS Parameters for Stored Procedures
DB2SPTAB - Structure for space tables that can hold name and partition
DB2SQLLONG - Contains long SQL statement texts
DB2SQLLONGT - Structure to read data from SAPCL table DB2SQLLONG
DB2STATDEC - DB2/390: Buffer Pool Tuning: Table Categorisation
DB2STMT_HIST_FILTER - filter for view_data of cl_db2_stmt_cache_history
DB2SUBSYSSUM - Structure for DB2 Subsystem Summary (All Parameters)
DB2SUSCRN - Fields for DB2 for OS/390 Performance Monitor Subscreen
DB2SUSCRNC - Fields for DB2 for OS/390 Performance Monitor Subscreen
DB2SWPARM - Summary Structure for System-Wide Parameters
DB2SYSLEVELUPDATES - Structure for Table SYSIBM.SYSLEVELUPDATES
DB2SYSPARC - Derived DB2 System Parameters
DB2SYSPARM - Derived DB2 System Parameters
DB2SYSPRNT - DB2/390: Structure of table SYSIBM.SYSPRINT
DB2TABHIST - DB02 Table History
DB2TABIXS - info on index structure
DB2TABLIST - DB02 Table List
DB2TABONL - DB2/390: Screen for Online Space Info on a Table (DB15)
DB2TABSTAT - DB2/390: Screen for Statistical Space Info on a Table (DB15)
DB2TABSTOR - Table parameters for DB2/MVS
DB2TABSTRUC - info on table structure
DB2TBCOLS - DB2/390: Column Definition of a Database Table
DB2TBDETL - Detailed Information on a Table from the DB2 Catalog
DB2TBIXSUM - DB2/390: Initial Screen for Table and Index Monitor (DB02)
DB2TBLIST - DB2/390: List of Tables
DB2TBLX - RFC - Table Extents
DB2TBTAB - Structure for tables that hold tablespace information
DB2TDUMMY - Dummy Structure for Internal Use
DB2THREAD2 -
DB2THREADS - DB2 Performance Monitor: Thread List
DB2TIMEG - DB2 for OS/390 Times over all Threads
DB2TIMEGC - DB2 for OS/390 Times over all Threads
DB2TIMES - DB2 Times
DB2TIMESC - DB2 Times
DB2TIMESC1 - DB2 Times
DB2TIMESD - Thread Activity: Times Distribution
DB2TIMSEL - Structure for TimeSelection
DB2TIOUTHC - Timeout Structure (Holder and Waiter)
DB2TIOUTHW - Timeout Structure (Holder and Waiter)
DB2TIOUTRC - Timeout Structure (Resource and Victim)
DB2TIOUTRS - Timeout Structure (Resource and Victim)
DB2TIOUT_TREE - Structure for Timeouts ALV Tree
DB2TOPSTMTS - Structure for DB2 Subsystem Summary (Top SQL Stmts)
DB2TREORG - Information for Database reorgcheck: Tables
DB2TSBACK - List of tablespaces that need a backup
DB2TSBACKN - Generated Table for View
DB2TSDETL - Detailed Information on a DB2 Tablespace
DB2TSDETLP - Detailed Information on a Partition of a DB2 Tablespace
DB2TSDYN - Dynamics of the Size of Tablespaces
DB2TSDYNO - Dynamics of the size of tablespaces
DB2TSDYNT - Template for List Output: Dynamics of Size of Tablespaces
DB2TSHIS - DB2/390: Storage Information on R/3 Tablespaces
DB2TSHISRG - Time Range of the History of Tablespace Sizes
DB2TSHIS_O - DB2/390: Storage information on R/3 tablespaces
DB2TSINFO - info on ts
DB2TSSIZE - DB2/390: Storage Information on R/3 Tablespaces
DB2TSSIZED - DB2/390: Storage Information on Datasets of Tablespaces
DB2TSSIZEO - DB2/390: Storage information on R/3 tablespaces
DB2TSSIZEP - DB2/390: Storage Information on Partitions of Tablespaces
DB2TSSIZEV - DB2/390: Storage Information on R/3 Tablespaces
DB2TSSIZE_T - DB2/390: Storage Information on R/3 Tablespaces
DB2TSTAB - Structure for tablespace lists that hold DB/TS name
DB2TSVOL - List of Volumes on which the Datasets of a Tablespace Reside
DB2TS_SIZE - DB2/390: Type for int. table of size info of tablespaces
DB2TS_SIZP - DB2/390: Type for int. table of size info of tablespaces
DB2TTLTMS - DB2 for OS/390: Stucture for System Times
DB2UTILS_OUT - History of output table for DB13 jobs executed via DSNUTILS
DB2UTILS_PARMS - History of execution parameters for DB13 jobs via DSNUTILS
DB2UTPARM - DB2/390: Parameters for DB2 Utilities
DB2VCATTAB - DB2/390: List of VCAT Names
DB2VERSION - DB2/390: Input for Function DBSYCHK_COMPARE_VERSION
DB2VOLLST - List of Volumes on which R/3 Objects Reside
DB2VOLLSTF - Free Space on OS/390 DASD
DB2WHERE_S - Line in WHERE Clause
DB2WPDBH - Work process / database handle / connection name mapping
DB2XPLCOLDIST - Internal Structure for DB2 Column Distributions
DB2XPLSTATFEEDBACK - Internal structure for DB2 Statistics feedback
DB2XPLTABSTATS - DB2 Optimizer Table Statistics
DB2ZOSENCR - VSAM catalog w. encryption flag
DB2ZPARMCHECK - structure for inst param check
DB2ZPARMCONFIG - ZPARM Configuration Table
DB2ZPARMS - zParms
DB2ZPARM_TREE - zParms
DB2_ACCEL_PROP - Accelerator properties
DB2_ACCEL_STATIC_INFO - static info about the accelerator
DB2_ACCOUNTING_DATA - Structure for view DB2_ACCOUNTING_DATA
DB2_ACCOUNTING_OVERVIEW - overview tab for accounting data details
DB2_ACCOX_PROFILE - Structure to store input parameter of DB2 SP DSNACCOX
DB2_BACKUP_HISTORY - Used to show DB2 Backup History
DB2_BACKUP_RECOMM - DB2 Backup Recommendation Entry
DB2_BACKUP_STATUS - DB2 Backup Status Entry
DB2_BIND_QUERY_SP_OUTPUT - structure for output of ADMIN_COMMAND_DSN
DB2_BKSYS_HIST_ENTRY - DB2 BACKUP SYSTEM Utility History Entry
DB2_CATALOGSTMT - Catalog Statistic Patch SQL Statement
DB2_CHAR255 - Structure for CHAR255
DB2_CMD_OUT_ROW - DB2 command output row
DB2_COLUMN_DESCRIPTION - DB2 z/Os: Column description of a DB Table
DB2_COL_PROFILE - DB2 SAP Collector Profile to store the Config of db2qprof
DB2_COMP_VERS - component versions
DB2_CONVTOOL_ALL - Recommendations for conversions per object base+detail
DB2_CONVTOOL_ALV - Recommendations for conversions per object excluded+base
DB2_CONVTOOL_BASE - Recommendations for conversions per object base data
DB2_CONVTOOL_DETAIL - Recommendations for conversions per object detail data
DB2_DATA_SLICES - structure for data distribution (data slices) - db level
DB2_DATA_SLICES_TABLES - structure for data distribution (data slices) - table level
DB2_DB02_ALERTS - DB02: Space Overview Alerts status
DB2_DB02_GENERAL_DATA - general data for VIEW_DATA of DB2_ACTION_DB02_Overview
DB2_DB02_HISTORY - DB02: Structure for history of a system
DB2_DB02_HISTORY_STRUCTURE - structure for SAP System Overview history tab
DB2_DB02_IX_DETAILS - DB02: Detail Index Information
DB2_DB02_IX_GEN - general data for indexes
DB2_DB02_IX_HIST - DB02: structure for history of indexes
DB2_DB02_IX_PART_DETAILS - DB02 partition details for indexes
DB2_DB02_IX_STRUCTURE - DB02: Indexes of a table
DB2_DB02_SMS_DATA_TAB - sms info in DB02 (structure for tabstrip)
DB2_DB02_TAB_BASE - structure for db02 tab details base table tab
DB2_DB02_TAB_GEN - general Data for Tables
DB2_DB02_TAB_HISTORY - DB02: structure for history data of a table
DB2_DB02_TAB_LOBS - DB02: structure for LOBs
DB2_DB02_TAB_PARTITIONS - DB02: structure for partition list
DB2_DB02_TAB_PART_DETAILS - DB02 partition details for tables
DB2_DB02_TAB_STRUCTURE - DB02: column structure of a table
DB2_DB02_TAB_TS_DETAILS - general data for tablespaces
DB2_DB02_TAB_XCHG - exchange structure for table details
DB2_DB02_TS_DATASETS - DB02: dataset list for tablespaces
DB2_DB02_TS_DETAILS - DB02 Tablespace Details
DB2_DB02_TS_GEN - general data for tablespaces
DB2_DB02_TS_HISTORY - DB02: structure for history data of tablespaces
DB2_DB02_TS_PARTITIONS - DB02_ structure for partitions in a tablespace
DB2_DB02_TS_PART_DETAILS - DB02 Tablespace Details
DB2_DB02_TS_TABLES - DB02: table list for tablespaces
DB2_DEP_BROWSER_XCHG - exchange structure for dependency browser
DB2_DISPLAY_UTILITY_ENTRY - Output data of DISPLAY UTILITY for one DB2 Utility
DB2_EXCLUDE_TAB - exclude table for function codes in GUI status
DB2_EXPL_MAINT_NOT_UPG - explain_maint_tb_not_upgraded output (ADMIN_EXPLAIN_MAINT)
DB2_EXPL_MAINT_SP_OUTPUT - structure for output of SP ADMIN_EXPLAIN_MAINT
DB2_EXPL_MAINT_SQL - explain_maint_sql_row output (ADMIN_EXPLAIN_MAINT)
DB2_EXPL_MAINT_SUM - explain_maint_summary_row output (ADMIN_EXPLAIN_MAINT)
DB2_EXT_AL - DB2/390 Alert: Too Many Extents
DB2_FAILOVER_AFFLIST - DB2: Failover Configuration: Structure for affinity list
DB2_FAILOVER_CLIENT - DB2: Failover Configuration: Stucture for a client (AS)
DB2_FAILOVER_DB - DB2: Failover Configuration: Structure for different DBs
DB2_FAILOVER_DSN_ELEMENT - DB2: Failover Configuration: Structure for an DSN element
DB2_FAILOVER_PARAMETER - DB2: Failover Configuration: Contains Parameter Name and Val
DB2_FAILOVER_SERVER - DB2: Failover Configuration: Structure for server adresses
DB2_FAILOVER_SERVER_ORDER - DB2: Failover Configuration: Structure for server order
DB2_FAILOVER_TRANSFER - transfer structure for tree data
DB2_FAILOVER_UNPARSED_DATA - DB2: Failover Configuration: Imported, unparsed config file
DB2_GLOTIME - structure for global times - tree (snapshot)
DB2_GLOTIME_HIERARCHY - hierarchy structure for snapshot display
DB2_IDX_COLUMN_DESCRIPTION - DB2 z/Os: Column description of a DB Index
DB2_INDEX_RUNSTATS_OPTIONS - Index Runstats Option
DB2_IX_LIMITS - structure with infos on objects near DB2 limits
DB2_JES_OUTPUT_LIST - Stucture forshowing JES print output under ALV
DB2_JOBPROFILE_DATA - DB2: structure for DB2_Action_Jobprofile all Screen Data
DB2_JOB_CONTROL_JOBS - structure for editing job alv
DB2_KEYVALPAIR - Key-Value Pair
DB2_KEY_DESCR - structure for numeric key - charlike description pairs
DB2_KPI_QBGB - groupbufferpool config data
DB2_KPI_QBGL - groupbufferpool activity data
DB2_KPI_QBST - bufferpool activity data
DB2_KPI_QDBP - Bufferpool config data
DB2_KPI_SPACE_HISTORY - Structure for DB2 KPI SPace History
DB2_LPAR_INFO_ZOS - DB2: LPAR information for z/OS
DB2_LPAR_NAME_STRUC - Structure wrapping an LPAR Name
DB2_MAINT_PATHS - Maintained Access Path
DB2_MESSAGE_TAB - Structure for dynpro header in DB6PLAN --> JCL interface
DB2_MOST_PARTITIONS - structure with information on obj. with most partitions
DB2_MSG_LOG - View data for cl_db2_action_db2_msg
DB2_NEAR_LIMITS - structure with infos on objects near DB2 limits
DB2_OBJ_EXCEPTIONS - DB2 z/OS Objects to be excluded for maintenance jobs
DB2_OPTIM_PROFIL - Configuration table for statement profiles
DB2_RECOM_COPY - Structure for Backup Monitor Recommendation Viewer
DB2_RECOM_REORGIX - Structure for REORGIX Recommendation Viewer
DB2_RECOM_REORGTS - Structure for REORGTS Recommendation Viewer
DB2_RECOM_RUNSTATS - Structure for RUNSTATS Recommendation Viewer
DB2_REORG_EXCEPTION - DB2 z/OS List of excluded partitions from REORG utility
DB2_RSDB2MEPL - Structure for Diagnose Display MEPL
DB2_RUNSTATS_OPTIONS - BW Table Runstats Options
DB2_SHOW_SYSTEM_PARAMETER - Expected and Found Values of DB2 installation Parameters
DB2_SHOW_SYSTEM_PARM_LONG - Output Structure for Dynpro 0100 of Program RSDB2CKRD
DB2_SMS_DATA - sms info in DB02 (Space)
DB2_SMS_SP_OUT - structure for output of SP ADMIN_INFO_SMS
DB2_SNODETEXT - DB2 Deadlocks Output Structure for Display of Details
DB2_SQL_EDITOR_HIST - stmt History for SQL editor
DB2_SUBSYSTEM_DETAILS_TAB - detail structure for VIEW_DATA of DB2_ACTION_DB02_Overview
DB2_SUBSYSTEM_VIEW - DB2: Subsystem View for DB02 (Space)
DB2_SYSINFO - structure for dbcon names and member names
DB2_SYSLOG_ENTRY - DB2:CCMS: Z/OS Syslog entry
DB2_SYSLOG_MULTILINE_MSG - DB2: CCMS: Contains a parsed Multiline Message
DB2_SYSPARM_CONFIG - ZPARM Configuration table
DB2_SYSPARM_ROW - Sysparm structure
DB2_SYSPLEX_INFO_ZOS - DB2: SYSPLEX information for z/OS
DB2_SYSTEM_ENTRY - DBA Cockpit System descriptor
DB2_S_INLINE_LOB - DB2-z/OS: LOB inline length
DB2_TABLESPECL - DB2 Table Identifier (Creator + Tablename)
DB2_TABPART - Table Name withassociated Partitions
DB2_TABPROFILE - DB2 Table Profile Structure
DB2_TEXT_DISPLAY_XCHG_TAB - DBA Cockpit exchange struct to call Text Display Controller
DB2_TSIX - DB2 z/OS Tablespace/Indexspace and Database Names
DB2_TSLIST - Structure for typing int. tables to identify tablespaces
DB2_VIEW_ACCEL_DETAILS - view structure for CL_DB2_ACCEL_DETAILS
DB2_VIEW_ACCEL_STATS - view data for CL_DB2_ACTION_ACCEL_STATISTICS
DB2_VIEW_ACCOX_PROFILE - DB2 View Data for DSNACCOX Profile
DB2_VIEW_ACC_DATA - view data for CL_DB2_ACTION_ACCOUNTING_DATA
DB2_VIEW_ACC_DETAILS - view structure for accounting data details
DB2_VIEW_BACKUP_DETAIL - DB2 Backup Detail
DB2_VIEW_BACKUP_OVERVIEW - Backup Overview
DB2_VIEW_BKSYS_HIST - DB2: View Data for BACKUP SYSTEM
DB2_VIEW_BP - DB2: view data for bufferpools
DB2_VIEW_BP_DET - view data for BP Activity Details
DB2_VIEW_COL_PROFILE - DB2 View Data for SAP Collector Profile
DB2_VIEW_COL_SETTINGS - view structure for CL_DB2_ACTION_COL_SETTINGS
DB2_VIEW_COMP_CHECK - view structure for component check
DB2_VIEW_CONTROLLER - View data for cl_db2_action_controller
DB2_VIEW_CONVTOOL - view data structure for conversion tool overview screen
DB2_VIEW_CONVTOOL_DETAIL - Conversion details per table (new vs. old column type/size)
DB2_VIEW_DB02_FAST_GROW - DB02 view structure for KPI Fastest growing Tables
DB2_VIEW_DB02_IX_LIMITS - DB02 view structure fpr KPI Objects near DB2 Limits
DB2_VIEW_DB02_LARGE_FREE - DB02 view structure for KPI Largest Free Space
DB2_VIEW_DB02_LARGE_IX - DB02 view structure for KIP Largset IX
DB2_VIEW_DB02_LARGE_MULTI - DB02 view structure for KPI Largest Multi-Table TS
DB2_VIEW_DB02_LARGE_TABS - DB02: view data for largest tables
DB2_VIEW_DB02_MOST_PARTS - DB02: View structure for KPI Most Partitions
DB2_VIEW_DB02_OBJ_NEAR_LIMITS - DB02 view structure fpr KPI Objects near DB2 Limits
DB2_VIEW_DB02_OVERVIEW - DB2: structure for VIEW_DATA of DB2_ACTION_DB02_Overview
DB2_VIEW_DB02_RANGE_PARTS - DB02: view data for part. tables
DB2_VIEW_DB02_UNENCRYPTED - DB02 view structure for KPI Unencrypted Space
DB2_VIEW_DEADLOCKS - DB2: view data for deadlocks
DB2_VIEW_DEP - view dependency structure
DB2_VIEW_DEP_DETAILS - view structure for cl_db2_action_view_dep_details
DB2_VIEW_DEP_TREE - structure for dependency tree with type descriptions
DB2_VIEW_DISPLAY_UTILITY - Action Controller data of DISPLAY UTILITY
DB2_VIEW_DLK_DET - View Structure for Deadlock Details
DB2_VIEW_EDMPOOL - View Structure for EDM Pool
DB2_VIEW_FAILOVER_CONFIG - VIEW DATA for db2 Failover configuration
DB2_VIEW_GBP - view data for: DB2 - Performance: Group Bufferpools
DB2_VIEW_GBP_DET - view structure for groupbufferpool activity - details
DB2_VIEW_GLOTIMES - view strructure for performance - global times
DB2_VIEW_GLOTIMES_HIST - view strructure for performance - global times
DB2_VIEW_IDAA_DATA_DISTR - view structure for CL_DB2_ACTION_IDAA_DATA_SLICES
DB2_VIEW_IDAA_DS_DISTR_TABLES - view data for CL_DB2_ACTION_IDAA_DS_TABLES
DB2_VIEW_IFI225 - view structure for performance - virtual / real storage
DB2_VIEW_INST_PARAMS - DB2: view data for installation parameters
DB2_VIEW_INST_PARM_CHECK - view data for inst param check
DB2_VIEW_IX - DB2: structure for VIEW_DATA of DB2_ACTION_DB02_IX
DB2_VIEW_IX_DETAILS - DB2: structure for VIEW_DATA of ..._ACTION_DB02_IX_DETAILS
DB2_VIEW_JOBPROFILE - DB2: Structure for VIEW_DATA of DB2_ACTION_JOBPROFILE
DB2_VIEW_JOB_CONTROL - View structure for CL_DB2_ACTION_JOB_CONTROL
DB2_VIEW_JOB_EDITOR - View structure for CL_DB2_ACTION_JOB_EDITOR
DB2_VIEW_LANDSCAPE_CONFIG - view structure for landscape configuration
DB2_VIEW_LEVELS_OVERVIEW - View Structure for Continuous Delivery Levels
DB2_VIEW_LOCKESCALATIONS - view structure for Lock Escalations
DB2_VIEW_LOGSHORT - view structure for Active Log Shortage
DB2_VIEW_LONG_RUN - view structure for Active Log Shortage
DB2_VIEW_LPAR_DATA - LPAR Data returned by GET_WHOLE_DS_GROUP for dropdown
DB2_VIEW_MAINT_EXCEPT - View Data for Action Maintenance Exception
DB2_VIEW_MAINT_PATHS - view structure for CL_DB2_ACTION_OPT_ACCESS_PATHS
DB2_VIEW_MSG_LOG - View data for cl_db2_action_db2_msg
DB2_VIEW_NETSTATS_DET - view structure for netstats details
DB2_VIEW_NETWORKSTATS - view structure for network statistics
DB2_VIEW_OMPE_CONFIG - view_data for cl_db2_action_ompe_config
DB2_VIEW_OS_CONFIG - View data for OS Monitoring Settings
DB2_VIEW_REORGIX - DB2: structure for VIEW_DATA of DB2_ACTION_REORGIX
DB2_VIEW_REORGTS - DB2: structure for VIEW_DATA of DB2_ACTION_REORGTS
DB2_VIEW_RESTRICTED - DB2: structure for VIEW_DATA of DB2_ACTION_RESTRICTED
DB2_VIEW_RUNSTATS - DB2: structure for VIEW_DATA of DB2_ACTION_RUNSTATS
DB2_VIEW_SAPCL_INST - view structure for Landscape tools - SAPCL Installer
DB2_VIEW_SERVICE_SQL - view structure for CL_DB2_ACTION_SERVICE_SQL
DB2_VIEW_STMT_CACHE - view structure for statement cache overview
DB2_VIEW_STMT_CACHE_DET - view structure for DL_DB2_ACTION_STMT_CACHE_DET
DB2_VIEW_STMT_CACHE_HIST - view structure for statement cache overview
DB2_VIEW_SUBSYS_SUMMARY - View Structure for Subsystem Summary
DB2_VIEW_SYSLOG - DB2:CCMS: Z/OS Syslog view structure
DB2_VIEW_SYSPLEX_MONITOR - DB2: structure for VIEW_DATA of DB2_ACTION_SYSPLEX_MONITOR
DB2_VIEW_TABLES - DB2: structure for VIEW_DATA of DB2_ACTION_DB02_TABLES
DB2_VIEW_TABLE_DETAILS - DB2: structure for VIEW_DATA of ..._ACTION_DB02_TAB_DETAILS
DB2_VIEW_TABPROFILE - DB2 Table Profile View Structure
DB2_VIEW_TEXT_DISPLAY - view structure for text display
DB2_VIEW_TIMEOUTS - DB2: view data for timeouts
DB2_VIEW_TIO_DET - view data structure for timeouts details
DB2_VIEW_TS - DB2: structure for VIEW_DATA of DB2_ACTION_DB02_TS
DB2_VIEW_TS_DETAILS - DB2: structure for VIEW_DATA of ..._ACTION_DB02_TS_DETAILS
DB2_VIEW_VIEW_DEP - view structure for CL_DB2_VIEW_DEPENDENCY
DB2_VIEW_WORKFILES - view structure for performance - workfiles
DB2_WORKFILE - structure for workfile monitoring - tree (snapshot)
DB2_WORKFILE_HIERARCHY - hierarchy structure for snapshot display
DB2_XCHG_LPAR - Exchange data (Sysplex_Monitor -> Sysplex_History)
Return Table index