Removing IBM DB2 temporary files for failed DB2 load operation

https://www.ibm.com/support/pages/removing-ibm-db2-temporary-files-failed-db2-load-operation

Removing IBM DB2 temporary files for failed DB2 load operation

Question & Answer

Question

What is the safest way to remove DB2 temorary file for failed load operation ?

Cause

DB2 creates temporary binary files during load processing. These files are used for load crash recovery, load terminate operations, warning and error messages, and runtime control data. Load temporary files are removed when the load operation completes without error.

Answer

Failed load leaves load temporary files under TEMPFILES PATH. The temporary files written to this path must not be tampered with under any circumstances. Doing so causes the load operation to malfunction and places your database in jeopardy.

If you need to get rid of these files, you should ideally let load complete. If for some reason (eg. disk full) load fails, and you need to get rid of load temporary files, you should issue terminate load command. Command to terminate load can be the same as original load command, with 'insert' or 'replace' substituted with 'terminate'. Terminating load will clean the load temporary file.