Re: ADMIN_USER_MODE_WITH_DBSA

What is the error....? I think sysadmin doesn't have CONNECT to Administrator.... Regards On Sun, May 11, 2014 at 6:12 PM, BillHatVerizon <garage_dba@verizon.net>wrote: > This is windows 2008 R2 server running IDS12.10TC2IE . > I have set these in onconfig and restarted ids ... > ADMIN_USER_MODE_WITH_DBSA 1 > ADMIN_MODE_USERS administrator> > But, when logged in as administrator I cannot open the sysadmin database in > dbaccess. > Should it work? > > The reason I need this to work is because I have a customer where user > informix cannot connect to sysadmin so I cannot rebuild sysmaster. > Therefore > the log shows errors nightly from some task. If I could make this work I > could > do it as administrator? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11c3a92052398004f923d92d

It starts out with this... 511: Cannot modify system catalog (systables). Error in line 1Near character position 23 It may refer to this in builddsmi.1n ... delete from systables where tabid > 99 and partnum < '0x100000'; delete from systables where tabname = 'sysdbspartn';close database; drop database sysmaster; The whole file (buildsmi_out.servicename) is Database selected. 511: Cannot modify system catalog (systables). Error in line 1Near character position 23 511: Cannot modify system catalog (systables). Error in line 1Near character position 23 Database closed. 425: Database is currently opened by another user. 107: ISAM error: record is locked. Error in line 1Near character position 22 Lockmode set. 330: Cannot create or rename the database. 100: ISAM error: duplicate value for a record with unique key. Error in line 30Near character position 33 Cleaning up whatever was successfully created Database selected. 511: Cannot modify system catalog (systables). Error in line 1Near character position 23 Database closed. -----Original Message----- From: Fernando Nunes Sent: Sunday, May 11, 2014 1:17 PM To: ids@iiug.org Subject: Re: ADMIN_USER_MODE_WITH_DBSA [32988] What is the error....? I think sysadmin doesn't have CONNECT to Administrator.... Regards On Sun, May 11, 2014 at 6:12 PM, BillHatVerizon <garage_dba@verizon.net>wrote: > This is windows 2008 R2 server running IDS12.10TC2IE . > I have set these in onconfig and restarted ids ... > ADMIN_USER_MODE_WITH_DBSA 1 > ADMIN_MODE_USERS administrator> > But, when logged in as administrator I cannot open the sysadmin database > in > dbaccess. > Should it work? > > The reason I need this to work is because I have a customer where user > informix cannot connect to sysadmin so I cannot rebuild sysmaster. > Therefore > the log shows errors nightly from some task. If I could make this work I > could > do it as administrator? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11c3a92052398004f923d92d ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, What version of Informix are you running? The purpose of the ADMIN_USER_MODE_WITH_DBSA and ADMIN_MODE_USERS parameters is to determine who can connect to the instance in single user mode. Docs here: http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.adref. doc%2Fids_adr_0018.htm They talk about "administration mode" but this means "single-user mode", aka "onmode -j", and it does not imply any administrator privileges other than being able to make a connection in this mode (if you have "grant connect"). For many purposes you can log in as user "informix" to sysmaster and run as a one-off "grant dba to administrator;" and then do admin function as "administrator" but from memory I don't think this works fully in the system databases before version 11.70. For "buildsmi.sql" specifically I am pretty sure this will not work unless you are "root" or "informix". Check out http://www-01.ibm.com/support/docview.wss?uid=swg21660680 Ben.

IBM Informix Dynamic Server Version 12.10.TC2IE But buildsmi.sql does not work as informix . Maybe something is messed up in the registry? Is there something in the registry as to who has DBSA privilege? -----Original Message----- From: BENJAMIN THOMPSON Sent: Tuesday, May 13, 2014 5:32 AM To: ids@iiug.org Subject: Re: ADMIN_USER_MODE_WITH_DBSA [32994] Hi, What version of Informix are you running? The purpose of the ADMIN_USER_MODE_WITH_DBSA and ADMIN_MODE_USERS parameters is to determine who can connect to the instance in single user mode. Docs here: http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.adref. doc%2Fids_adr_0018.htm They talk about "administration mode" but this means "single-user mode", aka "onmode -j", and it does not imply any administrator privileges other than being able to make a connection in this mode (if you have "grant connect"). For many purposes you can log in as user "informix" to sysmaster and run as a one-off "grant dba to administrator;" and then do admin function as "administrator" but from memory I don't think this works fully in the system databases before version 11.70. For "buildsmi.sql" specifically I am pretty sure this will not work unless you are "root" or "informix". Check out http://www-01.ibm.com/support/docview.wss?uid=swg21660680 Ben. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

DBSA is only relevant to single-user mode and user "informix" can always connect in this mode. If you're "informix" I would forget about the DBSA settings: they are not relevant. If "buildsmi.sql" does not work as user "informix", you have another problem as it only can work as "informix" or "root". On Windows there is no root user so I suspect this means just "informix" for you. Did you follow the short troubleshooting guide I posted a link to? I can't help any further given the information supplied. Consider raising a case with technical support or giving us more information. Why are you running "buildsmi.sql" in the first place? Is this a new instance? This is almost never necessary.

I did not want to run buildsmi but there is a failure in the log every day. I believe it all started when we got a new server and I had to install IDS on it so I used 12.10 (it was 11.70) . Since then, the buildsmi bat file runs every night and fails. With each upgrade, there are new columns in sysmaster so more error messages show up in the log. This is not affecting in use of the system but is really annoying since I can't fix it unless I can get buildsmi to run. -----Original Message----- From: BENJAMIN THOMPSON Sent: Tuesday, May 13, 2014 7:55 AM To: ids@iiug.org Subject: Re: ADMIN_USER_MODE_WITH_DBSA [32998] DBSA is only relevant to single-user mode and user "informix" can always connect in this mode. If you're "informix" I would forget about the DBSA settings: they are not relevant. If "buildsmi.sql" does not work as user "informix", you have another problem as it only can work as "informix" or "root". On Windows there is no root user so I suspect this means just "informix" for you. Did you follow the short troubleshooting guide I posted a link to? I can't help any further given the information supplied. Consider raising a case with technical support or giving us more information. Why are you running "buildsmi.sql" in the first place? Is this a new instance? This is almost never necessary. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.