DB2 load option error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dh_Madhu
Premium Member
Premium Member
Posts: 65
Joined: Sat Apr 23, 2005 3:19 am
Location: Stirling, Scotland

DB2 load option error

Post 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!
Regards,
Madhu Dharmapuri
dh_Madhu
Premium Member
Premium Member
Posts: 65
Joined: Sat Apr 23, 2005 3:19 am
Location: Stirling, Scotland

Post by dh_Madhu »

Pointing the Message file option to the /tmp directory solved the issue.
Looks like the default directory had no write permission.
Regards,
Madhu Dharmapuri
Post Reply