SAP ABAP Table DB2DB02SUMMARY (Tx DB02: Summary information on first screenincl. size histo)

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	DB2DB02SUMMARY	Table Relationship Diagram
Short Description	Tx DB02: Summary information on first screenincl. size histo

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	REFRDATE	☑	DB2DB02DAT	DATUM	DATS	8	0	Date of last refresh of transaction DB02
2	REFRTIME	☑	DB2DB02TIM	TIME	TIMS	6	0	Time of the last refresh of transaction DB02
3	DBSYS	☐	SYDBSYS	SYCHAR10	CHAR	10	0	Central Database System
4	SYSID	☐	DB2SYSIDS		CHAR	103	0	Concatenation of SAP system IDs in an DB2 subsystem
5	R3SIZE	☐	DB2R3SIZT	DEC14	DEC	14	0	Total size allocated by the R/3 System (KB)
6	R3FREE	☐	DB2R3FREET	DEC14	DEC	14	0	Total free space in the R/3 System (KB)
7	R3PCTUSED	☐	DB2R3PCTU	DEC5	DEC	5	0	Percentage of used size to allocated size of the R/3 System
8	TSNUM	☐	DB2TSNUM	DEC08	DEC	8	0	Number of tablespaces in the R/3 system
9	TSSIZE	☐	DB2TSSIZT	DEC13	DEC	13	0	Total size of all R/3 tablespaces (allocated storage in kB)
10	TSFREE	☐	DB2TSFREET	DEC13	DEC	13	0	Total free size of all R/3 tablespaces in KB
11	TSPCTUSED	☐	DB2TSPCTUT	DEC3	DEC	3	0	Percentage of used size to allocated size of all tablespaces
12	IXNUM	☐	DB2IXNUM	DEC08	DEC	8	0	Number of indexes in the R/3 system
13	IXSIZE	☐	DB2IXSIZT	DEC13	DEC	13	0	Total size of all R/3 indexes (allocated storage in kB)
14	IXFREE	☐	DB2IXFREET	DEC13	DEC	13	0	Total free size of all R/3 indexes in KB
15	IXPCTUSED	☐	DB2IXPCTUT	DEC3	DEC	3	0	Percentage of used size to allocated size of all indexes
16	TBNUM	☐	DB2TBNUM	DEC08	DEC	8	0	Number of tables in the R/3 system
17	TBSIZE	☐	DB2TBSIZT	DEC13	DEC	13	0	Total size of all R/3 tables (used storage in KB)
18	TBMISSDB	☐	DB2TBMISDB	DEC08	DEC	8	0	Number of tables missing in the database
19	IXMISSDB	☐	DB2IXMISDB	DEC08	DEC	8	0	Number of indexes missing in the database
20	TBMISSDDIC	☐	DB2TBMISDD	DEC08	DEC	8	0	Number of tables missing in the ABAP/4 dictionary
21	IXMISSDDIC	☐	DB2IXMISDD	DEC08	DEC	8	0	Number of indexes missing in the ABAP dictionary

History

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