Re: Errors dropping temp tables (2)

In article <01bd57c3$2bf5a500$16be6397@logos.ciipap>, Consorzio Idrico Piceno <ciipap@topnet.it> writes >I have this problem, and Informix Italy did not give me no answer >(I've been waiting since 50 days). >When bringing OnLine 7.20 on line, in the log file I see a series of errors >like this: > >Assert Failed: WARNING! pthdrpage:ptalloc:bad partn page >Who: Session(........) > Thread(.........)>Results: Cannot use TBLSpace page for TBLSpace 1049655 >Action: Run 'oncheck -pt 1049655' >See Also: /tmp/af.d35bc > >Running oncheck -pt I have a: 'Error opening TBLSpace'. >Looking in the af* file I see that it concerns some temp tables created by >the users with the 'create temp table'. These table should be destroyed >at the end of each user's session. Some tables perhaps have problems and >Informix >is not able to have back the space allocated for them (this is what I >think). >When the users' session are ended, Informix doesn't see anymore these >tables and so oncheck -pt can not be succesfull. >All the other oncheck I perform are OK (-cI,-cc,-cD,-ce,-cr). > >Each time I bring Informix on line I have the same errors. I CAN NOT drop >and recreate the dbspace (it is rootdbspace). Now I have created a tempdbs >to store these temp table. > >But How can I recover this space in rootdbs and stop with these errors ??? > You cannot. You could talk to Informix Technical Support and they may be able to help. >Thanks a lot in advance > > >Marco Traini > > -- 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