11.11.2 Reducing the size of a work table DB area file
When you execute the SQL statement for creating a work table, the size of the work table might become very large depending on the contents of the SQL statements. If a work table DB area file is a regular file, the size of the regular file might become very large depending on the capacity of the work table, resulting in a shortage of available disk space.
If the size of a work table DB area file becomes too large, you can delete it. For details about how to delete work table DB area files, see (3) Reducing the size of the work table DB area files in 15.3.1 When a free space shortage is caused by an increase in the size of the DB area files.
The work table DB area files are stored under the DB directory ($DBDIR/ADBWRK).
- Important
-
When the size of the work table DB area file becomes too large, evaluate the contents of the SQL statements before you execute them.