Error Occuring while using DB2 UDB Bulk Load .

[dsouza.adithfrancis]

Hi ,

I am using the DB2 UDB Load stage to load data from a Sequential file to DB2 database using DB2 UDB Bulk Load .I have given the Source file name in the DB2 stage against'Directory for Data and Command Files'

Error Message :
Internal Error: Function 'get_stage_prop' failed
Property 'Directory for Data and Command Files' value not found


For better Understanding :

Load Method : Sequential file
Load Immediate :YES
Laod From Client : YES
Directory for data and command files : #I have mentioned Directory path with the source file Name#
File Type of the data format : DEL
Method : L
Column start Column end : 1 16,17 19,20 25 etc
insert column : Col1, Col2, Col3
Load Mode : INSERT
Local Message File Name : TEST.txt

Please let me know how this can be fixed .

[dilip.datastage]

Please refer online documents

[ArndW]

...Directory for data and command files : #I have mentioned Directory path with the source file Name#...

What exactly did you enter here; since the error message refers to this value this is where we should be looking.

[dsouza.adithfrancis]

Hi,
I had mentioned the path of the source file and the file name from where data has to be Loaded.

DB2 UDB Properties:
Directory for data and command files : \edw\corp\stg\landing\BMD_SALES.txt
Eg :
Path :\edw\corp\stg\landing\ * Path where the file is located*
File name : BMD_SALES.txt * Source File Name*

[ArndW]

But in that field it only wants a directory to create the working files; try that without the file name, please.

[dsouza.adithfrancis]

Hi ,
I encountered another problem while running the job .

Error message :
Internal Error: Function 'get_stage_prop' failed
Property 'Remote Message File Name' value not found

For the property field
Remote message file name : *If i mention a path on the DB2 server*
will it require details such as user id( with permissions) to be created on the DB2 server so that i can create a temp file in the DB2 database directory path

[dsouza.adithfrancis]

Hi ,
I encountered another problem while running the job .

Error message :
Internal Error: Function 'get_stage_prop' failed
Property 'Remote Message File Name' value not found

For the property field
Remote message file name : *If i mention a path on the DB2 server*
will it require details such as user id( with permissions) to be created on the DB2 server so that i can create a temp file in the DB2 database directory path