Re: upgrade to 11.70.TC3IE from 11.70.TC1IE
Posted in 2011
Topics: Installation, Setup & Upgrades, Storage & Space Management, Error Codes & Troubleshooting, Server Administration, Logging & Checkpoints, Third-Party Tools & Monitoring, Versions, Editions & End-of-Life
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 ***@@