dropping temp TBLspace

In article <6tlcvh$ju6$1@news.xmission.com>, Mark D. Stock <mdstock@informix.com> writes > >Allen Jantzen wrote: >> >> Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following >> appears in $INFORMIXDIR/online.log on the way back up > >What commands do you use to 'bounce' the engine? > >> 13:45:23 Dropping temporary TBLspace 300061, recovering 96 pages. >> 13:45:23 Dropping temporary TBLspace 3000c0, recovering 176 pages. >> 13:45:23 Dropping temporary TBLspace 3000c7, recovering 32 pages. >> 13:45:23 Dropping temporary TBLspace 300105, recovering 8 pages. >> 13:45:23 Dropping temporary TBLspace 300120, recovering 8 pages. >> 13:45:23 Dropping temporary TBLspace 300121, recovering 8 pages. >> 13:45:23 Dropping temporary TBLspace 300122, recovering 8 pages. >> 13:45:23 Dropping temporary TBLspace 300123, recovering 8 pages. >> 13:45:23 Dropping temporary TBLspace 300124, recovering 8 pages. >> 13:45:23 Dropping temporary TBLspace 300125, recovering 8 pages. >> 13:45:23 Dropping temporary TBLspace 300126, recovering 8 pages. >> 13:45:23 Dropping temporary TBLspace 300127, recovering 8 pages. >> ..................and so on>> >> Can anyone tell me what is causing this?? Is this a bad thing?? > >Not directly, but indicates transactions were not rolled back. > >> Aren't any temp tables created by a database process dropped when the >> process ends?? >> >> I am creating temp tables in a few processes w/ the NO LOG option. Is >> this the culprit? > >This is probably due to a little known change in the functionality of >some onmode options. Specifically the k option, which used to rollback >transactions for you, as in the u option. Now it does not, so rollback >is left to the fast recovery process. So you have two options: > > 1. onmode -ky Bring engine down quickly, no rollbacks > > 2. onmode -kuy Bring engine down after rollbacks finish > >Are you using number 1? If so, try number 2. > Huh? What!! When did this change? YOu mean I have to type another character (:->>) Plus change all my /etc/rc2.d/K99informix scripts on site!! GRRRRRR!! One more for tha FAQ.. >Hope that helps, -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care