DSXchange

Its all about the middleware!!! If you catalog the databae on the ETL server then it magicaly knows the DB is there and will connect!!!!!!!
Thanks for all the help
Jim

What I did was catalog a remote Instance to my primary instance, then I cataloged the remote Test DB. In the Controle Center it is seen as expected, but DS still cant find the Database. I know this is getting more into the DBA side of this, but do you have any other thoughts or suggestions?
Jim

Is it possible to manage this through environment variables? The job parameter can access an environment variable. Just a thought. The problem is that there can only be one environment variable set for "the" db2 instance and that DB2 stage only connects to databases not instances. You can...

I have a DB2 Server with two instances, a DB2 Instance and a DB2TEST Instance. How do I configure the DB2 stage in DS to connect to the correct Instance?
Jim

I have a custom SQL statment that I have to run to get data to use to update a reference table. Because of my database I have to convert an int into a char before I can do the substring command. My code select d.direction_code , f.Direction_Id , substr(char(MAX(vdate_Month_Id)),5,2) , SUBSTR(CHAR(MA...

Is 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 D:\ETL_Processes\temp\JOCEStageTemp and use this value in the stage. D:\ETL_Processes\temp\JOCEStageTemp.t...

This is my new error 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 D:\ETL_Proces...

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 Local Message File Name*. The string containin...

ray.wurlod wrote:
Get more sleep.

ZZZZzzzzZZZZzzzzZZZZzzzzZZZZzzzz

Neaver mind...I had an extra space in my text.
Jim

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: EXP1LoadStgTblDB2Load..DB2_UDB_Load_120: Internal Error: Function 'get_stage_prop' failed Error opening file in 'Directory for Data and Command Files' I und...

How do i stop these msgs from db2? EXP2LUReconcilation..US_Port.ETL_US_Port_Lu_Tbl: SQLExecDirect: Returned success with info for statement 'DELETE FROM DB2ADMIN.STG_ETL_US_PORT_LU_TBL'. See following DB2 error for details. and EXP2LUReconcilation..US_Port.ETL_US_Port_Lu_Tbl: [IBM][CLI Driver][DB2/N...

trobinson wrote:Yes, MQ Manager must be installed on the ETL Server.

Is MQ manager the actual server engine or an admin tool?
Jim

I have already verified that DS needs a MQ server to run, but just to clerify, does that server need to be installed on the DS Server?
Jim

chulett wrote:Technically, under 'Type' you select 'Encrypted'. But other than that, as noted, it's just basically another Job Parameter.

What do I put in the password field in the stage?