Re: Rollforward Database AHHHH HELP!!!! NOW!!!!!
Posted in 1995
> Right at this moment I am trying to roll forward an Informix SE (5.03) > database on a SCO UNIX System V 3.2.4.2 Box. > The database log file is 1.8 Mb and the database takes about 800Mb. > It has been running (i.e. the 'rollforward' statement) for about 4 hours > now and the database > have last been touched 4 hours ago. The system activity report (SAR) > shows no WIO or IDLE and > a lot of USR. The sqlexec process associated with the rollforward is > ticking over (now up to 240 Minutes) > > MY QUESTION IS: How do I tell if it is doing what it is supposed to be > or whether I have been waiting here for nothing!!!!!!!!!! H-E-L-P!!!!!!! It sounds to me as though you will be unable to complete the rollforward. This could be due to a number of reasons. Have you changed the schema since the last archive? Schema changes are not logged by the standard engine!!! Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc