Re: "enable indexes" & /tmp on UW2.1

In article <350905BE.5236DF3B@unisys.com>, Frank Clarijs <frank.clarijs@unisys.com> writes >In order to force Informix (7.2 on UnixWare 2.1) to recreate the indexes >from time to time, a script run weekly disables, then re-enables the >indexes in all tables of my database, one table at a time. > >This script runs fine, but now we get error messages from the OS, saying >that all /tmp space is used during this operation. Some tracing revealed >that this happens during the "alter table ... enable indexes" for the >biggest table. This table has some 3M rows, of 61 bytes per row. The >/tmp space is 50MB. It is all used (from being nearly empty at the start >of the operation). > >Has anyone some explanation for this ? How can I avoid this (because >filling /tmp completely is not really ideal for a Unix kernel ...) > Create a temporary dbspace (flag it as TEMP=Y or use -t option to onspaces. Then in ONCONFIG set DBSPACETEMP to this dbspace. >Frank Clarijs, Unisys Belgium -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care