EXCLUSIVE keyword
The EXCLUSIVE keyword opens the database in exclusive mode and prevents access by anyone but the current user. To allow others to access the database, you must first execute the CLOSE DATABASE statement and then reopen the database without the EXCLUSIVE keyword.
The following statement opens the stores_demo database
on the training database server in exclusive mode:
DATABASE stores_demo@training EXCLUSIVE;
If another user has already opened the specified database, exclusive access is denied, an error is returned, and no database is opened.
If
you encounter this error, but you are unable to confirm that other
users are connected to the database, your non-exclusive access might
be caused by a sensor or task that is running in the Scheduler API.
To temporarily disable the Scheduler, you can issue this SQL administration
API command:
EXECUTE FUNCTION admin('scheduler shutdown');After
the admin('scheduler shutdown') routine has completed
execution. retry the DATABASE ... EXCLUSIVE statement.For more information on the Scheduler API commands, see your HCL OneDB™ Administrator's Guide. For information about the privileges that you must hold to call SQL administration API functions, see your HCL OneDB Administrator's Reference.