Hi Nadya,

>Hi everyone,
>
>I'd like to know, how to prevent the System Error message "Not enough disk space" for the operations like ALTER TABLE for the huge tables.

Get bigger hard drive. :)


>I wrote an application, called DataDict, which we use for updating our databases (if we knew about Stonefield earlier, we would use it instead, perhaps). My colleague told me, that she had this Error on her machine. I'd like to know, how can I check, what amount of space is needed, just before ALTER TABLE command? The same for INDEX ON command.

ALTER TABLE makes a new table with changed structure and leaves the old one as .BAK. At minimum you need the same amount of free space as your source table occupies + (new_field_size * reccount()) + some_more_just_in_case. INDEX ON should takes less space (depending on number of indexes), but I would go with at least the table size space. Anyway, it is not safe to run the application with not much free space available.

Some other commands may require even more space, for example if you use SORT command the disk space needed to perform a sort can be as much as three times the size of the source table. You can check the amount of available disk space with DISKSPACE() and SYS(2020) functions.