| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | DBNAME | Database name | nvarchar | 8 | 0 | CHAR | (N' ') | No | | DB2DBNAME | Allow NULL? |
| 2 | TSNAME | Name of the tablespace | nvarchar | 8 | 0 | CHAR | (N' ') | No | | DB2TSNAME | Allow NULL? |
| 3 | STORDATE | Date when the storage information has been collected | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DB2STODATE | Allow NULL? |
| 4 | STORTIME | Time when the storage information has been collected | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | DB2STOTIME | Allow NULL? |
| 5 | CREATOR | DB2 creator name | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | DB2CREATOR | Allow NULL? |
| 6 | PARTITIONS | Number of partitions of a tablespace or index | smallint | 5 | 0 | INT2 | ((0)) | Yes | | DB2NUMPART | |
| 7 | MAX_EXTENTS | Maximum number of extents of a partition of the TS or IX | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2MAXEXTS | Allow NULL? |
| 8 | SUM_EXTENTS | Total number of extents of a TS or index (parts summed up) | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2SUMEXTS | Allow NULL? |
| 9 | SUM_DASD_USAGE | Actual DASD usage (in KB) of TS (sum of partitions) | float | 15 | 16 | FLTP | ((0)) | Yes | | DB2DASD_USE_SUM | |
| 10 | SUM_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | decimal | 11 | 0 | DEC | ((0)) | Yes | | DB2TSSIZ | |
| 11 | SUM_FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | decimal | 11 | 0 | DEC | ((0)) | Yes | | DB2TSFREE | |
| 12 | PCTUSED | Percentage of used size to allocated size of a tablespace | decimal | 3 | 0 | DEC | ((0)) | Yes | | DB2TSPCTU | |
| 13 | RTS_LAST_REORG | Timestamp of last REORG | nvarchar | 26 | 0 | CHAR | (N' ') | Yes | | DB2CCOTIME | Allow NULL? |
| 14 | RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | float | 15 | 16 | FLTP | ((0)) | Yes | | DB2RTSTOTALROWS | |
| 15 | RTS_CHANGES | REO.:Changed rows (insert, delete or update) absolute number | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2CCRCHGA | Allow NULL? |
| 16 | RTS_REORG_RECS | DB2/zOS: Number of REORG recommendations by DSNACCOR | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2CCREORGRECS | Allow NULL? |
| 17 | BASE_TS_DBNAME | Database name | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | DB2DBNAME | Allow NULL? |
| 18 | BASE_TS_TSNAME | Name of the tablespace | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | DB2TSNAME | Allow NULL? |
