File system storing database tables runs out of space

This problem occurs on systems running AIX 5.x.

Problem

The file system storing the database table spaces runs out of space. This is shown by the following kinds of errors as seen in the DB2 log called db2diag.log:

2005-11-06-12.59.10.815891-420 E36562387C690      LEVEL: Error
PID     : 176316               TID  : 1           PROC : db2pclnr 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, 
          probe:0
MESSAGE : ADM6017E  The table space "TPCTBSPTEMP" (ID "5") is full. 
          Detected on 
          container "/home/db2inst1/db2inst1/TPCDB/TPC/TPCTBSPTEMP" 
          (ID "0").  
          The underlying file system is full or the maximum allowed 
          space usage 
          for the file system has been reached. It is also possible 
          that there 
          are user limits in place with respect to maximum file size 
          and these limits have been reached.

This problem is seen on AIX 5.x with JFS file system. Large files need to be enabled on the file system because the table space files can get quite large. Enable large files on JFS or JFS2.

Action

During installation of AIX 5.1 or later, ensure that JFS or JFS2 with large file system support is installed. Follow the AIX documentation for this purpose as well as to back up and restore data between file systems. It is recommended to ensure that the file system size (especially for /home) is not too small (for example, not less than 4 GB). Back up your existing data before you recreate your file system. For information about file systems, see: http://www-01.ibm.com/support/knowledgecenter/ssw_aix_53/com.ibm.aix.baseadmn/doc/baseadmndita/fs_types.htm.

Alternatively, you can set the DIAGPATH and SPM_LOG_PATH variables to point to an external, fast disk drive.