Processing of the DSTDTA and ALWCPYDTA parameters with DB2^® Multisystem

 

The allow copy data (ALWCPYDTA) parameter can change the value specified for the distribute data (DSTDTA) parameter of the Override Database File (OVRDBF) command. If you specified to use live data (DSTDTA(*CURRENT)) on the override command, either of the following items is true:

• A temporary copy is required and ALWCPYDTA(*YES) is specified

• A temporary copy is chosen for better performance and ALWCPYDTA(*OPTIMIZE) is specified

then DSTDTA is changed to DSTDTA(*BUFFERED).

If DSTDTA(*BUFFERED) is not acceptable to you and the query does not require a temporary copy, then specify ALWCPYDTA(*YES) to keep DSTDTA(*CURRENT) in effect.

 

Parent topic:

Query design for performance with DB2 Multisystem