Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Unanswered: Regarding LOAD ...

    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?


  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts