Question & Answer
Question
The Apply program tried to perform a load by using ASNLOAD, but ASNLOAD failed with the following error: "SQL3508N Error in accessing a file or path of type 'TEMP_FILE' during load or load query. Reason code: '1'."
Cause
This error occurs when the Apply program is started under a different user ID than the user ID that owns the DB2 instance. While ASNLOAD is processing, it calls the DB2 load utility, which runs under the DB2 instance. The DB2 load utility attempts to create directories and temporary files in the location where the Apply program is started, using the user ID that owns the DB2 instance. Unless the proper permissions have been granted, the SQL3508N error occurs.
Answer
For ASNLOAD to complete successfully, appropriate permissions must be given to the user account under which the Apply program runs. For example, in UNIX systems, first make sure that the user IDs for the DB2 instance and the Apply program are both members of a common group. Next, set the permission bits for the Apply program's starting directory to provide write access for the DB2 instance using the "chmod 775" command.
After the change is made you must stop and restart the DB2 instance for the change to take effect.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21160965