When you use the 'tempfiles path $PATH' option, are you asking LOAD not to use temp tablespace and use just the space in the filesystem to create its files? If thats not the case, does it use both temp tablespace and tempfiles in a path? Is there a way to gauge how much space (temp space) is used by LOAD when loading a table?

Thanks

This parameter tells db2 where to store load temporary files (they'll be stored under the db directory/load by default). These temp files are used when restarting/terminating a failed load operation.