DB2 Enterpirse Stage use /tmp directory to making temp file

dhwankim · Post by **dhwankim** » Thu May 11, 2006 12:21 am

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

vmcburney · Post by **vmcburney** » Thu May 11, 2006 12:46 am

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.

kumar_s · Post by **kumar_s** » Thu May 11, 2006 1:07 am

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

dhwankim · Post by **dhwankim** » Thu May 11, 2006 1:15 am

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.~~

ray.wurlod · Post by **ray.wurlod** » Thu May 11, 2006 2:20 am

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

ghila · Post by **ghila** » Thu May 11, 2006 3:20 am

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.

dhwankim · Post by **dhwankim** » Thu May 11, 2006 3:40 am

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.

kumar_s · Post by **kumar_s** » Thu May 11, 2006 4:43 am

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