onmode and j arguments: Switch the database server to administration mode (SQL administration API)

Use the onmode and j arguments with the admin() or task() function to change the database server to administration mode.

Syntax


1  EXECUTE FUNCTION
1 admin
1 task
2  (
2  "onmode" , "j"
2  ) ;

Usage

When the server is changed to administration mode, all sessions lose their connection to the database server except for sessions of the following users:

  • User informix
  • Users in the DBSA group
  • Users who are identified in ADMIN_MODE_USERS settings

This function is equivalent to the onmode -j command.

Example

The following example changes the server to administration mode:
EXECUTE FUNCTION task("onmode","j");