Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Single-User Administrative Mode
610 views
Skip to first unread message
Informix DBA
Feb 20, 2012, 1:07:29 PM2/20/12
to IIUG Informix List
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
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
Art Kagel
Feb 20, 2012, 2:32:03 PM2/20/12
to Informix DBA, IIUG Informix List
Have the user connect using an explicit login and password instead of an implicit connection. That may help.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
red_valsen
Feb 22, 2012, 9:08:54 AM2/22/12
to
"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 DBA
Feb 22, 2012, 3:28:16 PM2/22/12
to red_valsen, inform...@iiug.org
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
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
0 new messages