KD2_PFnn_EX_D2EXDB
DB2 EXPLAIN data base
- Description
-
Specify the EXPLAIN database name. There are no special requirements regarding database name, storage group, or index buffer pool. But you must use an 8 KB buffer pool.
- Required or optional
- Optional (Required in case KD2_PF_EX_D2EXACT is set to Y)
- Default value
- DATBA8K
- Locations where the parameter value is stored
-
- Location 1
- In the EXCTssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
IN DATABASE <value>
- Location 2
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT CREATETS ON DATABASE <value> TO <KD2_PFnn_EX_D2EXOBJ>
- Location 3
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT CREATETAB ON DATABASE <value> TO <KD2_PFnn_EX_D2EXOBJ>
- Location 4
- In the EXCQssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
IN DATABASE <value>
- In the Configuration Tool (ICAT)
-
- Panel name
- DB2 Explain
- Panel ID
- KD261P4
- Panel field
- EXPLAIN database
- Default value
- DATBA8K
- Batch parameter name
- KD2_PF_EX_D2EXDB
- PARMGEN name
- KD2_PFnn_EX_D2EXDB
- PARMGEN classification
- EXPLAIN