SAP ABAP Table DB2_VIEW_DB02_OVERVIEW (DB2: structure for VIEW_DATA of DB2_ACTION_DB02_Overview)

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_VIEW_DB02_OVERVIEW	Table Relationship Diagram
Short Description	DB2: structure for VIEW_DATA of DB2_ACTION_DB02_Overview

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	DETAILS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
2	HISTORY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
3	SUBSYSTEM	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
4	ICON_1	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
5	ICON_2	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
6	ICON_3	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
7	ICON_4	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
8	GENERAL_INFO	☐	DB2_DB02_GENERAL_DATA		STRU	0	0
9	TOTAL_SPACE	☐	DB2SIZEMB		DEC	16	0	Size in MB
10	TOTAL_FREE	☐	DB2SIZEMB		DEC	16	0	Size in MB
11	SYSTEM_TYPE	☐	DB2SYSTYPE		CHAR	30	0	DB2 system type
12	CURR_SCHEMA	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
13	DETAIL_TAB	☐	DB2_SUBSYSTEM_DETAILS_TAB		STRU	0	0
14	#TAB	☐	INT4	INT4	INT4	10	0	Natural number
15	#TS	☐	INT4	INT4	INT4	10	0	Natural number
16	#IX	☐	INT4	INT4	INT4	10	0	Natural number
17	#AUX	☐	INT4	INT4	INT4	10	0	Natural number
18	TOTAL_TS	☐	DB2SIZEMB		DEC	16	0	Size in MB
19	TOTAL_IX	☐	DB2SIZEMB		DEC	16	0	Size in MB
20	TOTAL_AUX	☐	DB2SIZEMB		DEC	16	0	Size in MB
21	FREE_TS	☐	DB2SIZEMB		DEC	16	0	Size in MB
22	FREE_IX	☐	DB2SIZEMB		DEC	16	0	Size in MB
23	FREE_AUX	☐	DB2SIZEMB		DEC	16	0	Size in MB
24	HISTORY_TAB	☐	DB2_DB02_HISTORY_STRUCTURE		STRU	0	0
25	IT_OBJ	☐	DB2_DB02_HISTORY_TAB		TTYP	0	0
26	FROM_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
27	TO_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
28	RANGE	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
29	RANGE_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0
30	RANGE_PREV	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
31	HIST_KEEP_DAYS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
32	HIST_KEEP_WEEKS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
33	HIST_KEEP_MONTHS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
34	IT_SUBSYSTEM	☐	DB2_SUBSYSTEM_VIEW_TAB		TTYP	0	0
35	SMS_TAB	☐	DB2_DB02_SMS_DATA_TAB		STRU	0	0
36	IT_SMS	☐	DB2_SMS_DATA_TAB		TTYP	0	0
37	FROM_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
38	TO_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
39	RANGE	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
40	RANGE_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0
41	RANGE_PREV	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
42	HIST_KEEP_DAYS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
43	HIST_KEEP_WEEKS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
44	HIST_KEEP_MONTHS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
45	OBJECT_NAME	☐	DB2FIELDNAME		CHAR	30	0	fieldname (of structure etc.)
46	OBJECT_TYPE	☐	DB2SMS_OBJTYP		CHAR	13	0	sms object type
47	OBJECT_TYPE_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0
48	RB_SNAP	☐	DB2FLAG		CHAR	1	0	c1 flag
49	RB_HIST	☐	DB2FLAG		CHAR	1	0	c1 flag

History

Last changed by/on	SAP	20141013
SAP Release Created in