Re: upgrade to 11.70.TC3IE from 11.70.TC1IE

Thanks, Art. I feel much better. When I used buildsmi.bat I got: 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 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 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. From: Art Kagel Sent: Wednesday, August 03, 2011 12:24 PM To: Bill Hamilton 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 *** 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