Short text
Keep Cursors open and reuse
Parameter Description
An alternative to auto_close, reopen allows DBSL to keep cursors open between commit cycles. The main advantage is saving a round-trip to the database for close operations. The disadvantage is a longer retention of shared read locks. Not all cursors will be closed by auto_close, the remaining will remain open if reopen is set.
Application Area
Database
Default Value
1
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Values allowed
Boolean value, case-insensitive:
1, on, yes, true — Reopening cursors is enabled
0, off, no, false — Reopening cursors is disabled
