SAP ABAP Table DB2REOTSP (REORG TABLESPACE Parameters)

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	DB2REOTSP	Table Relationship Diagram
Short Description	REORG TABLESPACE Parameters

Delivery and Maintenance

Pool/cluster
Delivery Class
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	TSNAME	☐	DB2RTSTS	DB2TSNAME	CHAR	8	0	Name of the tablespace that is to be reorganized
2	DBNAME	☐	DB2RTSDB	DB2DBNAME	CHAR	8	0	Name of the database to which the tablespace belongs
3	PARTNO	☐	DB2RTSPART	DB2PARTNO	INT2	5	0	Number of the partition to be reorganized
4	LOGGING	☐	DB2RTSLOG	DB2YESNO	CHAR	3	0	LOG option of the REORG TABLESPACE utility
5	SORTDATA	☐	DB2RTSSORT	DB2YNFLAG	CHAR	1	0	SORTDATA option of the REORG TABLESPACE utility
6	NOSYSREC	☐	DB2RTSNSYS	DB2YNFLAG	CHAR	1	0	NOSYSREC option of the REORG TABLESPACE utility
7	SORTKEYS	☐	DB2RTSSKEY	DB2YNFLAG	CHAR	1	0	SORTKEYS option of the REORG TABLESPACE utility
8	SHRLEVEL	☐	DB2RTSSHR	DB2SHRLVL	CHAR	10	0	SHRLEVEL parameter of the REORG utility
9	DEADLINE	☐	DB2RTSDEAD	DB2TMSTMP	CHAR	26	0	DEADLINE parameter of the REORG utility
10	MAPTABLE	☐	DB2RTSMAP	DB2TBNAME	CHAR	18	0	Name of the mapping table
11	MAPCREATOR	☐	DB2RTSMAPC	DB2CREATOR	CHAR	8	0	Creator of the mapping table
12	MAXRO	☐	DB2RTSMRO	CHAR10	CHAR	10	0	MAXRO parameter of the REORG utility
13	LONGLOG	☐	DB2RTSLLOG	CHAR8	CHAR	8	0	LONGLOG parameter of the REORG utility
14	DELAY	☐	DB2RTSDLAY	CHAR10	CHAR	10	0	DELAY parameter of the REORG utility
15	UNLOAD	☐	DB2RTSUNLD	CHAR8	CHAR	8	0	UNLOAD parameter of the REORG utility
16	KEEPDICT	☐	DB2RTSKDIC	DB2YNFLAG	CHAR	1	0	KEEPDICTIONARY option of the REORG TABLESPACE utility
17	COPYDSN1	☐	DB2CP1DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSCOPY DDNAME
18	COPYDEVT1	☐	DB2CP1DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSCOPY dataset resides
19	COPYSPACE1	☐	DB2CP1SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSCOPY dataset (cyl.)
20	COPYDSN2	☐	DB2CP2DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSCOPY2 DDNAME
21	COPYDEVT2	☐	DB2CP2DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSCOPY2 dataset resides
22	COPYSPACE2	☐	DB2CP2SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSCOPY2 dataset (cyl.)
23	RCPYDSN1	☐	DB2RC1DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSRCPY1 DDNAME
24	RCPYDEVT1	☐	DB2RC1DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSRCPY1 dataset resides
25	RCPYSPACE1	☐	DB2RC1SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSRCPY1 dataset (cyl.)
26	RCPYDSN2	☐	DB2RC2DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSRCPY2 DDNAME
27	RCPYDEVT2	☐	DB2RC2DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSRCPY2 dataset resides
28	RCPYSPACE2	☐	DB2RC2SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSRCPY2 dataset (cyl.)
29	RECDSN	☐	DB2RECDSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSREC DDNAME
30	RECDEVT	☐	DB2RECDEVT	DB2DEVT	CHAR	8	0	Device on which the SYSREC dataset resides
31	RECSPACE	☐	DB2RECSPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSREC dataset (cylinders)
32	WORKDSN1	☐	DB2WK1DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSUT1 DDNAME
33	WORKDEVT1	☐	DB2WK1DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSUT1 dataset resides
34	WORKSPACE1	☐	DB2WK1SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSUT1 dataset (cyl.)
35	WORKDSN2	☐	DB2WK2DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SORTOUT DDNAME
36	WORKDEVT2	☐	DB2WK2DEVT	DB2DEVT	CHAR	8	0	Device on which the SORTOUT dataset resides
37	WORKSPACE2	☐	DB2WK2SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SORTOUT dataset (cyl.)
38	SORTDEVT	☐	DB2SRTDEVT	DB2DEVT	CHAR	8	0	Device type for temporary datasets allocated by DFSORT
39	SORTNUM	☐	DB2SRTNUM		INT4	10	0	Number of temporary datasets allocated by DFSORT
40	PREFORMAT	☐	DB2RTSPREF	DB2YNFLAG	CHAR	1	0	PREFORMAT option of the REORG utility
41	RESTART	☐	DB2RESTART	DB2RESTART	CHAR	8	0	Whether & at which point a current utility job is restarted

History

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