| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDB2 for OS39 |
1 | DB2CCACCOR | Parameters of Control Center stored procedure DSNACCOR | 25 | EXTENTS | Number of allowable dataset extents | int | 10 | 0 | | |
2 | DB2CCACCOX | Parameters stored procedure DSNACCOX | 34 | EXTENTS | Number of allowable dataset extents | int | 10 | 0 | | |
3 | DB2CCDAILY | List of TS/IXS needing utility treatment (DSNACCOR Daily) | 15 | EXTENTS | Extentlimit was exceeded: YES or NO | nvarchar | 3 | 0 | | |
4 | DB2CCDAILYX | List of TS/IXS needing utility treatment (DSNACCOX Daily) | 19 | EXTENTS | Extentlimit was exceeded: YES or NO | nvarchar | 3 | 0 | | |
5 | DB2CCHOUR | List of TS/IXS needing utility treatment (DSNACCOR Hourly) | 15 | EXTENTS | Extentlimit was exceeded: YES or NO | nvarchar | 3 | 0 | | |
6 | DB2DB02EXTENTS | Tx DB02: Data for DB02's Extent Monitor | 9 | EXTENTS | Number of extents | int | 10 | 0 | | |
7 | DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes | 7 | EXTENTS | Number of extents | int | 10 | 0 | | |
8 | DB2DB02IXSIZE | Tx DB02: List of indexspace datasets | 10 | EXTENTS | Number of extents | int | 10 | 0 | | |
9 | DB2DB02TSDYN | Tx DB02: Dynamics of the size of tablespaces | 5 | EXTENTS | Number of extents | int | 10 | 0 | | |
10 | DB2DB02TSSIZE | Transaction DB02: List of tablespace datasets | 9 | EXTENTS | Number of extents | int | 10 | 0 | | |
11 | DB2DB02TS_HIS | Tx DB02: Short history of TS info | 6 | EXTENTS | Number of extents | int | 10 | 0 | | |
12 | DB2IXBACK | List of indexes that need a backup | 29 | EXTENTS | Number of extents of a tablespace | int | 10 | 0 | | |
13 | DB2TSBACK | List of tablespaces that need a backup | 33 | EXTENTS | Number of extents of a tablespace | int | 10 | 0 | | |
14 | DB2TSSIZE_T | DB2/390: Storage Information on R/3 Tablespaces | 6 | EXTENTS | Total number of extents of a tablespace or index | decimal | 5 | 0 | | |
TOPPerformance Monitors TCC |
15 | ORA_DBA_SEGMENTS | Copy of DBA_SEGMENTS (currently not provided with snapshots) | 11 | EXTENTS | Oracle monitoring: Number of extents allocated to segment | decimal | 22 | 0 | | |