| 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 | PART_NR | Partition number | smallint | 5 | 0 | INT2 | ((0)) | No | | DB2PARTNRS | |
| 4 | CREATOR | DB2 creator name | nvarchar | 8 | 0 | CHAR | (N' ') | No | | DB2CREATOR | Allow NULL? |
| 5 | EXTENTS | Number of extents | int | 10 | 0 | INT4 | ((0)) | No | | DB2NUMEXTI | Allow NULL? |
| 6 | D_EXTENTS | Number of extents: change per day | int | 10 | 0 | INT4 | ((0)) | No | | DB2CHGEXDI | Allow NULL? |
| 7 | W_EXTENTS | Number of extents: change per week | int | 10 | 0 | INT4 | ((0)) | No | | DB2CHGEXWI | Allow NULL? |
| 8 | M_EXTENTS | Number of extents: change per month | int | 10 | 0 | INT4 | ((0)) | No | | DB2CHGEXMI | Allow NULL? |
| 9 | ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | decimal | 11 | 0 | DEC | ((0)) | No | | DB2TSSIZ | |
| 10 | D_ALLOCSIZ | Allocated storage in KB: change per day | decimal | 11 | 0 | DEC | ((0)) | No | | DB2CHGSIZD | |
| 11 | W_ALLOCSIZ | Allocated storage in KB: change per week | decimal | 11 | 0 | DEC | ((0)) | No | | DB2CHGSIZW | |
| 12 | M_ALLOCSIZ | Allocated storage in KB: change per month | decimal | 11 | 0 | DEC | ((0)) | No | | DB2CHGSIZM | |
| 13 | FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | decimal | 11 | 0 | DEC | ((0)) | No | | DB2TSFREE | |
| 14 | D_FREESIZ | Free storage (allocated minus used) in KB: change per day | decimal | 11 | 0 | DEC | ((0)) | No | | DB2CHGFRED | |
| 15 | W_FREESIZ | Free storage (allocated minus used) in KB: change per week | decimal | 11 | 0 | DEC | ((0)) | No | | DB2CHGFREW | |
| 16 | M_FREESIZ | Free storage (allocated minus used) in KB: change per month | decimal | 11 | 0 | DEC | ((0)) | No | | DB2CHGFREM | |
| 17 | RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | float | 15 | 16 | FLTP | ((0)) | No | | DB2RTSTOTALROWS | |
| 18 | D_TOTALROWS | Number of Rows: changes per day | float | 15 | 16 | FLTP | ((0)) | No | | DB2CHGROWD | |
| 19 | W_TOTALROWS | Number of Rows: changes per week | float | 15 | 16 | FLTP | ((0)) | No | | DB2CHGROWW | |
| 20 | M_TOTALROWS | Number of Rows: changes per month | float | 15 | 16 | FLTP | ((0)) | No | | DB2CHGROWM | |
