SAP ABAP Data Element DB2BSTWFF (Number of times a merge pass could not be performed)

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	DB2BSTWFF
Short Description	Number of times a merge pass could not be performed

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DB2DEC19V
Data Type	DEC	Counter or amount field with comma and sign
Length	19
Decimal Places	0
Output Length	26
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	merge p de
Medium	19	merge pass degraded
Long	20	merge pass degraded
Heading	19	merge pass degraded

Documentation

Definition

Number of times that the merge pass was not efficiently performed because of a shortage of buffer space.
This counter is incremented for each merge pass when the maximum number of work files allowed is less than the number of work files requested. The maximum number of work files allowed is computed as:

    buffers consumed = 2 * (work files already allocated)
    buffers available = (sequential steal threshold * buffer pool size - buffers consumed)
    max work files allowed = buffers available / (2 * 8)

If the counter is larger than 5% of the number of work files requested, consider increasing the buffer pool size.

History

Last changed by/on	SAP	20110908
SAP Release Created in