KD2_PFnn_EX_D2EXQMF
Is DB2 EXPLAIN QMF installed
- Description
-
Specify Y if QMF is installed.
- Required or optional
- Optional (Required in case KD2_PF_EX_D2EXACT is set to Y)
- Default value
- N
- Permissible values
- Y, N
- Locations where the parameter value is stored
-
- Location 1
- In the EXGPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON <value>I..OBJECT_DATA TO %exuser%;
- Location 2
- In the EXCQssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
FROM <value>I..OBJECT_DIRECTORY ;
- Location 3
- In the EXGPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON <value>I..OBJECT_DIRECTORY TO %exuser%;
- Location 4
- In the EXCQssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
FROM <value>I..OBJECT_DATA ;
- In the Configuration Tool (ICAT)
-
- Panel name
- DB2 Explain
- Panel ID
- KD261P4
- Panel field
- Is QMF installed
- Default value
- N
- Permissible values
- Y, N
- Batch parameter name
- KD2_PF_EX_D2EXQMF
- PARMGEN name
- KD2_PFnn_EX_D2EXQMF
- PARMGEN classification
- EXPLAIN