System-wide Setting for Default Lock Level
This feature adds a system configuration parameter that allows the Ingres administrator to define the default lock level for the entire Ingres instance.
In previous releases of Ingres, to alter the default lock level the application programmer had to use the SET LOCKMODE statement in the application, which affected only the current session.
The new parameter, system_lock_level, is available to the administrator through Configuration-By-Forms. Valid values are DEFAULT, ROW, PAGE, and TABLE. The DEFAULT value is the default and allows the system to decide the lock level. DEFAULT is the assumed value if the parameter is not present.
Note: Each of the default lock levels is subject to escalation, as in previous releases.
For more information on the default locking level, see the Database Administrator Guide.