SAP ABAP Table DB2UTILS_PARMS (History of execution parameters for DB13 jobs via DSNUTILS)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2_TR (Package) CCMS on DB2 UDB for OS/390 - to Be Translated

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DB2UTILS_PARMS	Table Relationship Diagram
Short Description	History of execution parameters for DB13 jobs via DSNUTILS

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	BEG	☑	SDBA_BEGIN	SDBA_TSTMP	CHAR	14	0	Start of the DBA action
2	FUNCT	☑	SDBA_FUNCT	SDBA_FUNCT	CHAR	3	0	Function ID for DBA action
3	UTILITY_ID	☐	DB2UTILID	CHAR16	CHAR	16	0	Unique identifier for a utility in DB2
4	RESTART	☐	DB2RESTART	DB2RESTART	CHAR	8	0	Whether & at which point a current utility job is restarted
5	RETCODE	☐	DB2CCUTILSRC		INT4	10	0	DSNUTILS: Highest return code for the utility
6	UTIL_NAME	☐	DB2UTILNAM	DB2UTILNAM	CHAR	20	0	Utility specification
7	RECDSN	☐	DB2RECDSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSREC DDNAME
8	RECDEVT	☐	DB2RECDEVT	DB2DEVT	CHAR	8	0	Device on which the SYSREC dataset resides
9	RECSPACE	☐	DB2RECSPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSREC dataset (cylinders)
10	DISCDSN	☐	DB2DISCDSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSDISC DDNAME
11	DISCDEVT	☐	DB2DISDEVT	DB2DEVT	CHAR	8	0	Device on which the SYSDISC dataset resides
12	DISCSPACE	☐	DB2DISCSPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSDISC dataset (cyl.)
13	PNCHDSN	☐	DB2PNCHDSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSPUNCH DDNAME
14	PNCHDEVT	☐	DB2PNCDEVT	DB2DEVT	CHAR	8	0	Device on which the SYSREC dataset resides
15	PNCHSPACE	☐	DB2PNCHSPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSPNCH dataset (cyl.)
16	COPYDSN1	☐	DB2CP1DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSCOPY DDNAME
17	COPYDEVT1	☐	DB2CP1DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSCOPY dataset resides
18	COPYSPACE1	☐	DB2CP1SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSCOPY dataset (cyl.)
19	COPYDSN2	☐	DB2CP2DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSCOPY2 DDNAME
20	COPYDEVT2	☐	DB2CP2DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSCOPY2 dataset resides
21	COPYSPACE2	☐	DB2CP2SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSCOPY2 dataset (cyl.)
22	RCPYDSN1	☐	DB2RC1DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSRCPY1 DDNAME
23	RCPYDEVT1	☐	DB2RC1DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSRCPY1 dataset resides
24	RCPYSPACE1	☐	DB2RC1SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSRCPY1 dataset (cyl.)
25	RCPYDSN2	☐	DB2RC2DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSRCPY2 DDNAME
26	RCPYDEVT2	☐	DB2RC2DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSRCPY2 dataset resides
27	RCPYSPACE2	☐	DB2RC2SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSRCPY2 dataset (cyl.)
28	MAPDSN	☐	DB2MAPDSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSMAP DDNAME
29	MAPDEVT	☐	DB2MAPDEVT	DB2DEVT	CHAR	8	0	Device on which the SYSMAP dataset resides
30	MAPSPACE	☐	DB2MAPSPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSMAP dataset (cyl.)
31	ERRDSN	☐	DB2ERRDSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSERR DDNAME
32	ERRDEVT	☐	DB2ERRDEVT	DB2DEVT	CHAR	8	0	Device on which the SYSERR dataset resides
33	ERRSPACE	☐	DB2ERRSPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSERR dataset (Cyl.)
34	WORKDSN1	☐	DB2WK1DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSUT1 DDNAME
35	WORKDEVT1	☐	DB2WK1DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSUT1 dataset resides
36	WORKSPACE1	☐	DB2WK1SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSUT1 dataset (cyl.)
37	WORKDSN2	☐	DB2WK2DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SORTOUT DDNAME
38	WORKDEVT2	☐	DB2WK2DEVT	DB2DEVT	CHAR	8	0	Device on which the SORTOUT dataset resides
39	WORKSPACE2	☐	DB2WK2SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SORTOUT dataset (cyl.)
40	FILTRDSN	☐	DB2FILDSN	DB2FILDSN	CHAR	54	0	Dataset allocated to the FILTER DDNAME
41	FILTRDEVT	☐	DB2FILDEVT	DB2FILDEVT	CHAR	8	0	Device on which the FILTER dataset resides
42	FILTRSPACE	☐	DB2FILSPC	DB2FILSPC	INT2	5	0	Primary space allocation for the SYSERR dataset (Cyl.)
43	LCHAR_LENGTH	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
44	UTSTMT	☐			LCHR	30000	0

History

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