SAP ABAP Table DB2_VIEW_JOBPROFILE (DB2: Structure for VIEW_DATA of DB2_ACTION_JOBPROFILE)

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_JOBPROFILE	Table Relationship Diagram
Short Description	DB2: Structure for VIEW_DATA of DB2_ACTION_JOBPROFILE

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	JOB_PROFILE	☐	DB2_JOBPROFILE_DATA		STRU	0	0
2	DB2_LOAD_LIB	☐			CHAR	43	0
3	DB2_RUN_LIB	☐			CHAR	43	0
4	PLANTIAD	☐			CHAR	8	0
5	KEEP_DAYS	☐			NUMC	4	0
6	HLQ	☐			CHAR	17	0
7	HIGHLQ_WORK	☐			CHAR	17	0
8	JOB_RESULTS	☐			CHAR	3	0
9	MGMTCLAS	☐			CHAR	20	0
10	STORCLAS	☐			CHAR	20	0
11	DATACLAS	☐			CHAR	20	0
12	VOLCNT	☐			NUMC	3	0
13	PDEG	☐			NUMC	3	0
14	SLOW	☐			NUMC	3	0
15	SMED	☐			NUMC	3	0
16	SHIGH	☐			NUMC	3	0
17	SAMP	☐			NUMC	3	0
18	SAMPLE_TYPE	☐			CHAR	6	0
19	CLIM	☐			NUMC	3	0
20	CPDEG	☐			NUMC	3	0
21	O	☐			CHAR	1	0
22	RDEG	☐			NUMC	3	0
23	WD	☐			NUMC	3	0
24	PDSU	☐			CHAR	50	0
25	PLAN_ACT	☐			CHAR	6	0
26	HASP	☐			CHAR	50	0
27	CONS	☐			CHAR	50	0
28	EXT_HIGH	☐			CHAR	3	0
29	EXT_LOW	☐			CHAR	3	0
30	RUNST_UPD	☐			CHAR	3	0
31	CARDFS	☐			NUMC	8	0
32	NPAG_W	☐			NUMC	5	0
33	CARDS	☐			NUMC	8	0
34	NACT_S	☐			NUMC	8	0
35	NACT_W	☐			NUMC	5	0
36	RUNSTALLID	☐			CHAR	7	0
37	RUNALLMEMN	☐			CHAR	7	0
38	RUNSTONEID	☐			CHAR	7	0
39	RUNONEMEMN	☐			CHAR	8	0
40	RUNSTALRID	☐			CHAR	7	0
41	RUNALRMEMN	☐			CHAR	8	0
42	RECOVIXID	☐			CHAR	7	0
43	RECIXMEMN	☐			CHAR	8	0
44	RECOVTSID	☐			CHAR	7	0
45	RECTSMEMN	☐			CHAR	8	0
46	REBUIIXID	☐			CHAR	7	0
47	REBIXMEMN	☐			CHAR	8	0
48	REOALLIXID	☐			CHAR	7	0
49	REOALLIXMEMN	☐			CHAR	7	0
50	REORGIXID	☐			CHAR	7	0
51	REOIXMEMN	☐			CHAR	8	0
52	REOALLTSID	☐			CHAR	7	0
53	REOALLTSMEMN	☐			CHAR	7	0
54	REOALLTSLOB	☐			CHAR	7	0
55	REOALLTSCOPY	☐			CHAR	7	0
56	REORGTSID	☐			CHAR	7	0
57	REOTSMEMN	☐			CHAR	8	0
58	FICOPYID	☐			CHAR	7	0
59	FICOPYMEMN	☐			CHAR	7	0
60	IICPYSYSMEMN	☐			CHAR	8	0
61	IICOPYID	☐			CHAR	7	0
62	IICOPYMEMN	☐			CHAR	7	0
63	FICPYSYSMEMN	☐			CHAR	8	0
64	UPDCATALID	☐			CHAR	7	0
65	UPDCATALMEMN	☐			CHAR	8	0
66	STOPROC	☐			CHAR	3	0
67	GDG_GENERATIONS	☐	DB2GDG_GENERATIONS		INT4	10	0	Number of GDG generations
68	MOD_REC_AGE	☐	DB2MOD_REC_AGE		INT4	10	0	AGE parameter of MODIFY RECOVERY utility
69	MOD_STAT_AGE	☐	DB2MOD_STAT_AGE		INT4	10	0	AGE parameter of MODIFY STATISTICS utility
70	RESTART_OPT	☐	DB2RESTART	DB2RESTART	CHAR	8	0	Whether & at which point a current utility job is restarted
71	DB20_DATA	☐			CHAR	3	0
72	RUNSTATS_CATALOG	☐			CHAR	3	0
73	SP_USER	☐			CHAR	15	0
74	COPY_ALL	☐			CHAR	4	0
75	COPY_PART	☐			CHAR	3	0
76	BW_REO_RST	☐			CHAR	3	0
77	REORG_OTHERS	☐			CHAR	3	0
78	RUNST_OTHERS	☐			CHAR	3	0
79	DEFAULT_PRIQTY	☐			INT4	10	0
80	DEFAULT_SECQTY	☐			INT4	10	0
81	MAXPRIME	☐			NUMC	10	0
82	BSDS	☐			CHAR	44	0
83	USE_ADMIN_SP	☐			CHAR	3	0
84	NPAGES	☐			CHAR	40	0
85	COL_DEST	☐			CHAR	40	0
86	ACCOR_CALLER	☐	DB2_ACCOR_CALLER		CHAR	4	0	Transaction name of caller of DSNACCOR / DSNACCOX
87	CONVTOOL_OBJECTS	☐			INT4	10	0
88	HSM_JOBNAME	☐	DB2JESJOBID	CHAR8	CHAR	8	0	z/OS JES Job ID
89	JOB_RESULT_ALL_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
90	JOB_RESULT_3RD_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
91	LOW_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
92	MEDIUM_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
93	HIGH_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
94	SUBMIT_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
95	UPLOAD_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
96	RUNST_NOUPD_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
97	RUNST_UPD_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
98	REORG_COPY_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
99	REORG_BOTH_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
100	REORG_BW_REO_RST_CHECKBOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
101	REORG_NO_LOB_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
102	REORG_ALL_TS_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
103	REORG_ONLY_LOB_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
104	SP_PROTECT_SKEL_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
105	SP_CHANGE_SKEL_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
106	USE_ADMIN_SP_CHECKBOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
107	COPY_ALL_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
108	COPY_JAVA_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
109	COPY_ABAP_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
110	COPY_PART_CHECKBOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
111	COLLECT_DB20_DATA_CHECKBOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
112	RUNSTATS_ON_CATALOG_CHECKBOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
113	REORG_OTHERS_CHECKBOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
114	RUNST_OTHERS_CHECKBOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
115	SECURITY_CONNECT_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
116	SECURITY_ADMIN_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
117	SECURITY_USER_RADIO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
118	TSOBOX	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
119	SSID_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0
120	SSID	☐	DB2_LPAR_SSID	CHAR4	CHAR	4	0	Subsystem ID of DB2 system
121	PW_ID1_TXT	☐	DB2CCPSW	CHAR8	CHAR	8	0	User pword
122	PW_ID2_TXT	☐	DB2CCPSW	CHAR8	CHAR	8	0	User pword
123	PSW_SET_ICON	☐			CHAR	29	0
124	SECURITY_USER_NAME	☐	DB2TSOUSER		CHAR	7	0	z/OS TSO User
125	SELECTED_USER	☐	DB2TSOUSER		CHAR	7	0	z/OS TSO User
126	ACCOR_CALLER_CHECKBOX	☐			CHAR	1	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	703