SAND CDBMS Tools Reference Guide
Database Server (nserv)

 

Previous Topic:
Providing Multi-User Database Access with nserv
Chapter Index
 Next Topic:
Shutting Down the Database Server

 

Managing Database Server Access


Once a database server instance has been started, the nserv process becomes dedicated to receiving and processing client requests, and is no longer interactive. However, a user with DBA privileges on the database can execute the SET TRANSACTION...ISOLATION LEVEL EXCLUSIVE command from an SQL session to prevent any further client connections to the database instance. The command remains in effect until subsequent execution of a COMMIT [WORK], ROLLBACK [WORK], or another SET TRANSACTION command from the same session (that is, for the duration of the current transaction).

For complete information about the SET TRANSACTION command, consult the SAND CDBMS SQL Reference Guide.