DSXchange

Hi Friends,

i am getting following error:
Load_PA0000..TgtPA0000Tbl: Invalid pointer to stage user data
Internal Error: Function 'get_stage_prop' failed
Error opening file in 'Directory for Data and Command Files'

this is a bulk load job. can somebody tell me what can be the reason ans solution?

Seached in the forum but no luck.

You have specified a pathname in the "Directory for Data and Command Files" property in your bulk load stage but either this directory does not exist or the executing user does not have permission to create the control and data files therein.

Just for the record, what stage are you using for this "bulk load job"?

Hi,

I am using stage DB2_UDB load. We can run the job if the directory for

data and command files is changed. the folders have full privileges.

but still the error exists.

"The error exists" even if you change the directory? Or if you change the directory, everything is fine? If the latter, then obviously something is wrong with your first directory choice.

Hi,

Sorry for the Confusion
Actually the job runs fine if the directory is changed.
You may be right. i'll try to find what is the problem with the old directory and reply back.

Hi,

Please help me to solve this problem as this has become very critical.
Even after changing the directory for 'data and command files'.

is it datastage problem or OS problem? the folder is having privileges to the user running the jobs and also enough space is allocated to this.

Actually the job runs fine if the directory is changed

I believe if you can load from one directory and similar permissions exist for the same user, then u should be able to load from any other directory !
try going to the directory in UNIX prompt with that user and opening the file.
also 'type in manually' the directory name - hardcode it for testing purpose by removing any path parameters you are using .
UNIX is very case sensitive..

Hi All,

The problem is resolved. i found out that there was a file inpdata.dat
in the directory for data and command files . the job was failing because of this file. when i deleted then the bulk load job ran fine.

Though the problem is resolved can anyone tell me how this inpdata.dat file is created. and what is its use?

Thanks to all.

Apparently needed / created / used by the stage and (I assume) the user running the job didn't have permissions to delete it, so you needed to handle it manually.