SAP ABAP Data Element DB2WP4CCDY (Cache prepared dynamic SQL statements)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU3 (Package) Development Class for Database Monitor
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU3 (Package) Development Class for Database Monitor
Basic Data
Data Element | DB2WP4CCDY |
Short Description | Cache prepared dynamic SQL statements |
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 | 15 | Dyn.stmt cache |
Long | 20 | Dynamic stmt cache |
Heading | 0 |
Documentation
Definition
This parameter indicates whether DB2 can cache prepared SQL statements
in the EDM pool by making a copy from the prepared statement cache.
When caching is enabled, all plans and packages on the DB2 subsystem
are eligable to store and retrieve prepared statements from the cache.
Installation parameter: CACHE DYNAMIC SQL on panel DSNTIP4
ZPARM NAME: CACHEDYN in DSN6SPRM
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 710 |