Single-User Administrative Mode

Hello, We have a need for a non-informix user to be able to connect to the Informix DB via dbaccess while the DB is in Single-User Admin Mode (onmode -jy). We added the user to group informix on the UNIX server and the user was also granted DBA privileges on the DB's. However the user gets the error, "27010: Only an administrative user or informix can connect in single user mode." What do we need to do to make the user an "administrative user" so they can connect in single-user mode? We are running IDS 11.50.FC6. Dave

On Feb 20, 1:07 pm, Informix DBA <in4mix...@gmail.com> wrote: > Hello, > > We have a need for a non-informix user to be able to connect to the > Informix DB via dbaccess while the DB is in Single-User Admin Mode (onmode > -jy).  We added the user to group informix on the UNIX server and the user > was also granted DBA privileges on the DB's.  However the user gets the > error, "27010: Only an administrative user or informix can connect in > single user mode."  What do we need to do to make the user an > "administrative user" so they can connect in single-user mode?  We are > running IDS 11.50.FC6. > > Dave Does this answer your question: "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. Thefollowing 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" InformixIBM Informix Dynamic Server Administrator’s Reference (IDS 11.50), p. 11-14 Group 'informix' should have no members aside from user 'informix'. Or does this nostrum of Informix lore no longer hold?

Red, Thank you. Yes that would also work. This this would be needed on an ongoing basis I simply added it to the onconfig (ADMIN_MODE_USERS) as Kernoal suggested. Thank you, --Dave On Wed, Feb 22, 2012 at 9:08 AM, red_valsen <red_valsen@yahoo.com> wrote: > On Feb 20, 1:07 pm, Informix DBA <in4mix...@gmail.com> wrote: > > Hello, > > > > We have a need for a non-informix user to be able to connect to the > > Informix DB via dbaccess while the DB is in Single-User Admin Mode > (onmode > > -jy). We added the user to group informix on the UNIX server and the > user > > was also granted DBA privileges on the DB's. However the user gets the > > error, "27010: Only an administrative user or informix can connect in > > single user mode." What do we need to do to make the user an > > "administrative user" so they can connect in single-user mode? We are > > running IDS 11.50.FC6. > > > > Dave > > Does this answer your question: > > "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" > > InformixIBM Informix Dynamic Server Administrator’s Reference (IDS > 11.50), p. 11-14 > > Group 'informix' should have no members aside from user 'informix'. > Or does this nostrum of Informix lore no longer hold? > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >