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.


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


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.


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

Copyright© 2018 HCL Technologies Limited