SAP DB2REOTSP table - REORG TABLESPACE Parameters details in SAP

Description: Name of the tablespace that is to be reorganized
Field Name: TSNAME
Data Element: DB2RTSTS
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2TSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TSNAME

Description: Name of the database to which the tablespace belongs
Field Name: DBNAME
Data Element: DB2RTSDB
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

Description: Number of the partition to be reorganized
Field Name: PARTNO
Data Element: DB2RTSPART
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2PARTNO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTNO

Description: LOG option of the REORG TABLESPACE utility
Field Name: LOGGING
Data Element: DB2RTSLOG
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DB2YESNO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGGING

Description: SORTDATA option of the REORG TABLESPACE utility
Field Name: SORTDATA
Data Element: DB2RTSSORT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORTDATA

Description: NOSYSREC option of the REORG TABLESPACE utility
Field Name: NOSYSREC
Data Element: DB2RTSNSYS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NOSYSREC

Description: SORTKEYS option of the REORG TABLESPACE utility
Field Name: SORTKEYS
Data Element: DB2RTSSKEY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORTKEYS

Description: SHRLEVEL parameter of the REORG utility
Field Name: SHRLEVEL
Data Element: DB2RTSSHR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2SHRLVL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SHRLEVEL

Description: DEADLINE parameter of the REORG utility
Field Name: DEADLINE
Data Element: DB2RTSDEAD
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: DB2TMSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEADLINE

Description: Name of the mapping table
Field Name: MAPTABLE
Data Element: DB2RTSMAP
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: DB2TBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAPTABLE

Description: Creator of the mapping table
Field Name: MAPCREATOR
Data Element: DB2RTSMAPC
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CREATOR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAPCREATOR

Description: MAXRO parameter of the REORG utility
Field Name: MAXRO
Data Element: DB2RTSMRO
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXRO

Description: LONGLOG parameter of the REORG utility
Field Name: LONGLOG
Data Element: DB2RTSLLOG
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LONGLOG

Description: DELAY parameter of the REORG utility
Field Name: DELAY
Data Element: DB2RTSDLAY
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DELAY

Description: UNLOAD parameter of the REORG utility
Field Name: UNLOAD
Data Element: DB2RTSUNLD
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNLOAD

Description: KEEPDICTIONARY option of the REORG TABLESPACE utility
Field Name: KEEPDICT
Data Element: DB2RTSKDIC
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEEPDICT

Description: Dataset allocated to the SYSCOPY DDNAME
Field Name: COPYDSN1
Data Element: DB2CP1DSN
Data Type: CHAR
length (Dec): 54(0)
Check table:
Conversion Routine:
Domain Name: DB2DDN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COPYDSN1

Description: Device on which the SYSCOPY dataset resides
Field Name: COPYDEVT1
Data Element: DB2CP1DEVT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DEVT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COPYDEVT1

Description: Primary space allocation for the SYSCOPY dataset (cyl.)
Field Name: COPYSPACE1
Data Element: DB2CP1SPC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2DDPQTYC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COPYSPACE1

Description: Dataset allocated to the SYSCOPY2 DDNAME
Field Name: COPYDSN2
Data Element: DB2CP2DSN
Data Type: CHAR
length (Dec): 54(0)
Check table:
Conversion Routine:
Domain Name: DB2DDN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COPYDSN2

Description: Device on which the SYSCOPY2 dataset resides
Field Name: COPYDEVT2
Data Element: DB2CP2DEVT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DEVT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COPYDEVT2

Description: Primary space allocation for the SYSCOPY2 dataset (cyl.)
Field Name: COPYSPACE2
Data Element: DB2CP2SPC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2DDPQTYC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COPYSPACE2

Description: Dataset allocated to the SYSRCPY1 DDNAME
Field Name: RCPYDSN1
Data Element: DB2RC1DSN
Data Type: CHAR
length (Dec): 54(0)
Check table:
Conversion Routine:
Domain Name: DB2DDN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RCPYDSN1

Description: Device on which the SYSRCPY1 dataset resides
Field Name: RCPYDEVT1
Data Element: DB2RC1DEVT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DEVT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RCPYDEVT1

Description: Primary space allocation for the SYSRCPY1 dataset (cyl.)
Field Name: RCPYSPACE1
Data Element: DB2RC1SPC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2DDPQTYC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RCPYSPACE1

Description: Dataset allocated to the SYSRCPY2 DDNAME
Field Name: RCPYDSN2
Data Element: DB2RC2DSN
Data Type: CHAR
length (Dec): 54(0)
Check table:
Conversion Routine:
Domain Name: DB2DDN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RCPYDSN2

Description: Device on which the SYSRCPY2 dataset resides
Field Name: RCPYDEVT2
Data Element: DB2RC2DEVT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DEVT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RCPYDEVT2

Description: Primary space allocation for the SYSRCPY2 dataset (cyl.)
Field Name: RCPYSPACE2
Data Element: DB2RC2SPC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2DDPQTYC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RCPYSPACE2

Description: Dataset allocated to the SYSREC DDNAME
Field Name: RECDSN
Data Element: DB2RECDSN
Data Type: CHAR
length (Dec): 54(0)
Check table:
Conversion Routine:
Domain Name: DB2DDN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECDSN

Description: Device on which the SYSREC dataset resides
Field Name: RECDEVT
Data Element: DB2RECDEVT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DEVT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECDEVT

Description: Primary space allocation for the SYSREC dataset (cylinders)
Field Name: RECSPACE
Data Element: DB2RECSPC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2DDPQTYC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECSPACE

Description: Dataset allocated to the SYSUT1 DDNAME
Field Name: WORKDSN1
Data Element: DB2WK1DSN
Data Type: CHAR
length (Dec): 54(0)
Check table:
Conversion Routine:
Domain Name: DB2DDN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKDSN1

Description: Device on which the SYSUT1 dataset resides
Field Name: WORKDEVT1
Data Element: DB2WK1DEVT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DEVT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKDEVT1

Description: Primary space allocation for the SYSUT1 dataset (cyl.)
Field Name: WORKSPACE1
Data Element: DB2WK1SPC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2DDPQTYC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKSPACE1

Description: Dataset allocated to the SORTOUT DDNAME
Field Name: WORKDSN2
Data Element: DB2WK2DSN
Data Type: CHAR
length (Dec): 54(0)
Check table:
Conversion Routine:
Domain Name: DB2DDN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKDSN2

Description: Device on which the SORTOUT dataset resides
Field Name: WORKDEVT2
Data Element: DB2WK2DEVT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DEVT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKDEVT2

Description: Primary space allocation for the SORTOUT dataset (cyl.)
Field Name: WORKSPACE2
Data Element: DB2WK2SPC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2DDPQTYC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKSPACE2

Description: Device type for temporary datasets allocated by DFSORT
Field Name: SORTDEVT
Data Element: DB2SRTDEVT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DEVT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORTDEVT

Description: Number of temporary datasets allocated by DFSORT
Field Name: SORTNUM
Data Element: DB2SRTNUM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORTNUM

Description: PREFORMAT option of the REORG utility
Field Name: PREFORMAT
Data Element: DB2RTSPREF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREFORMAT

Description: Whether & at which point a current utility job is restarted
Field Name: RESTART
Data Element: DB2RESTART
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2RESTART
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESTART