Temp Table/dbspace problem
Posted in 1997
I am having a problem with an Informix application. The DBSpace that the application uses gets filled seemingly when large queries are performed. After the error occurs we have examined the DBSpace via TBMonitor and it is full. However when we add the sizes of all the tables reported to exist in that DBSpace only about half the space is accounted for. Within our application, any temporary table we create is created using 'CREATE TEMP TABLE' and 'WITH NO LOG'. Our understanding is that these tables would be created in the DBRoot's DBSpace. This space does not fill up. So I guess my question is does Informix create temporary tables in the application's DBSpace beyond those that we explicitly create? If so, how can we view them (using TBMonitor or anything)? Even more important, how do we flush them to recover our dataspace? Please reply to gpolicello@intrsoft.com Thanks! - George