DSXchange

Hi All,

I Now use db2 enterpise stage for loading data with write method "load".
then My Concern is that Each Job exhaused "/tmp" for making tempaory file, msg and error file also.

My machine is allocated small size volume for /tmp.

So I want to change direcotr /tmp to /disk01/tmp

How can i configure this.

Thanks in advance.


(dsadm) dwmsr06:/tmp/DB200021.PID/DB20010F.OID> ls -al
total 128
drwxrwxrwx 2 dwinst db2adm 4096 May 09 14:41 .
drwxrwxrwx 6 dwinst db2adm 4096 May 11 15:04 ..-rwxrwxrwx 1 dwinst db2adm 11216 May 09 14:41 load0007.CT1
-rwxrwxrwx 1 dwinst db2adm 11216 May 09 14:41 load0007.CT2
-rwxrwxrwx 1 dwinst db2adm 408 May 09 14:41 load0007.msg
-rwxrwxrwx 1 dwinst db2adm 11216 May 09 14:41 load0013.CT1
-rwxrwxrwx 1 dwinst db2adm 11216 May 09 14:41 load0013.CT2
-rwxrwxrwx 1 dwinst db2adm 408 May 09

The temp directory setting is under the project environment variable settings in the DataStage Administrator and is set for each project. I think this is the one the DB2 load will use.

Datastage Adminstrator cleint --> Project --> Properties -- > Environment -- >General ---> TMPDIR

kumar_s wrote:Datastage Adminstrator cleint --> Project --> Properties -- > Environment -- >General ---> TMPDIR

I changed This Parameter /tmp ==> /disk1/dstmp already But result is same.

PLS Help me.~~

Is there a property in the DB2 Enterprise stage that allows you to set the temporary directory? Or a DB2 environment variable?

Hello,

I think that if you have not configured the DB2 Enterprise Options, the stage is using the /tmp directory by default for Local Message files and other DB2 load files. You can add the "Message File" options, available in the stage and use your own directory.

ghila wrote:Hello,

I think that if you have not configured the DB2 Enterprise Options, the stage is using the /tmp directory by default for Local Message files and other DB2 load files. You can add the "Message File" options, available in the stage and use your own directory.

I configured the DB2 enterprise option ("Message File") but onley Message file can located in a specific directory. Error File during execting is located in /tmp. I can not control this file
Actually I wanna change error file location.

Also just check whether, the db2 temp directory is pionting to the same. Check in ../sqlib/db2profile or with DBA.