SAP ABAP Table DB2_DB02_TAB_TS_DETAILS (general data for 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	INTTAB	Structure
Structure	DB2_DB02_TAB_TS_DETAILS	Table Relationship Diagram
Short Description	general data for tablespaces

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	NUM_PART	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
2	OBJECT_TYPE	☐	DB2TSTYPE		CHAR	20	0	TS: Type of object
3	SPACE_TYPE	☐	DB2TSTYPE		CHAR	20	0	TS: Type of object
4	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
5	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
6	BPOOL	☐	DB2BPNAME	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
7	PGSIZE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
8	NTABLES	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
9	SEGSIZE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
10	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
11	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
12	ALTEREDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
13	MAXROWS	☐	DB2MROW	DB2MROW	INT2	5	0	Maximum number of rows that DB2 will place on a data page
14	DSSIZE	☐	INT4	INT4	INT4	10	0	Natural number
15	AVGROWLEN	☐	INT4	INT4	INT4	10	0	Natural number
16	MAXPARTITIONS	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)

History

Last changed by/on	SAP	20130604
SAP Release Created in