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.
Related Information
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
9.7, 9.5
Operating system(s):
AIX, Linux, Windows
Document number:
513763
Modified date:
16 June 2018