| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDB2 for OS39 |
1 | DB2CCDAILY | List of TS/IXS needing utility treatment (DSNACCOR Daily) | 7 | IXNAME | Name of a DB2 for OS/390 index | nvarchar | 18 | 0 | | |
2 | DB2CCDAILYX | List of TS/IXS needing utility treatment (DSNACCOX Daily) | 7 | IXNAME | DB2 long index name | nvarchar | 128 | 0 | | |
3 | DB2CCHOUR | List of TS/IXS needing utility treatment (DSNACCOR Hourly) | 7 | IXNAME | Name of a DB2 for OS/390 index | nvarchar | 18 | 0 | | |
4 | DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes | 2 | IXNAME | Name of a DB2 for OS/390 index | nvarchar | 18 | 0 | | |
5 | DB2DB02IXSIZE | Tx DB02: List of indexspace datasets | 2 | IXNAME | Name of a DB2 for OS/390 index | nvarchar | 18 | 0 | | |
6 | DB2DB02IX_SUM | Tx DB02: Summary of Index info. Partitions are summed up | 2 | IXNAME | Name of a DB2 for OS/390 index | nvarchar | 18 | 0 | | |
7 | DB2REOIX | REORG of Indexes | 2 | IXNAME | Name of a DB2 for OS/390 index | nvarchar | 18 | 0 | | |
TOPLogical Database Builder |
8 | IXDIT | Index Directory Texts | 5 | IXNAME | Index name | nvarchar | 18 | 0 | | |