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
EXECUTE FUNCTION
{
admin
| task
}
( "onmode"
,"j" )
;
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");