Re: Growing dbspace

On Fri, 19 Jan 2001 app@not.allowed wrote: > Dear Informix experts, > > I have problem with my dbspace that suddenly growing in size . Within one > night it grows by almost 40,000 pages where in normal case should be > between 1000 - 2000 pages daily. > Do you think because of temporary tables stuck in the process and how do I > eliminate those unused temporary data besides using dbexport/dbimport ? > Does Informix has some utility to clean up those junks ? > > Thanks in advance for your advice. > Temporary tables should be stored in temp dbspaces, or default to /tmp in Unix systems. They should not be filling up production spaces anyway. I'd be checking with your software people to see what the application is doing. john