Re: root dbspace full. Question?. Informix 5.00 UC3

Gabriel Leglise wrote: > > The aplications (Dbaccess) running on Informix 5.00 > UC3. > > In one moment the root dbspace is completed very fast > and > the others programs can=B4t run. > > Ej.: tbstat -d|grep rootdbs > > Space Free dbspace > 500000 470000 rootdbs=20 > Aplication xx > 500000 40 rootdbs > > The message is 'can not alloc space temp' or something > else. > > Somebody know about this. > > Can you Help me?? Yes, temporary tables, in Informix 5.xx, are created in the rootdbs as are sort work files if you do not set the DBTEMP environment variable in the application's (or for network connections in the sqlexecd, network demon's) environment. Increase the size of your root dbspace to allow for temp tables. Alternatively, if your logs are in the root dbspace you should/could create a dbspace just for them and move the logical and physical logs to the new dbspace. This will improve performance greatly as the logs will not contend for I/O bandwidth with the reserved pages and temp tables. Art S. Kagel