SAP DB2REOTSP table - REORG TABLESPACE Parameters details in SAP


SAP DB2REOTSP table summary

Object Name: DB2REOTSP
Dictionary Type: Structure
Description: REORG TABLESPACE Parameters


Field list for DB2REOTSP table on an S/4 SAP system

Details
DB2REOTSP-TSNAME table field - Name of the tablespace that is to be reorganized

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

DB2REOTSP-DBNAME table field - Name of the database to which the tablespace belongs

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

DB2REOTSP-PARTNO table field - Number of the partition to be reorganized

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

DB2REOTSP-LOGGING table field - LOG option of the REORG TABLESPACE utility

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

DB2REOTSP-SORTDATA table field - SORTDATA option of the REORG TABLESPACE utility

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

DB2REOTSP-NOSYSREC table field - NOSYSREC option of the REORG TABLESPACE utility

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

DB2REOTSP-SORTKEYS table field - SORTKEYS option of the REORG TABLESPACE utility

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

DB2REOTSP-SHRLEVEL table field - SHRLEVEL parameter of the REORG utility

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

DB2REOTSP-DEADLINE table field - DEADLINE parameter of the REORG utility

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

DB2REOTSP-MAPTABLE table field - Name of the mapping table

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

DB2REOTSP-MAPCREATOR table field - Creator of the mapping table

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

DB2REOTSP-MAXRO table field - MAXRO parameter of the REORG utility

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

DB2REOTSP-LONGLOG table field - LONGLOG parameter of the REORG utility

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

DB2REOTSP-DELAY table field - DELAY parameter of the REORG utility

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

DB2REOTSP-UNLOAD table field - UNLOAD parameter of the REORG utility

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

DB2REOTSP-KEEPDICT table field - KEEPDICTIONARY option of the REORG TABLESPACE utility

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

DB2REOTSP-COPYDSN1 table field - Dataset allocated to the SYSCOPY DDNAME

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

DB2REOTSP-COPYDEVT1 table field - Device on which the SYSCOPY dataset resides

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

DB2REOTSP-COPYSPACE1 table field - Primary space allocation for the SYSCOPY dataset (cyl.)

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

DB2REOTSP-COPYDSN2 table field - Dataset allocated to the SYSCOPY2 DDNAME

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

DB2REOTSP-COPYDEVT2 table field - Device on which the SYSCOPY2 dataset resides

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

DB2REOTSP-COPYSPACE2 table field - Primary space allocation for the SYSCOPY2 dataset (cyl.)

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

DB2REOTSP-RCPYDSN1 table field - Dataset allocated to the SYSRCPY1 DDNAME

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

DB2REOTSP-RCPYDEVT1 table field - Device on which the SYSRCPY1 dataset resides

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

DB2REOTSP-RCPYSPACE1 table field - Primary space allocation for the SYSRCPY1 dataset (cyl.)

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

DB2REOTSP-RCPYDSN2 table field - Dataset allocated to the SYSRCPY2 DDNAME

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

DB2REOTSP-RCPYDEVT2 table field - Device on which the SYSRCPY2 dataset resides

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

DB2REOTSP-RCPYSPACE2 table field - Primary space allocation for the SYSRCPY2 dataset (cyl.)

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

DB2REOTSP-RECDSN table field - Dataset allocated to the SYSREC DDNAME

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

DB2REOTSP-RECDEVT table field - Device on which the SYSREC dataset resides

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

DB2REOTSP-RECSPACE table field - Primary space allocation for the SYSREC dataset (cylinders)

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

DB2REOTSP-WORKDSN1 table field - Dataset allocated to the SYSUT1 DDNAME

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

DB2REOTSP-WORKDEVT1 table field - Device on which the SYSUT1 dataset resides

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

DB2REOTSP-WORKSPACE1 table field - Primary space allocation for the SYSUT1 dataset (cyl.)

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

DB2REOTSP-WORKDSN2 table field - Dataset allocated to the SORTOUT DDNAME

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

DB2REOTSP-WORKDEVT2 table field - Device on which the SORTOUT dataset resides

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

DB2REOTSP-WORKSPACE2 table field - Primary space allocation for the SORTOUT dataset (cyl.)

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

DB2REOTSP-SORTDEVT table field - Device type for temporary datasets allocated by DFSORT

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

DB2REOTSP-SORTNUM table field - Number of temporary datasets allocated by DFSORT

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

DB2REOTSP-PREFORMAT table field - PREFORMAT option of the REORG utility

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

DB2REOTSP-RESTART table field - Whether & at which point a current utility job is restarted

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table