SAP ABAP Data Element DB2RTSKDIC (KEEPDICTIONARY option of the REORG TABLESPACE utility)

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

Data Element	DB2RTSKDIC
Short Description	KEEPDICTIONARY option of the REORG TABLESPACE utility

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DB2YNFLAG
Data Type	CHAR	Character String
Length	1
Decimal Places	0
Output Length	1
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Keepdict.
Medium	15	Keepdictionary
Long	20	Keepdictionary
Heading	14	Keepdictionary

Documentation

Definition

Prevents REORG TABLESPACE from building a new compression dictionary when unloading the rows. The efficiency of REORG increases with the KEEPDICTIONARY option for the following reasons:

• The processing cost of building the compression dictionary is eliminated.
• Existing compressed rows do not have to be compressed again.
• Existing compressed rows do not have to be expanded, unless indexes require it or SORTDATA is used.

KEEPDICTIONARY is valid only if a compression dictionary exists and the tablespace or partition being reorganized has the COMPRESS YES attribute. If a dictionary does not exist, one is built, a warning message is issued, and all the records are compressed.

Messages DSNU234I and DSNU244I, which show compression statistics, are not issued when you specify REORG UNLOAD CONTINUE KEEPDICTIONARY or REORG UNLOAD PAUSE KEEPDICTIONARY.

History

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