SAP ABAP Table DB2DB02TSSIZE (Transaction DB02: List of tablespace datasets)

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DB2DB02TSSIZE	Table Relationship Diagram
Short Description	Transaction DB02: List of tablespace datasets

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	DBNAME	☑	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
2	TSNAME	☑	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
3	PART_EXTENSION	☑	DB2PARTEXT		INT4	10	0	Extension or Partition (non-partitioned TS) number
4	STORDATE	☑	DB2STODATE	DATUM	DATS	8	0	Date when the storage information has been collected
5	STORTIME	☑	DB2STOTIME	TIME	TIMS	6	0	Time when the storage information has been collected
6	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
7	PARTITIONS	☐	DB2NUMPART	DB2SINT	INT2	5	0	Number of partitions of a tablespace or index
8	DSNAME	☐	DB2DSNAME	DB2CHAR44	CHAR	44	0	Dataset name
9	EXTENTS	☐	DB2NUMEXTI		INT4	10	0	Number of extents
10	DASD_USAGE	☐	DB2DASD_USAGE		INT4	10	0	Actual DASD usage (in KB) of dataset
11	ALLOCSIZE	☐	DB2TSSIZP	DEC11	DEC	11	0	Allocated storage of a partition of a tablespace in KB
12	FREESIZE	☐	DB2TSFREEP	DEC11	DEC	11	0	Free size of partition of a tablespace in KB
13	PCTUSED	☐	DB2TSPCTU	DEC3	DEC	3	0	Percentage of used size to allocated size of a tablespace
14	PQTY	☐	DB2PQTY		INT4	10	0	Primary space allocation
15	SQTY	☐	DB2SQTY		INT4	10	0	Secondary space allocation
16	QTYUNIT	☐	DB2QTYUNIT	DB2QTYUNIT	CHAR	8	0	Unit in which primary and secondary allocation are given

History

Last changed by/on	SAP	20130604
SAP Release Created in	700