Page 1 of 1
IBM DB2 Load Stage
Posted: Wed Aug 04, 2004 2:00 pm
by JDionne
Please forgive me if this is simple, but I am running on about 5 hours of sleep so Im starting to see double right about now.
This is my error:
Code: Select all
EXP1LoadStgTblDB2Load..DB2_UDB_Load_120: Internal Error: Function 'get_stage_prop' failed
Error opening file in 'Directory for Data and Command Files'
I understand that it cant get to the direcotry, but I dont understand why not. This is What I have in the field
Code: Select all
\\scrbbususcnc04\ETL_Processes\JOC\ETL_Load_Files\
the folder ETL_Processes is set up as a network share. I am using an ID in the stage that has access to the dir.
Can anyone point me in the right direction?
Jim
Posted: Wed Aug 04, 2004 2:06 pm
by JDionne
Neaver mind...I had an extra space in my text.
Jim
Posted: Wed Aug 04, 2004 10:18 pm
by ray.wurlod
Get more sleep.
Posted: Thu Aug 05, 2004 6:52 am
by JDionne
ray.wurlod wrote:
Get more sleep.
ZZZZzzzzZZZZzzzzZZZZzzzzZZZZzzzz
Clarification of Stage Paramiters
Posted: Fri Aug 06, 2004 8:40 am
by JDionne
I have been tring to get a DB2 Load stage to work for a few days now. At first it seemed to be a bit of user error, now it seems to be a bit of user confusion.
Im having trouble currently with the msg output directories. This is right from the help file
Code: Select all
Local Message File Name*. The string containing the pathname for the local file name used for output messages.
Remote Message File Name*. The string containing the pathname for the file name used by UDB server for temporary files. Temporary files are created to store messages and consistency points and to delete phase information. You must ensure that each load has a unique fully qualified remote file name.
Does this mean that DS will create the txt file or do I have to have it already created before the job runs?
Jim
Posted: Fri Aug 06, 2004 9:34 am
by JDionne
This is my new error
Code: Select all
SQL3508N Error in accessing a file or path of type "TEMP_FILE" during load or
load query. Reason code: "1". Path:
"D:\ETL_Processes\temp\JOCEStageTemp.txt\DB200005.PID\DB200".
Look at the directory that it it is looking for. I supplied
Code: Select all
D:\ETL_Processes\temp\JOCEStageTemp.txt
I dont know where the rest of that string is coming from, nor do i Know If i should let it. Has anyone goten this stage to work?
Jim
Posted: Fri Aug 06, 2004 9:51 am
by chucksmith
Is
Code: Select all
D:\ETL_Processes\temp\JOCEStageTemp.txt
a pathname to a directory or a file? In the stage, which cell are you placing the pathname in?
If it is working directory, try creating the directory
Code: Select all
D:\ETL_Processes\temp\JOCEStageTemp
and use this value in the stage.
Posted: Fri Aug 06, 2004 10:02 am
by JDionne
chucksmith wrote:Is
Code: Select all
D:\ETL_Processes\temp\JOCEStageTemp.txt
a pathname to a directory or a file? In the stage, which cell are you placing the pathname in?
If it is working directory, try creating the directory
Code: Select all
D:\ETL_Processes\temp\JOCEStageTemp
and use this value in the stage.
Code: Select all
D:\ETL_Processes\temp\JOCEStageTemp.txt
is the value that i put in Remote Mesage File Name as a file.
Re: IBM DB2 Load Stage
Posted: Thu May 18, 2006 12:07 pm
by wenfei.chen
It is really an old post. I encountered the same problem today. ETL server and DB2 reside on different machine. Does anyone know how to point
'Directory for Data and Command Files' to the DB2 box? It will be ok if I point it to ETL server dirctory.
JDionne wrote:Please forgive me if this is simple, but I am running on about 5 hours of sleep so Im starting to see double right about now.
This is my error:
Code: Select all
EXP1LoadStgTblDB2Load..DB2_UDB_Load_120: Internal Error: Function 'get_stage_prop' failed
Error opening file in 'Directory for Data and Command Files'
I understand that it cant get to the direcotry, but I dont understand why not. This is What I have in the field
Code: Select all
\\scrbbususcnc04\ETL_Processes\JOC\ETL_Load_Files\
the folder ETL_Processes is set up as a network share. I am using an ID in the stage that has access to the dir.
Can anyone point me in the right direction?
Jim
Posted: Sat May 20, 2006 12:46 pm
by DSguru2B
I faced this exact same problem once. I dont have access to DataStage right now but i know that in the Load stage, the first two directory paths should be pointing towards your Datastage server and the last one is the udb server. I myself couldnt believe that. But the IBM support persons asked me to test it with specifying the udb server directory. To my surprise, it worked.
If you guys can wait till monday, i can tell you exactly where the UDB server path is to be specified.