Single User Mode

Introduction

AKA Administration Mode

The important difference is that the IDS instance can be accessed via SQL by user informix and other authorized users in this mode. Authorized users can be specified thru the ADMIN_MODE_USERS onconfig parameter or thru the -U option of the oninit and onmode utilities. As a requirement you need to set the onconfig parameter ADMIN_USER_MODE_WITH_DBSA to 1, otherwise only user informix is able to connect to the IDS instance in administration mode.

Offline to Single-user

oninit -j

Single-User to Offline

onmode -ky

Single-User to Online

onmode -m

Online to Single-User

onmode -jy