Hi,can someone explain the difference between "COMMIT" and "COMMIT+1" (QW002140 and QW002141)? I can't find a description for these values of the "Lock Duration" field.Thanks
SDSNMACS(DSNDQW00)QW0021DR DS X * LOCK DURATION *QW002120 EQU X'20' * MANUAL *QW002121 EQU X'21' * MANUAL+1 *QW002140 EQU X'40' * COMMIT *QW002141 EQU X'41' * COMMIT+1 *QW002160 EQU X'60' * ALLOCATION *QW002180 EQU X'80' * PLAN *QW002181 EQU X'81' * UTIL @65*QW0021FE EQU X'FE' * INTEREST DURATION *QW0021FF EQU X'FF' * DURATION TO FREE ALL LOCKS *
Thanks a lot James.
We had "COMMIT+1" locks only on SKPTs (no other resources were involved).Now we realized that KEEPDYNAMIC(YES) was the reason for that holding the prepared statements in the local cache.With KEEPDYNAMIC(NO) the locks disapeared after a "normal" commit and the DBAT were disconnected.