SAP ABAP Table DB2TSDETLP (Detailed Information on a Partition of a DB2 Tablespace)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Table Category | INTTAB | Structure |
| Structure | DB2TSDETLP |
Table Relationship Diagram 
|
| Short Description | Detailed Information on a Partition of a DB2 Tablespace |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  NAME |
DB2TSNAME | CHAR8 | CHAR | 8 | 0 | Name of the tablespace | ||
| 2 | DBNAME |
DB2DBNAME | D2DBNAME | CHAR | 8 | 0 | Database name | ||
| 3 | PART |
DB2PARTNRS | DB2SINT | INT2 | 5 | 0 | Partition number | ||
| 4 | IXNAME |
DB2PIXNAME | CHAR18 | CHAR | 18 | 0 | Name of the partitioned index | ||
| 5 | IXCREATOR |
DB2CREATPI | DB2CREATOR | CHAR | 8 | 0 | Authorization ID of the creator of the partitioned index | ||
| 6 | STORNAME |
DB2STOGRP | CHAR8 | CHAR | 8 | 0 | Name of the storage group used for space allocation | ||
| 7 | VCATNAME |
DB2VCAT | CHAR8 | CHAR | 8 | 0 | Name of the integrated catalog facility catalog | ||
| 8 | CARD |
DB2CARD | INT4 | 10 | 0 | Number of rows in the tablespace or partition | |||
| 9 | FARINDREF |
DB2FARINDR | INT4 | 10 | 0 | Number of rows relocated far from their original page | |||
| 10 | NEARINDREF |
DB2NEARIND | INT4 | 10 | 0 | Number of rows relocated near their original page | |||
| 11 | PERCACTIVE |
DB2PERCACT | DB2SINT | INT2 | 5 | 0 | Percentage of space occupied by rows of active tables | ||
| 12 | FREEPAGE |
DB2FREEPG | DB2SINT | INT2 | 5 | 0 | Number of pages loaded before a page is left as free space | ||
| 13 | PCTFREE |
DB2PCTFRES | DB2SINT | INT2 | 5 | 0 | Percentage of each page left as free space | ||
| 14 | COMPRESS |
DB2CMPRESS | CHAR1 | CHAR | 1 | 0 | Indicates whether the COMPRESS attribute is YES | ||
| 15 | PAGESAVE |
DB2PGSAVE | DB2SINT | INT2 | 5 | 0 | Percentage of pages saved in the TS because of compression | ||
| 16 | STATSTIME |
DB2STATSTM | DB2TMSTMP | CHAR | 26 | 0 | Date and time of last RUNSTATS | ||
| 17 | SPACE |
DB2SPACE | DB2SPACE | INT4 | 10 | 0 | Number of KB of DASD Storage Allocated to Tablespace | ||
| 18 | GBPCACHE |
DB2GBPCACH | DB2GBPCACH | CHAR | 1 | 0 | Group buffer pool cache option |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 710 |
