tablespace does not have enough free space error#
Overview#
Insufficient tablespace
Version#
Altibase version 4 or later
Cause#
This error is caused by the insufficient size of a specific tablespace.
Solution#
-
Check the tablespace space usage.
Use the appropriate query statement for the version of Altibase you are using to check the usage.
Reference
-
After querying the tablespace usage, add space to the tablespace with USAGE(%) close to 100% in the query result.
iSQL> ALTER TABLESPACE tablespace name add datafile '/path/filename' size 2G autoextend off;
Reference#
When adding a data file, the tablespace is locked, so it is recommended to block the service and work.
For Altibase 5.3.3 or earlier, select and DML and queries will wait for the tablespace add operation to complete.
From Altibase 5.5.1 or later to the latest Altibase 6, DML waits until the tablespace addition operation is completed, but the select statement is executed normally.