Originally posted by R.Daugherty
View Post
Allow copy of data (ALWCPYDTA)
Specifies whether a copy of the data can be used in a SELECT statement.
*OPTIMIZE
The system determines whether to use the data retrieved directly from the database or to use a copy of the data. The decision is based on which method provides the best performance. If the Commitment control (COMMIT) parameter is not *NONE, the Allow blocking (ALWBLK) parameter should be set to *ALLREAD, when possible, for best performance.
*YES
A copy of the data is used only when necessary.
*NO
A copy of the data is not used. If a temporary copy of the data is required to perform the query, an error message is returned.
-------------
Clearly...
I don't particularly see this as greatly surprising. There is also ALWCPYDTA *OPTIMIZE which may also have worked perhaps even better.
Anyway...I'm happy it works now.
...Michael
Leave a comment: