Changing the Database Server to Administration Mode with the -j Option

The -j option puts the database server into the administration mode and allows only the DBSA group and the user informix to connect to the server. The -j option allows a DBSA to have the server in a fully functional mode to perform maintenance.

The -j -U option enables the DBSA to grant individual users access to the database server in administration mode. Once connected, these individual users can execute any SQL or DDL command. When the server is changed to administration mode, all sessions for users other than user informix, the DBSA group users, and those identified in the onmode -j -U command lose their database server connection.

The following example enables 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 karin,sarah,andrew

Access for individual users can also be removed by executing onmode -j -U and removing their name from the new list of names in the command. For example, in the following commands, the first command grants only Karin access, the second command grants Karin and Sarah access, and the third command grants only Sarah access (and removes access from Karin).

onmode -j -U karin
onmode -j -U karin,sarah
onmode -j -U sarah

To allow user informix and the DBSA group user to retain their database server access in administration mode and remove all single users from accessing the database server, use the following command:

onmode -j -U ' '

For information on designating single users in administration mode using a configuration parameter, see ADMIN_MODE_USERS configuration parameter