Hi!At the weekend I watched the following webinar:
Informix Tutorial - Managing Informix Disk Space - Advanced DataTools
There´s one thing that I didn´t understand:
Hi!Also thanks for the fast response.Now I understand your solution: You create three temporary dbspaces an one "normal" dbspace and use this as temporary dbspace.One question else at this point:>Create at least 3 non-logged Temp DBspaces (min) – Informix will use them in round robin and in parallelHow exactly does this work, when the dbspace is full?e.g. tempdbs01 has 8GB and 7GB are used.Now I start my heavy "INTO TEMP" - Statement and this Statement needs 2GB (at tempdbs01).Run I into an "No free diskspace" error or does Informix uses tempdbs02/tempdbs03?
When it is full it is full, by default a temp table will not fragment across spaces. You could turn on auto extend ?
Generally you want to size all your spaces the same size. There are exceptions but a good starting point