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

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"onmode"--,--"j"--)--;------><
                     '-task--'                              

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");

Copyright© 2019 HCL Technologies Limited