Cloudscape Properties
Page 38 of 47

cloudscape.storage.rowLocking

Function

Use this property to disable row-level locking. Row-level locking uses more system resources, such as disk space and memory, so if an application does not need row-level locking, you can use this system property to force all locking to table level. For example, read-only and single-user applications probably do not need row-level locking.

This property can be set to one of the boolean values true and false. Setting the property to true enables row-level locking (the default behavior). Setting the property to false disables row-level locking.

Default

True.

Example

cloudscape.storage.rowLocking=false

-- database-level property
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.storage.rowLocking',
    'false')

-- publishing a database-wide property
CREATE PUBLICATION APub
ADD TARGET DATABASE PROPERTY
cloudscape.storage.rowLocking=
    'false'

Scope

system-wide

database-wide (publishable)

Dynamic or Static

This property is static; if you change it while Cloudscape is running, the change does not take effect until you reboot.