SAP ABAP Table DB2JOBPROFILE (JCL job profiles) - SAP Datasheet

The Best Online SAP Object Repository

Object Hierarchy

Software Component

SAP_BASIS

Application Component ID

BC-DB-DB2

Package

STU2

Object type

Structure

Object name

DB2JOBPROFILE

Using

Data Element (5)

Used by

Program (4)

Advertise Links

SAP ABAP Table DB2JOBPROFILE (JCL job profiles)

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	DB2JOBPROFILE	Table Relationship Diagram
Short Description	JCL job profiles

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Short Description
1	ALREADY_READ			CHAR	1
2	SUBSYSTEM_ID	DB2_LPAR_SSID	CHAR4	CHAR	4	Subsystem ID of DB2 system
3	DB2_LOAD_LIB			CHAR	43
4	DB2_RUN_LIB			CHAR	43
5	PLAN_DSNTIAD			CHAR	8
6	DAYS_TO_KEEP			NUMC	4
7	HIGH_LEVEL_QUAL			CHAR	17
8	HLQ_WORK			CHAR	17
9	JOB_RESULT			CHAR	3
10	SMS_MGMTCLAS			CHAR	20
11	SMS_STORCLAS			CHAR	20
12	SMS_DATACLAS			CHAR	20
13	VOLUME_COUNT			NUMC	3
14	RUNST_PDEG			NUMC	3
15	SAMPLE_LOW			NUMC	3
16	SAMPLE_MED			NUMC	3
17	SAMPLE_HIGH			NUMC	3
18	SAMPLE			NUMC	3
19	SAMPLE_TYPE			CHAR	6
20	CHANGE_LIMIT			NUMC	3
21	COPY_PDEG			NUMC	3
22	OUTCLASS			CHAR	1
23	REORG_RDEG			NUMC	3
24	REORG_WORKDS_SIZE			NUMC	3
25	PDS			CHAR	50
26	PLAN_ACTION			CHAR	6
27	HASPINDX			CHAR	50
28	CONSOLE			CHAR	50
29	EXTENTS_HIGH			CHAR	3
30	EXTENTS_LOW			CHAR	3
31	RUNST_UPDATE			CHAR	3
32	CARDF_SET			NUMC	8
33	NPAGES_SET			NUMC	8
34	NPAGES_SET1			NUMC	8
35	NPAGES_WHERE			NUMC	5
36	NPAGES_WHERE1			NUMC	5
37	NPAGES_WHERE2			NUMC	5
38	NPAGES_WHERE3			NUMC	5
39	CARD_SET			NUMC	8
40	NACTIVE_SET			NUMC	8
41	NACTIVE_WHERE			NUMC	5
42	NACTIVE_WHERE2			NUMC	5
43	CLUSTERRATIO			NUMC	3
44	FIRSTKEYCARDF			NUMC	8
45	FULLKEYCARDF			NUMC	8
46	COLCARDF			NUMC	8
47	FIRSTKEYCARDF_THR			CHAR	5
48	COLCARDF_THR			CHAR	5
49	SAPOSCOLDIR			CHAR	50
50	SAPOSCOLDEST			CHAR	20
51	DBTRCSZ			INT4	10
52	RUNSTALL_JOBNAME			CHAR	7
53	RUNSTALL_MEMNAME			CHAR	7
54	RUNSTONE_JOBNAME			CHAR	7
55	RUNSTONE_MEMNAME			CHAR	8
56	RUNSTALR_JOBNAME			CHAR	7
57	RUNSTALR_MEMNAME			CHAR	8
58	RECOVIX_JOBNAME			CHAR	7
59	RECOVIX_MEMNAME			CHAR	8
60	RECOVTS_JOBNAME			CHAR	7
61	RECOVTS_MEMNAME			CHAR	8
62	REBUIIX_JOBNAME			CHAR	7
63	REBUIIX_MEMNAME			CHAR	8
64	REOALLIX_JOBNAME			CHAR	7
65	REOALLIX_MEMNAME			CHAR	7
66	REORGIX_JOBNAME			CHAR	7
67	REORGIX_MEMNAME			CHAR	8
68	REOALLTS_JOBNAME			CHAR	7
69	REOALLTS_MEMNAME			CHAR	7
70	REOALLTS_LOBHANDLING			CHAR	7
71	REOALLTS_COPYHANDLING			CHAR	7
72	REORGTS_JOBNAME			CHAR	7
73	REORGTS_MEMNAME			CHAR	8
74	FICOPY_JOBNAME			CHAR	7
75	FICOPY_MEMNAME			CHAR	7
76	FSYSCPY_MEMNAME			CHAR	8
77	IICOPY_JOBNAME			CHAR	7
78	IICOPY_MEMNAME			CHAR	7
79	ISYSCPY_MEMNAME			CHAR	8
80	QUIESCE_JOBNAME			CHAR	7
81	QUIESCE_MEMNAME			CHAR	8
82	UPDCATAL_JOBNAME			CHAR	7
83	UPDCATAL_MEMNAME			CHAR	8
84	RUNONETS_TYPE			CHAR	1
85	REBIX_TYPE			CHAR	1
86	FAIL_SUBSYSTEM_ID			CHAR	4
87	FAIL_DB2_LOAD_LIB			CHAR	43
88	FAIL_DB2_RUN_LIB			CHAR	43
89	FAIL_PLAN_DSNTIAD			CHAR	8
90	FAIL_OUTCLASS			CHAR	1
91	USE_SP			CHAR	3
92	SP_GDG_GENERATIONS	DB2GDG_GENERATIONS		INT4	10	Number of GDG generations
93	SP_MOD_REC_AGE	DB2MOD_REC_AGE		INT4	10	AGE parameter of MODIFY RECOVERY utility
94	SP_MOD_STAT_AGE	DB2MOD_STAT_AGE		INT4	10	AGE parameter of MODIFY STATISTICS utility
95	SP_PROTECT_SKEL			CHAR	7
96	SP_RESTART_OPT	DB2RESTART	DB2RESTART	CHAR	8	Whether & at which point a current utility job is restarted
97	COLLECT_DB20_DATA			CHAR	3
98	RUNSTATS_ON_CATALOG			CHAR	3
99	SP_USER			CHAR	15
100	COPY_ALL			CHAR	4
101	COPY_PART			CHAR	3
102	BW_REO_RST			CHAR	3
103	REORG_OTHERS			CHAR	3
104	RUNST_OTHERS			CHAR	3
105	DEFAULT_PRIQTY			INT4	10
106	DEFAULT_SECQTY			INT4	10
107	MAXPRIME			NUMC	10
108	BSDS			CHAR	44
109	USE_ADMIN_SP			CHAR	3