Re: Temporary Space Issue

In article <01bd9a08$c42fe150$57011814@willie>, Willie L. Meeks <wmeeks@harrahs.com> writes >Greetings all, > >I have a problem related to temporary dbspace usage. It is a known bug in >7.14 related to temporary spaces not rolling i.e.( When a query attaches to >a temporary space it will not roll to the next temporary space). > >Example currently I have 11 temporary dbspace defined. Each space is >approixmately 4 GB. If a query attacheds to temp1 it will not roll to the >other temporary space that are defined in the onconfig file >DBSPACETEMP=temp1,temp2,temp3,temp4,temp5,temp6,temp7,temp8,temp9,temp10,tem >p11. > >We use a tremendous amount of temporary because of the massive aggregate >functions,joins we use in decision support queries. Any function that >requires temporary space we use very heavily. > >Does anyone know of any workarounds or possible solutions to this issue? > Which platform? I would upgrade to at least 7.24... >Regards, > >Willie Meeks >Database Administrator, >wmeeks@harrahs.com -- 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