Re: ADMIN_USER_MODE_WITH_DBSA

Here's an option: If the database(s) are not too big, you could export them all and use dbschema -c to create a script to recreate the dbspaces, logs, etc. Then reinitialize the instance from scratch using v12.10, rebuild the spaces and logs, and import the databases. That will give you a clean instance with no 11.70 legacy remaining. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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. On Tue, May 13, 2014 at 9:07 AM, BillHatVerizon <garage_dba@verizon.net>wrote: > 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. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113499087c0a7c04f947ee01

thought of that too. Sounds painful/risky for a seemingly minor issue. -----Original Message----- From: Art Kagel Sent: Tuesday, May 13, 2014 8:21 AM To: ids@iiug.org Subject: Re: ADMIN_USER_MODE_WITH_DBSA [33003] Here's an option: If the database(s) are not too big, you could export them all and use dbschema -c to create a script to recreate the dbspaces, logs, etc. Then reinitialize the instance from scratch using v12.10, rebuild the spaces and logs, and import the databases. That will give you a clean instance with no 11.70 legacy remaining. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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. On Tue, May 13, 2014 at 9:07 AM, BillHatVerizon <garage_dba@verizon.net>wrote: > 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. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113499087c0a7c04f947ee01 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.