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 Informix® Administrator's Guide. For information about the privileges that you must hold to call SQL administration API functions, see your Informix® Administrator's Reference.