Observation: CURRENTDATA(YES)

The current package has the CURRENTDATA parameter set to YES. The CURRENTDATA parameter determines whether to require data currency for read-only and ambiguous cursors when the isolation level of CURSOR STABILITY is in effect. It also determines whether block fetching can be used for distributed, ambiguous cursors. The following are the acceptable values for the CURRENTDATA parameter and their implications:

  • YES Specifies that currency IS required for read-only and ambiguous cursors, block fetching for distributed, ambiguous cursors is INHIBITED.

  • NO Specifies that currency is NOT required for read-only and ambiguous cursors, block fetching for distributed, ambiguous cursors is ENABLED.

The default may have been taken when this package was created, and could adversely affect the locking behavior of your application. Consider rebinding your package with the CURRENT DATA parameter set to NO, where applicable. If rebinding is not an option, then lock contention may be minimized by using FOR FETCH ONLY on read-only SELECT statements.