Databases without transaction logging

In a database that was created without transaction logging (by omitting the WITH LOG keywords in the CREATE DATABASE statement), table locks that were set by the LOCK TABLE statement are released after any of the following events:
  • An UNLOCK TABLE statement executes.
  • The user closes the database.
  • The user exits from the application.

To change the lock mode on a table, release the lock with the UNLOCK TABLE statement and then issue a new LOCK TABLE statement.

The following example shows how to change the lock mode of a table in an unlogged database: 
LOCK TABLE orders IN EXCLUSIVE MODE;
   . . .
UNLOCK TABLE orders; 
   . . .
LOCK TABLE orders IN SHARE MODE;