OJPERFEH—Outer join performance enhancements - Documentation for OPERTUNE for DB2 12.1
Use the Modify Outer Join Performance Enhancements panel or the OJPERFEH command to specify whether to disable performance enhancements for outer join operations.
Modify Outer Join Performance Enhancements panel
DDTJ DHB4 Modify Outer Join Performance Enhancements
Command ===> _________________________________________________________________ Command: CURRENT
Description . . . . . . . . : OUTER JOIN PERFORMANCE ENHANCEMENTS
Type the new Outer Join Performance Enhancement indicator you wish to change to. Then Press Enter.
Outer Join Performance Enhancements Indicator Enabled . . . . . . . . . . Y (Y or N)Command syntax and parameters
Value | Description |
|---|---|
| DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
| opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
Y | Whether to enable performance enhancements for outer join operations. Specify one of the following values:
|
| NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
| OJPERFEH | None | None | DSN6SPRM | OJPERFEH |
