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 was required and ALWCPYDTA(*YES) was specified
A temporary copy was chosen for better performance and ALWCPYDTA(*OPTIMIZE) was 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 you need to specify ALWCPYDTA(*YES) to keep DSTDTA(*CURRENT) in effect.

Processing of the DSTDTA and ALWCPYDTA parameters with DB2® Multisystem

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