Data Element list used by SAP ABAP Table DB2TSDETLP (Detailed Information on a Partition of a DB2 Tablespace)
SAP ABAP Table
DB2TSDETLP (Detailed Information on a Partition of a DB2 Tablespace) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CARD | Number of rows in the tablespace or partition | ||
| 2 | DB2CMPRESS | Indicates whether the COMPRESS attribute is YES | ||
| 3 | DB2CREATPI | Authorization ID of the creator of the partitioned index | ||
| 4 | DB2DBNAME | Database name | ||
| 5 | DB2FARINDR | Number of rows relocated far from their original page | ||
| 6 | DB2FREEPG | Number of pages loaded before a page is left as free space | ||
| 7 | DB2GBPCACH | Group buffer pool cache option | ||
| 8 | DB2NEARIND | Number of rows relocated near their original page | ||
| 9 | DB2PARTNRS | Partition number | ||
| 10 | DB2PCTFRES | Percentage of each page left as free space | ||
| 11 | DB2PERCACT | Percentage of space occupied by rows of active tables | ||
| 12 | DB2PGSAVE | Percentage of pages saved in the TS because of compression | ||
| 13 | DB2PIXNAME | Name of the partitioned index | ||
| 14 | DB2SPACE | Number of KB of DASD Storage Allocated to Tablespace | ||
| 15 | DB2STATSTM | Date and time of last RUNSTATS | ||
| 16 | DB2STOGRP | Name of the storage group used for space allocation | ||
| 17 | DB2TSNAME | Name of the tablespace | ||
| 18 | DB2VCAT | Name of the integrated catalog facility catalog |