Re: rootdbs eaten up

svenni@strengur.is (Sveinn Sveinsson) writes: >I have set up an On-Line instance on AIX with a small rootdbs, 40MB. >Over a period of two months this space is eaten up so the system must be >shut down. When the system comes up it logs numerous entries like: > 22:24:47 Dropping temporary tblspace 1000003, recovering 8 pages. >This adds exactly up to the missing space. These tblspaces, however do not >show up when I do tbcheck -pe before the shutdown. The problem _probably_ originates with temporary tables created implicitly, as part of SQL queries (order by, etc), but not dropped automatically, as they should. INFORMIX support could tell you _exactly_ what the problem is... :} > a) there is a fix? There was when I encountered the problem in 4.0 on an AT&T StarServer..."upgrade to 4.01.UE3" (or thereabouts). > b) there is a better workaround than shutting down? Not that I know of... William G. Hudacek Internet: whudace@andy.bgsu.edu 372-2911 (department) University Computer Services (Hayes Hall, Rm 332) Bowling Green State University Bowling Green, OH 43403 -- William G. Hudacek Internet: whudace@andy.bgsu.edu 372-2911 (department) No Phone ;-( (office) University Computer Services (Hayes Hall, Rm 332) Bowling Green State University Bowling Green, OH 43403