upgrade to 11.70.TC3IE from 11.70.TC1IE
Posted in 2011
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: Started conversion for component BAR
20:31:21 *** BAR 1 11.70xC3 ***
20:31:21 WARNING:Target server version must have a certified Storage Manager installed after conversion/reversion and before bringing up server.
20:31:21 Conv/rev: Finished conversion for component BAR
20:31:21 Conv/rev: Started conversion for component PLOAD
20:31:21 Conv/rev: No Conversion/Reversion needed for component PLOAD
20:31:21 Conv/rev: Finished conversion for component PLOAD
20:31:21 Conv/rev: Started conversion for component RTREE
20:31:21 *** RTREE 1 9.40xC1 ***
20:31:43 Conv/rev: Finished conversion for component RTREE
20:31:43 Conv/rev: Started conversion for component SECURE
20:31:43 *** SECURE 1 11.70xC3 ***
20:32:08 Conv/rev: Finished conversion for component SECURE
20:32:08 Conv/rev: Started conversion for component SCHAPI
20:32:08 *** SCHAPI 1 11.70xC3 ***
20:32:08 Booting Language <spl> from module <>
20:32:08 Loading Module <SPLNULL>
20:32:09 Conv/rev: Finished conversion for component SCHAPI
20:32:09 Conv/rev: Started conversion for component HA
20:32:09 *** HA 1 11.10xC1 ***
20:32:09 *** HA 1 11.50xC1 ***
20:32:09 *** HA 1 11.50xC6 ***
20:32:09 Conv/rev: Finished conversion for component HA
20:32:09 Conversion Completed Successfully
20:32:09 On-Line Mode
20:32:09 SCHAPI: Started dbScheduler thread.
20:32:09 Checkpoint Completed: duration was 1 seconds.
20:32:09 Tue Aug 02 - loguniq 110, logpos 0x3553018, timestamp: 0x1877738e Interval: 17377
20:32:09 Maximum server connections 0
20:32:09 Checkpoint Statistics