Re: IDS7.31 upgrade conversion

roswil@my-deja.com wrote: > > In article <88puem$imu$1@news.xmission.com>, > "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> wrote: > > > > David Williams wrote: > > > > > > In article <88n0m3$7vd$1@nnrp1.deja.com>, roswil@my-deja.com writes > > > >How do you know when the last conversion is done when upgrading to > > > >IDS7.31 ? The last conversion, " external conversion " , does not > > > >display a completion message. > > > > > > > >aThe last lines are : > > > >Internal conversion completed, performing external conversion ... > > > >'sysutils' database built successfully. > > > >Checkpoint Completed: duration was 1 seconds. > > > > > > > >Nothing appears to say the external conversion is done, so how do > you > > > >know? thanks > > > > > > > > > > It appears to be done once the checkpoint record is written. I > think > > > that the sysutils database built successfully is the actual > messages. > > > > > > Wait for the checkpoint completed message and run > > > > > > onstat -u > > > onstat -g ath> > > > > > and make sure no sessions/strange threads are running.. > > > > Yes, it's a bit disconcerting isn't it? Did an upgrade this weekend > and > > got exactly the same thing. There were no threads running, and > > everything seemed okay, so assumed the best. > > > > Cheers, > > -- > > Mark. > > > It is disconcerting ; especially when you are told to expect the > conversion to take hours and within only seven minutes the message log > displays the 'sysutils database built successfully' and 'Checkpoint > completed' messages and the instance is idle after that - I didn't expect an upgrade from 7.30 to 7.31 to take long. I think the messages were just missed out. > I have left > the instance sit for 44 hours and the only change displayed > by ' onstat -p ' is in the number of flushes(which is also a bit > disconcerting; any explanation why an inactive instance does about 25 > flushes/hour ? . I don't know about the flushes. > The database which I upgraded from IDS7.30UC7 to > IDS7.31FC4(Unix 64bit) is 60GB ; I upgraded from 7.30.FC8 to 7.31.FC5-1. So you are different going from 32 bit to 64 bit. I chose my smallest site first so that I could limit the damage if there was any. ;-) > what is the size of the database(s) > you upgraded and how much time did it take for the conversions to > complete ? thanks again! My instance has only one database of about 37 Gb. The upgrade was less than half an hour, and I did it remotely via dial-up (not to be flash, but to save the 2.5 hour round trip :), so I am not sure exactly when it finished. I have to do my 3 other sites now, all in different countries, some on 7.24.FC5, the largest being 60 Gb. These will all be done from my home office as well. :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+