Page 1 of 1

DB2 load option error

Posted: Wed Oct 24, 2007 4:32 am
by dh_Madhu
Hi,
Using db2 stage, while an insert is attempted by using the write method 'Load', a fatal error occurs hinting at the following...

DB2 Load Binary Error.
Error in accessing a file or path of type "TEMP_FILE" during load or load query. Reason code: "1".

....while the other write methods run successfully.
Is this pointing the lack of any special user rights or configurations that needed to be done?
Please advise.
Many thanks!

Posted: Wed Oct 24, 2007 5:12 am
by dh_Madhu
Pointing the Message file option to the /tmp directory solved the issue.
Looks like the default directory had no write permission.