Re: IDS7.31 upgrade conversion

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. +----------------------------------------------------------+-----------+ | 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 |/ ////////| +----------------------+-----------------------------------+-----------+

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. > > +----------------------------------------------------------+---------- -+ > | 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 |/ ////////| > +----------------------+-----------------------------------+---------- -+ > 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 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 ? . The database which I upgraded from IDS7.30UC7 to IDS7.31FC4(Unix 64bit) is 60GB ; what is the size of the database(s) you upgraded and how much time did it take for the conversions to complete ? thanks again! Sent via Deja.com http://www.deja.com/ Before you buy.