db2 'The filesystem is full'
Hi,
CLM 4.0.4
DB2 9.7
OS - Linux
[root@ilclm bin]# ./db2 \? sql0968
SQL0968C The file system is full.
Explanation:
One of the file systems containing the database is full. This file
system may contain the database directory, the database log files, or a
table space container.
The statement cannot be processed.
User response:
Free system space by erasing unwanted files. Do not erase database
files. If additional space is required, it may be necessary to drop
tables and indexes identified as not required.
On unix-based systems, this disk full condition may be due to exceeding
the maximum file size allowed for the current userid. Use the chuser
command to update fsize. A reboot may be necessary.
This disk full condition may be caused when containers are of varying
sizes. If there is sufficient space in the file system, drop the table
space and recreate it with containers of equal size.
If the statement that could not be processed referenced LOB data types:
* Ensure that any cursors used in the application are closed
immediately after their use.
* Ensure that within the application that COMMIT statements are
periodically executed.
* Add additional containers to the system temporary tablespace to hold
the temporary LOB data during this statement's execution.
sqlcode: -968
sqlstate: 57011
I have checked the file system size and it seems like not full. Therefore, I want to check the second suggestion.
Unfortunately, I don't have db2 experience. I would appreciate your assistance.
Thanks,
Liora