SAP ABAP Table DB2TSSIZE_T (DB2/390: Storage Information on R/3 Tablespaces)

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	DB2TSSIZE_T	Table Relationship Diagram
Short Description	DB2/390: Storage Information on R/3 Tablespaces

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	TSNAME	☑	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
2	DBNAME	☑	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
3	PARTITIONS	☐	DB2NUMPART	DB2SINT	INT2	5	0	Number of partitions of a tablespace or index
4	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
5	DSNAME	☐	DB2DSNAME	DB2CHAR44	CHAR	44	0	Dataset name
6	EXTENTS	☐	DB2NUMEXT5	DEC5	DEC	5	0	Total number of extents of a tablespace or index
7	ALLOCSIZE	☐	DB2TSSIZ	DEC11	DEC	11	0	Total size of a tablespace (allocated storage in KB)
8	FREESIZE	☐	DB2TSFREE	DEC11	DEC	11	0	Free size of a tablespace in KB (allocated minus used stor.)
9	PCTUSED	☐	DB2TSPCTU	DEC3	DEC	3	0	Percentage of used size to allocated size of a tablespace
10	MAX_EXTENTS	☐	DB2MAXEXTS		INT4	10	0	Maximum number of extents of a partition of the TS or IX
11	PQTY	☐	DB2PQTY		INT4	10	0	Primary space allocation
12	SQTY	☐	DB2SQTY		INT4	10	0	Secondary space allocation
13	QTYUNIT	☐	DB2QTYUNIT	DB2QTYUNIT	CHAR	8	0	Unit in which primary and secondary allocation are given
14	STORDATE	☐	DB2STODATE	DATUM	DATS	8	0	Date when the storage information has been collected
15	STORTIME	☐	DB2STOTIME	TIME	TIMS	6	0	Time when the storage information has been collected

History

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