| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | RSDB2NLS_QUEUE | DB2-z/OS HiPe NLS: Partitions waiting for archiving | 3 | PARTITIONS | HiPe-NLS: List of partitions (comma separated) | nvarchar | 80 | 0 | | |
| TOPData Staging |
| 2 | RSODPSEL | Operational Data Provider: Query and Load Selections | 5 | PARTITIONS | | ntext | 1073741823 | 0 | | |
| TOPDB2 for OS39 |
| 3 | DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes | 6 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | | |
| 4 | DB2DB02IXSIZE | Tx DB02: List of indexspace datasets | 8 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | | |
| 5 | DB2DB02IX_SUM | Tx DB02: Summary of Index info. Partitions are summed up | 7 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | | |
| 6 | DB2DB02TBSIZE | Transaction DB02: List of tables and tablespace (Details) | 7 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | | |
| 7 | DB2DB02TSSIZE | Transaction DB02: List of tablespace datasets | 7 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | | |
| 8 | DB2DB02TS_HIS | Tx DB02: Short history of TS info | 5 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | | |
| 9 | DB2DB02TS_SUM | Tx DB02: Summary of TS info. Partitions are summed up | 6 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | | |
| 10 | DB2IXBACK | List of indexes that need a backup | 24 | PARTITIONS | Number of partitions of the tablespace or indexspace | smallint | 5 | 0 | | |
| 11 | DB2TSBACK | List of tablespaces that need a backup | 15 | PARTITIONS | Number of partitions of the tablespace or indexspace | smallint | 5 | 0 | | |
| 12 | DB2TSSIZE_T | DB2/390: Storage Information on R/3 Tablespaces | 3 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | | |
