DB2 Load report File system full

Using the DB2 load to import data data is relatively large the file system is often reported full error.

Cause Analysis: The import table is indexed, and the load's "index Replication" phase is copied from the system temp table space to the target tablespace, causing the system temporary table space to be full, the load is not completed, and the table state becomes load pending

WORKAROUND: 1. Terminate load with terminate in load to make the table State Normal (load from Abc.txt of del terminate into table name)

2. Delete Table index

3. Importing data with Load

4. Create an index

You can also increase the use of temporary table spaces.

DB2 Load report File system full