Re: Update statistcis high and TEMP-spaces needed

dkabrbwj@e-mail.com wrote: > > Hi > Any one know a way to calculate the size of temp spaces needed > to run a update statistics high. I am using AIX 4.2.1 and Informix SE > 7.14UD1. > My /tmp is 65MB and the size of the database is 1.2GB but one of the > tables is more than 500MB. > Thanks in advance. > > Bjarne Wilken Jensen /Alm. Brand Denmark Hi, try to set the environment variable "DBUPSPACE=60000" KB. This value should reduce the amount of space used for an UPDATE STATISTICS HIGH to appr. 60MB. The limit will be ignored if you have a single table-column, that needs more than 60MB. Generally it's better to run column specific UPDATE STATISTICS HIGH(col1) statements. On large table it's enough to run UPDATE STATISTICS MEDIUM - this will reduce the space neededfor the temporary files. Bye Stefan