Re: Temp DB space question

Temp size depends on various variables including size of your database and database server and space available, but no you should not combine your temp dbspaces into one. They are all used in parallel. While the server is in use try running onstat -D and onstat -g iof to see the use of temp dbspaces. Frank Testa > Hello everyone, > > What is good size for temp db space (Other than "depends on queries"). We > have tempsp1,tempsp2,tempsp3. When tempsp1 gets full, does Informix > automatically use tempsp2 and then 3. Should I combine them into one ? > Thanks > > Keith > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum