SAP ABAP Data Element DB2WPMSTG (Thread Storage Algorithm)

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	DB2WPMSTG
Short Description	Thread Storage Algorithm

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DB2CHAR09
Data Type	CHAR	Character String
Length	9
Decimal Places	0
Output Length	9
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	Thr.Stor.
Medium	19	Thread Storage Alg.
Long	38	Thread Storage Algorithm
Heading	24	Thread Storage Algorithm

Documentation

Definition

Specifies whether DB2 is to use storage management algorithms that minimize the amount of working storage consumed by individual threads.

The value of NO (which is the default) results in somewhat better performance. On the other hand, YES ensures lower virtual storage utilization.

Its ZPARM name is MINSTOR in DSN6SPRM.

History

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