Re: upgrade to 11.70.TC3IE from 11.70.TC1IE

So, something like OAT or Server Studio or some task scheduler function is accessing sysmaster preventing the initial DROP DATABASE command. If you have a time when you can take the server down to single user mode to rerun this. 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. On Wed, Aug 3, 2011 at 2:13 PM, Bill Hamilton <garage_dba@hotmail.com>wrote: > Thanks, Art. I feel much better. > When I used buildsmi.bat I got: > > Database selected. > > > 511: Cannot modify system catalog (systables). > Error in line 1> Near character position 23 > > 511: Cannot modify system catalog (systables). > Error in line 1> Near character position 23 > > Database closed. > > > 425: Database is currently opened by another user.> > 107: ISAM error: record is locked. > Error in line 1> Near character position 22 > > This file is the output of the dbaccess command in the shell script, > %INFORMIXDIR%\\etc\\buildsmi.bat. This script is run when IBM Informix > Dynamic Server (IDS) is first initialized. It builds the database and > tables which support the System Monitoring Interface. If you were > directed to see this file, a problem probably occurred while building > the database and/or its tables and views. See below for more > information regarding any problems. > > Problems may have occurred if IDS was shutdown after initialization > but before the entire database was created. If this was the case, > login as 'informix', rerun 'oninit', and wait for the message > > "'sysmaster' database created successfully" > > to appear in the IDS message log before shutting down. Once it is > created successfully, it should never need to be recreated. > > > > Lockmode set. > > > 330: Cannot create or rename the database.> > 100: ISAM error: duplicate value for a record with unique key. > Error in line 30> Near character position 33 > Cleaning up whatever was successfully created > > Database selected. > > > 511: Cannot modify system catalog (systables). > Error in line 1> Near character position 23 > > > Database closed. > > > *From:* Art Kagel <art.kagel@gmail.com> > *Sent:* Wednesday, August 03, 2011 12:24 PM > *To:* Bill Hamilton <garage_dba@hotmail.com> > *Cc:* informix-list@iiug.org > *Subject:* Re: upgrade to 11.70.TC3IE from 11.70.TC1IE > > Nope, you did it correctly. Windows won't let you install multiple > versions of Informix, so on Windows you have to uninstall first. Next time > tell the installer to not create a default instance to save time and disk > space (for the dummy rootdb space that you won't need). There seems to have > been one error during the conversion to .TC3, the sysmaster database rebuild > failed: > 20:31:21 Error building 'sysmaster' database.> Not uncommon during an upgrade. Not to worry, you can rebuild it > manually. Find the buildsmi.bat script in the %INFORMIXDIR%\\etc folder and > execute it. The server can be fully online and being used by users when you > do this, no worries. Normal user applications do not access sysmaster at > all. > > 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. > > > > On Wed, Aug 3, 2011 at 12:42 PM, Bill Hamilton <garage_dba@hotmail.com>wrote: > >> I was unable to get 11.70.TC3IE to install over the 11.70.TC1IE >> installation so I uninstalled TC1, leaving the spaces, >> installed TC3, let it create and instance, and then shutdown, edit the >> config to change the ROOTPATH and ROOTSIZE to agree with the old spaces from >> TC1 and then restart IDS . >> At first I thought it had crashed, but the next day I found all 7 dbspaces >> and everything seems to work. >> Is this the proper procedure for doing this? >> Or Is this just a miracle that I got for the good Karma I had saved up? >> >> The log has stuff like this: >> 20:30:42 Conversion from version 11.70 Started >> 20:30:45 A restore point was created and data is being stored in >> directory C:\\Informix\\tmp/13. >> 20:30:46 IBM Informix Dynamic Server Initialized -- Shared Memory>> Initialized. >> 20:30:48 Init operation complete - Mode Quiescent >> 20:30:48 Conv/rev: Started check phase of conversion for component RSAM >> 20:30:48 *** RSAM 1 11.70xC3 *** >> 20:30:48 Conv/rev: Finished check phase of conversion for component RSAM >> 20:30:48 Conv/rev: Started check phase of conversion for component SQL >> 20:30:48 Conv/rev: Finished check phase of conversion for component SQL >> 20:30:48 Conv/rev: Started check phase of conversion for component SMI >> 20:30:48 Conv/rev: Finished check phase of conversion for component SMI >> 20:30:48 Conv/rev: Started check phase of conversion for component BAR >> 20:30:48 *** BAR 1 11.70xC3 *** >> 20:30:48 Conv/rev: Finished check phase of conversion for component BAR >> 20:30:48 Conv/rev: Started check phase of conversion for component PLOAD >> 20:30:48 Conv/rev: Finished check phase of conversion for component PLOAD >> 20:30:48 Conv/rev: Started check phase of conversion for component RTREE >> 20:30:48 Conv/rev: Finished check phase of conversion for component RTREE >> 20:30:48 Conv/rev: Started check phase of conversion for component SECURE >> 20:30:48 Conv/rev: Finished check phase of conversion for component>> SECURE >> 20:30:48 Conv/rev: Started check phase of conversion for component SCHAPI >> 20:30:48 *** SCHAPI 1 11.70xC3 *** >> 20:30:48 Conv/rev: Finished check phase of conversion for component>> SCHAPI >> 20:30:48 Conv/rev: Started check phase of conversion for component HA >> 20:30:48 *** HA 1 11.10xC1 *** >> 20:30:48 *** HA 1 11.50xC1 *** >> 20:30:48 *** HA 1 11.50xC6 *** >> 20:30:48 Conv/rev: Finished check phase of conversion for component HA >> 20:30:48 Conv/rev: Started conversion for component RSAM >> 20:30:48 *** RSAM 1 11.70xC3 *** >> 20:30:48 Checkpoint Completed: duration was 0 seconds. >> 20:30:48 Tue Aug 02 - loguniq 110, logpos 0x2d140b4, timestamp:>> 0x1875816e Interval: 17374 >> >> 20:30:48 Conv/rev: Finished conversion for component RSAM >> 20:30:48 Conv/rev: Started conversion for component SQL >> 20:30:48 processing sysmaster >> 20:30:48 *** SQL 1 11.70xC3 ***@@