SAP ABAP Table DB2REOIDX (REORG INDEX 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	DB2REOIDX	Table Relationship Diagram
Short Description	REORG INDEX 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	IXNAME	☐	DB2RIXIX	DB2IXNAME	CHAR	18	0	Name of the index to be reorganized
2	IXCREATOR	☐	DB2RIXCRE	DB2CREATOR	CHAR	8	0	Creator of the index to be reorganized
3	PARTNO	☐	DB2RTSPART	DB2PARTNO	INT2	5	0	Number of the partition to be reorganized
4	SHRLEVEL	☐	DB2RTSSHR	DB2SHRLVL	CHAR	10	0	SHRLEVEL parameter of the REORG utility
5	DEADLINE	☐	DB2RTSDEAD	DB2TMSTMP	CHAR	26	0	DEADLINE parameter of the REORG utility
6	MAXRO	☐	DB2RTSMRO	CHAR10	CHAR	10	0	MAXRO parameter of the REORG utility
7	LONGLOG	☐	DB2RTSLLOG	CHAR8	CHAR	8	0	LONGLOG parameter of the REORG utility
8	DELAY	☐	DB2RTSDLAY	CHAR10	CHAR	10	0	DELAY parameter of the REORG utility
9	UNLOAD	☐	DB2RTSUNLD	CHAR8	CHAR	8	0	UNLOAD parameter of the REORG utility
10	RECDSN	☐	DB2RECDSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSREC DDNAME
11	RECDEVT	☐	DB2RECDEVT	DB2DEVT	CHAR	8	0	Device on which the SYSREC dataset resides
12	RECSPACE	☐	DB2RECSPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSREC dataset (cylinders)
13	WORKDSN1	☐	DB2WK1DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SYSUT1 DDNAME
14	WORKDEVT1	☐	DB2WK1DEVT	DB2DEVT	CHAR	8	0	Device on which the SYSUT1 dataset resides
15	WORKSPACE1	☐	DB2WK1SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SYSUT1 dataset (cyl.)
16	WORKDSN2	☐	DB2WK2DSN	DB2DDN	CHAR	54	0	Dataset allocated to the SORTOUT DDNAME
17	WORKDEVT2	☐	DB2WK2DEVT	DB2DEVT	CHAR	8	0	Device on which the SORTOUT dataset resides
18	WORKSPACE2	☐	DB2WK2SPC	DB2DDPQTYC	INT2	5	0	Primary space allocation for the SORTOUT dataset (cyl.)
19	SORTDEVT	☐	DB2SRTDEVT	DB2DEVT	CHAR	8	0	Device type for temporary datasets allocated by DFSORT
20	SORTNUM	☐	DB2SRTNUM		INT4	10	0	Number of temporary datasets allocated by DFSORT
21	PREFORMAT	☐	DB2RTSPREF	DB2YNFLAG	CHAR	1	0	PREFORMAT option of the REORG utility
22	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