Re: Informix help

Mr. AlMobeireek, I'm cc'ing the informix-list group to see if anyone can help you out. Perhaps someone will recognize the "Dropping temporary tblspace problem" +---------- message from rn.7614@rose.com ----------- | | Hi Mr. Isaacson, | I did enjoy reading your article "maxtab: Automatic file pruning", | SysAdmin March/April 1993. I noticed also that you working in informix and | fourgen field. | Mr Isaacson ... I apprecite if you can help me in this problem : | | We are using ONLINE 5.04 with fourgen 4.02 up to 4.12 releases. At one | point we find something eating our root data space. On average we are loosing | 2000 Pages a day!. so we should take the database off-line in order to | free them again. The logfile will contain thousands of line like this: | | 06:15:10 Dropping temborary tblspace 1000349, recovering 8 pages. | 06:15:10 Dropping temborary tblspace 100034a, recovering 8 pages. | 06:15:10 Dropping temborary tblspace 100034b, recovering 8 pages. | | We are trying to solve this problem with informix-UK with no luck! | and I know how difficult to figure out the problem with the little | facts I gave but I appreciate if you could gave comments. Also if | you can recommend any reference in informix administration and | where we can get advanced informix training ? | Thank you very much for your help. | | ====================================================================== | == Ahmed AlMobeireek P.O.BOX 55786, Riyadh 11544, Saudi Arabia == | == E-mail: rn.7614@rose.com Rosenet: Ahmed AlMobeireek@mideast == | ====================================================================== | -- ==================================================================== Steven G. Isaacson, Research & Development Voice: 800 444-3398 FourGen Software, Inc. Fax: 206 522-0054 Seattle, WA stevei@fourgen.com or uunet!4gen!stevei ====================================================================