Short text
Optimistically close cursors when no longer in use
Parameter Description
DBSL signals the database driver (XDN) to close SQL cursors when no longer in use. The advantage of auto_close is either saving a round-trip to the database, or releasing shared read locks belonging to cursors remaining open; locks that might prevent an exclusive lock from being acquired by ALTER operations.
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 — Auto-closing is enabled
0, off, no, false — Auto-closing is disabled
