Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi Gurus,
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.
Thanks,
Kamesh
Run onstat -u and onstat -g ses for each session.
There must be an application creating temp tables or doing queries that
take a long time and are not using indexes.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.