What are the writes on temporary table spaces during the load phase of a LOAD command ?

Question

This document explains the writes on temporary table spaces during the load phase of a LOAD command

Answer

Question:

During the load phase of a LOAD command, I've seen writes against the temporary table spaces. What are those writes?

Answer:

During the first phase (the load phase ) of a LOAD command, two things happen:

1. Rows are written into the target table
2. Index entries are inserted into sort areas (one for each index)

So writes on temporary table spaces may happen during this phase, if sort spills happen on step 2.

To minimize these writes, make sure you have configured adequately your SORTHEAP and SHEAPTHRES, and also that the temporary table spaces have large enough buffer pools.

http://www-01.ibm.com/support/docview.wss?uid=swg21211165

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdoc%2Fc0004605.htm