KD2_DBnn_PWH_D2PWQRYP
PE Server PWH DB2 buffer pool
- Description
-
Specify a valid Buffer Pool name for the PWH database.
- Required or optional
- Optional (Required in case KD2_DB_PWH_D2PWPWHA is set to Y)
- Default value
- BP32K
- Locations where the parameter value is stored
-
- Location 1
- In the PWHRssid member of the rhilev.midlev.rtename.RKD2PAR library
- Output line
-
QRY 1 <value> name of 32K buffer pool
- Location 2
- In the PWG1ssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT USE OF BUFFERPOOL <value> TO DB2PM;
- In the Configuration Tool (ICAT)
-
- Panel name
- Performance Warehouse Configuration
- Panel ID
- KD261PW
- Panel field
- QUERY Buffer Pool
- Default value
- BP32K
- Batch parameter name
- KD2_DB_PWH_D2PWQRYP
- PARMGEN name
- KD2_DBnn_PWH_D2PWQRYP
- PARMGEN classification
- PWH