DB2/UDB

[samythiru]

Hi ,

I am loading data from a sequential file to DB2 database . I am using DB2/UDB stage for loading data . In the properties of the DB2/UDB stage I need to give the value for directory for data and command files. Please let me know what value I have to give for this parameter.

If I run the job without specifying the parameter. I am getting an error message.

bulkload..DB2_UDB_Load_0: Invalid pointer to stage user data
Internal Error: Function 'get_stage_prop' failed
Error opening file in 'Directory for Data and Command Files'

Thanks
Thiru

[DSguru2B]

Click on the property help. It will tell you what needs to go there. It basically requires you to give a directory path on the DB2 server, if i recall correctly, for the three files that are necessary to execute your load job.

[samythiru]

Hi ,

Thanks for your reply but I am not able to understand the property's help

Directory for Data and Command Files
The directory in which the data file
(INPDATA.DAT), command file (CMD.CLP),
and batch files (ULOAD.BAT) are generated.
If these files already exist, they are overwritten.
If you specify the load as Sequential
File (delayed), all three files are generated. If
the load is immediate and an error occurs
when loading data, the command file, batch
file (and a data file if Remove Intermediate
Datafile is set to No) are generated. You can
modify these files if necessary and use them
to restart the load.

I don't know which directory I have to specify .

Thanks
Thiru

[DSguru2B]

Any directory on the DB2 server. Now see, its been a while since I last used the Load stage. I am pretty sure the Temp_Dir needs to be on the Db2 server. Anywho, try it.
Create a directory that you have access too. Pass that directory path in this property. The load stage will create the files there and use them to invoke the bulk loader.