DB2UTILS_PARMS - History of execution parameters for DB13 jobs via DSNUTILS
History of execution parameters for DB13 jobs via DSNUTILS information is stored in SAP table DB2UTILS_PARMS.
It is part of development package STU2_TR in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS on DB2 UDB for OS/390 - to Be Translated".
It is part of development package STU2_TR in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS on DB2 UDB for OS/390 - to Be Translated".
Fields for table DB2UTILS_PARMS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| BEG | Start of the DBA action | X | SDBA_BEGIN | CHAR | 14 | |
| FUNCT | Function ID for DBA action | X | SDBA_FUNCT | CHAR | 3 | |
| UTILITY_ID | Unique identifier for a utility in DB2 | DB2UTILID | CHAR | 16 | ||
| RESTART | Whether & at which point a current utility job is restarted | DB2RESTART | CHAR | 8 | ||
| RETCODE | DSNUTILS: Highest return code for the utility | DB2CCUTILSRC | INT4 | 4 | ||
| UTIL_NAME | Utility specification | DB2UTILNAM | CHAR | 20 | ||
| RECDSN | Dataset allocated to the SYSREC DDNAME | DB2RECDSN | CHAR | 54 | ||
| RECDEVT | Device on which the SYSREC dataset resides | DB2RECDEVT | CHAR | 8 | ||
| RECSPACE | Primary space allocation for the SYSREC dataset (cylinders) | DB2RECSPC | INT2 | 2 | ||
| DISCDSN | Dataset allocated to the SYSDISC DDNAME | DB2DISCDSN | CHAR | 54 | ||
| DISCDEVT | Device on which the SYSDISC dataset resides | DB2DISDEVT | CHAR | 8 | ||
| DISCSPACE | Primary space allocation for the SYSDISC dataset (cyl.) | DB2DISCSPC | INT2 | 2 | ||
| PNCHDSN | Dataset allocated to the SYSPUNCH DDNAME | DB2PNCHDSN | CHAR | 54 | ||
| PNCHDEVT | Device on which the SYSREC dataset resides | DB2PNCDEVT | CHAR | 8 | ||
| PNCHSPACE | Primary space allocation for the SYSPNCH dataset (cyl.) | DB2PNCHSPC | INT2 | 2 | ||
| COPYDSN1 | Dataset allocated to the SYSCOPY DDNAME | DB2CP1DSN | CHAR | 54 | ||
| COPYDEVT1 | Device on which the SYSCOPY dataset resides | DB2CP1DEVT | CHAR | 8 | ||
| COPYSPACE1 | Primary space allocation for the SYSCOPY dataset (cyl.) | DB2CP1SPC | INT2 | 2 | ||
| COPYDSN2 | Dataset allocated to the SYSCOPY2 DDNAME | DB2CP2DSN | CHAR | 54 | ||
| COPYDEVT2 | Device on which the SYSCOPY2 dataset resides | DB2CP2DEVT | CHAR | 8 | ||
| COPYSPACE2 | Primary space allocation for the SYSCOPY2 dataset (cyl.) | DB2CP2SPC | INT2 | 2 | ||
| RCPYDSN1 | Dataset allocated to the SYSRCPY1 DDNAME | DB2RC1DSN | CHAR | 54 | ||
| RCPYDEVT1 | Device on which the SYSRCPY1 dataset resides | DB2RC1DEVT | CHAR | 8 | ||
| RCPYSPACE1 | Primary space allocation for the SYSRCPY1 dataset (cyl.) | DB2RC1SPC | INT2 | 2 | ||
| RCPYDSN2 | Dataset allocated to the SYSRCPY2 DDNAME | DB2RC2DSN | CHAR | 54 | ||
| RCPYDEVT2 | Device on which the SYSRCPY2 dataset resides | DB2RC2DEVT | CHAR | 8 | ||
| RCPYSPACE2 | Primary space allocation for the SYSRCPY2 dataset (cyl.) | DB2RC2SPC | INT2 | 2 | ||
| MAPDSN | Dataset allocated to the SYSMAP DDNAME | DB2MAPDSN | CHAR | 54 | ||
| MAPDEVT | Device on which the SYSMAP dataset resides | DB2MAPDEVT | CHAR | 8 | ||
| MAPSPACE | Primary space allocation for the SYSMAP dataset (cyl.) | DB2MAPSPC | INT2 | 2 | ||
| ERRDSN | Dataset allocated to the SYSERR DDNAME | DB2ERRDSN | CHAR | 54 | ||
| ERRDEVT | Device on which the SYSERR dataset resides | DB2ERRDEVT | CHAR | 8 | ||
| ERRSPACE | Primary space allocation for the SYSERR dataset (Cyl.) | DB2ERRSPC | INT2 | 2 | ||
| WORKDSN1 | Dataset allocated to the SYSUT1 DDNAME | DB2WK1DSN | CHAR | 54 | ||
| WORKDEVT1 | Device on which the SYSUT1 dataset resides | DB2WK1DEVT | CHAR | 8 | ||
| WORKSPACE1 | Primary space allocation for the SYSUT1 dataset (cyl.) | DB2WK1SPC | INT2 | 2 | ||
| WORKDSN2 | Dataset allocated to the SORTOUT DDNAME | DB2WK2DSN | CHAR | 54 | ||
| WORKDEVT2 | Device on which the SORTOUT dataset resides | DB2WK2DEVT | CHAR | 8 | ||
| WORKSPACE2 | Primary space allocation for the SORTOUT dataset (cyl.) | DB2WK2SPC | INT2 | 2 | ||
| FILTRDSN | Dataset allocated to the FILTER DDNAME | DB2FILDSN | CHAR | 54 | ||
| FILTRDEVT | Device on which the FILTER dataset resides | DB2FILDEVT | CHAR | 8 | ||
| FILTRSPACE | Primary space allocation for the SYSERR dataset (Cyl.) | DB2FILSPC | INT2 | 2 | ||
| LCHAR_LENGTH | 2 Byte Signed Integer | INT2 | INT2 | 2 | ||
| UTSTMT | Utility Control Statement | LCHR | 30000 |