This box lists the directories to be used to store the temporary files that are used when indexes are created. Use the Add push button to add a name to this box. You can also select a name to be changed, removed, or rearranged.
If you do not specify directories, the files are created in the sqllib/tmp directory of the DB2INSTANCE owner. If you specify more than one directory, each directory should be on a different file system, and each file system should be on a different disk, to optimize performance.
Make sure that there is enough space on these directories to hold all index keys for the data being loaded.
[ Top of Page | Table of Contents | Glossary | Index ]