...
Overview
...
Insufficient tablespace
Version
...
ALTIBASE HDB version 4 or later
Cause
...
This error is caused by the insufficient size of a specific tablespace.
Solution
...
1. Check the tablespace space usage.
Use the appropriate query statement for the version of Altibase you are using to check the usage.
| Code Block |
|---|
https://aid.altibase.com/display/FAQE/8.+Monitoring |
2. After querying the tablespace usage, add space to the tablespace with USAGE(%) close to 100% in the query result.
| Code Block |
|---|
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 HDB 5.3.3 and earlier, select and DML and queries will wait for the tablespace add operation to complete.
From HDB 5.5.1 or later to the latest V6, DML waits until the tablespace addition operation is completed, but the select statement is executed normally.