Temporary Space Issue
Posted in 1998
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? Regards, Willie Meeks Database Administrator, wmeeks@harrahs.com