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 *** > 20:30:48 Converting database sysmaster ... > 20:30:49 The database sysmaster has been converted successfully. > 20:30:49 *** SQL 1 11.70xC3 *** > 20:30:49 processing cheer > 20:30:49 *** SQL 2 11.70xC3 *** > 20:30:49 Converting database cheer ... > 20:30:50 The database cheer has been converted successfully. > 20:30:50 *** SQL 2 11.70xC3 *** > 20:30:50 The dummy updates succeeded while converting database cheer. > 20:30:50 processing sysadmin > 20:30:50 *** SQL 3 11.70xC3 *** > 20:30:50 Converting database sysadmin ... > 20:30:50 The database sysadmin has been converted successfully. > 20:30:50 *** SQL 3 11.70xC3 *** > 20:30:51 The dummy updates succeeded while converting database sysadmin. > 20:30:51 processing sysutils > 20:30:51 *** SQL 4 11.70xC3 *** > 20:30:51 Converting database sysutils ... > 20:30:51 The database sysutils has been converted successfully. > 20:30:51 *** SQL 4 11.70xC3 *** > 20:30:51 processing sysuser > 20:30:51 *** SQL 5 11.70xC3 *** > 20:30:51 Converting database sysuser ... > 20:30:51 The database sysuser has been converted successfully. > 20:30:51 *** SQL 5 11.70xC3 *** > 20:30:51 The dummy updates succeeded while converting database sysuser. > 20:30:51 processing team > 20:30:51 *** SQL 6 11.70xC3 *** > 20:30:51 Converting database team ... > 20:30:52 The database team has been converted successfully. > 20:30:52 *** SQL 6 11.70xC3 *** > 20:30:52 The dummy updates succeeded while converting database team. > 20:30:52 processing demo > 20:30:52 *** SQL 7 11.70xC3 *** > 20:30:52 Converting database demo ... > 20:30:52 The database demo has been converted successfully. > 20:30:52 *** SQL 7 11.70xC3 *** > 20:30:53 The dummy updates succeeded while converting database demo. > 20:30:53 processing mgt > 20:30:53 *** SQL 8 11.70xC3 *** > 20:30:53 Converting database mgt ... > 20:30:53 Defragmenter cleaner thread now running > 20:30:53 Defragmenter cleaner thread cleaned:0 partitions > 20:30:53 The database mgt has been converted successfully. > 20:30:53 *** SQL 8 11.70xC3 *** > 20:30:54 The dummy updates succeeded while converting database mgt. > 20:30:54 Conv/rev: Finished conversion for component SQL > 20:30:54 Conv/rev: Started conversion for component SMI > 20:30:54 *** SMI 1 11.70xC3 *** > 20:30:54 Build of sysmaster and sysutils databases Started > 20:30:54 Converting/Rebuilding 'sysmaster' database ... > 20:30:54 Single-User Mode. > 20:31:20 Checkpoint Completed: duration was 1 seconds. > 20:31:20 Tue Aug 02 - loguniq 110, logpos 0x3469018, timestamp: 0x18776731> Interval: 17376 > > 20:31:20 Maximum server connections 0 > 20:31:20 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked> 0, Plog used 2003, Llog used 1875 > > 20:31:21 Error building 'sysmaster' database. > 20:31:21 See 'C:\\Informix\\etc\\buildsmi_out.IDS1170'. > 20:31:21 Init operation complete - Mode Online Initialized > 20:31:21 Conv/rev: Finished conversion for component SMI > 20:31:21 Conv/rev: Sta