If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
I am facing a strange problem with informix database growth patterns.
We are using Version 9.21.UC7XO for our application database.
Normally application tables grow at rate of 1% per day. But recently we
hit with 80% growth in database within a week time. Comparing the application data tables size dump taken at start and end of this period showed normal growth only.
Suspecting some temporary tables eating up db space and causing rapid growth. Find some tables in our application database created with name like:
_temptable
3116_2401
3130_2414
These are occupying considerable space in dbspace.
Please help me in understanding what these tables are and how they will be created and their impact.