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
DB2 Enterpirse Stage use /tmp directory to making temp file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 fileghila 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.
Actually I wanna change error file location.