KB#01004-Setting the directory path where temporary files can be placed for SQL Query sorts

Title:

Setting the directory path where temporary files can be placed for SQL Query sorts

Description:

Q.) Where can I define the directory for the temporary sort files created when doing an SQL Query?

Resolution:

The SQL engine creates the temporary sort file(s) in the system's temp directory. 

You should be able to change this by adding the following option to the JVM args in the Enterprise Manager: 

        -Djava.io.tmpdir=/path/to/my/tempdir 

So, if you currently have: 

        -Xmx512m 

You would now have: 

        -Xmx512m -Djava.io.tmpdir=/path/to/my/tempdir 

Last Modified: 02/24/2004 Product: BBj Operating System: All platforms

BASIS structures five components of their technology into the BBx Generations.