SAP ABAP Data Element DB2WP4CONT (Storage contraction)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Data Element	DB2WP4CONT
Short Description	Storage contraction

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DB2CHAR03L
Data Type	CHAR	Character String
Length	3
Decimal Places	0
Output Length	3
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	0
Medium	19	Storage contraction
Long	20	Storage contraction
Heading	0

Documentation

Definition

If this parameter is set to 'Yes', DB2 will periodically contract the working storage pool for threads. This contraction will search for unused working storage blocks and free them back to the operating system. DB2 will examine each thread when it reaches a commit point and then look at two criteria to determine whether to contract the thread's storage pool:

• The number of commits has exceeded the value specified in the parameter 'Storage contraction threshold (commits)' since the last time the pool was contracted.
• The total size of the thread's storage pool exceeds the value specified in the parameter 'Storage contraction threshold (bytes)'.

If either of these criteria are met, the pool is contracted.

In R/3 environments this parameter needs to be set to its default value which is 'Yes'.

Installation parameter CONTRACT THREAD STG on panel DSNTIPE.
Its ZPARM name is CONTSTOR in DSN6SPRM.

History

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