Specifying administration mode users

You can specify which users can connect to the database server in administration mode.

Temporary administration mode users

User informix or a DBSA can use the onmode -j -U or the oninit -U command to grant individual users access to the database server in administration mode for a session.

For example, run the following command to enable three individual users to connect to the database server and have database server access until the database server mode changes to offline, quiescent or online mode:
onmode -j -U mark,ajay,carol

After connecting, these individual users can run any SQL or DDL commands. When the server is changed to administration mode, all sessions for users not identified in the onmode -j -U command lose their database server connection.

After initially running the onmode -j -U command, you can remove individuals by running onmode -j -U and removing individual user names from the new list of names in the command, for example, by running:
onmode -j -U mark,carol
Run the oninit -U command with a blank space instead of a name to remove all users in the list, as shown in this example:
oninit -U " "

Permanent administration mode users

Unlike the oninit and onmode commands that enable you to specify administration mode users until the server changes to offline, quiescent, or online mode, the ADMIN_MODE_USERS configuration parameter preserves a list of administration mode users indefinitely.

To create a list of administration mode users that is preserved in the onconfig file, specify a comma-separated list of users as ADMIN_MODE_USERS configuration parameter values, for example, mark,ajay,carol.

To override ADMIN_MODE_USERS during a session, use the onmode -wf command, as shown in this example:
onmode -wf ADMIN_MODE_USERS=sharon,kalpana 
The effect of the ADMIN_MODE_USERS configuration parameter is to add to the list of people permitted to access the server in administration mode. Those people listed in the onmode command line override those listed in the onconfig file.

Copyright© 2019 HCL Technologies Limited