DSXchange

The problem was with the missing links. We solve the issue by executing the following statements ln -s /opt/mqm/lib/3.2/libimqb23gl_r.so /opt/mqm/lib/ibimqb23gl_r.so ln -s /opt/mqm/lib/3.2/libimqb23gl.so /opt/mqm/lib/libimqb23gl.so ln -s /opt/mqm/lib/3.2/libimqc23gl_r.so /opt/mqm/lib/libimqc23gl_r.s...

The problem was missing links. We solved the issue by executing the following commands ln -s /opt/mqm/lib/3.2/libimqb23gl_r.so /opt/mqm/lib/ibimqb23gl_r.so ln -s /opt/mqm/lib/3.2/libimqb23gl.so /opt/mqm/lib/libimqb23gl.so ln -s /opt/mqm/lib/3.2/libimqc23gl_r.so /opt/mqm/lib/libimqc23gl_r.so ln -s /o...

Hello friends, Can someone point me to a post which has details about post installation steps to configure MQ plug-in. Recently, we have installed MQ plug-in on a Linux server which already has MQ server installed. The problem is that the job which reads messages from the queue is failing with the f...

We contacted IBM support and they asked us to execute the following 1/ You need to create libstdc++ link as: ln -s /usr/lib/libstdc++-2-libc6.1-1-2.9.0.so /usr/lib/libstdc++-libc6.1-2.so.3 2/ Could you please add the following to the DSENV file as the runtime libraries must be referenced: EXPORT LD_...

I just came to know from our MQ team that MQ server has been installed on the DataStage server.

All we did previously was install the MQ plug-in we got from IBM. Does the plug-in come with both server and client?

We used to run the jobs with just the client before. I am trying to configure a new server but the jobs fail with the above mentioned error

Hello friends, I am trying to configure MQ on a recently built server. I got the following error while trying to read a message from the queue for the first time ds_loadlibrary: error in dlopen of mqs.so - /opt/Ascential/DataStage/DSEngine/lib/mqs.so: undefined symbol: _ZTI6ImqItm The following is t...

Sorry for missing out the reference key information. Every step retrieves the Max key from the corresponding staging table before inserting the data. The Max key is used (in place of Oracle sequence) to populate the primary key in the staging table ODBC===>HASH FILE ------------------|| ------------...

Ray, The following is the entry from the log after resetting the job. I am not sure why it fails only at step7 when all the steps are identical From previous run DataStage Job 678 Phantom 20106 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BA...

Hello friends, One of our DataStage jobs fails everyday with the same error and at the same step of the job. The job extracts data from 10 tables and populates 10 staging tables. The design is simple ODBC1==>TRANS==>ODBC1 ODBC2==>TRANS==>ODBC2 and so on Everyday the job fails at 'Transformer 7' with...

Friends, I was trying to use STP stage, for the first time, to execute the stored procedure. The design of the job is simple: it executes a procedure without any input parameters STP stage properties Stored Procedure Name: PROMOTION_DIM.MAIN_PROCESS Generate Procedure Call: NO Procedure Type : Sourc...

Thanks Craig

Hello friends, I am trying to create a new user to access DataStage client tools. 1) On Linux server, I have created a new user 'abc' with '123' as primary group 2) Modified the user (abc) and added to 'dstage' group (secondary) I am getting the following error when I tried to connect to any tool wi...

Hello friends, Recently I have built a new Linux with DataStage 7.5 and imported jobs from a different server. After compiling the jobs and updating all the environment variables, some of the jobs with ODBC and OCI stages are failing with the following error DSD.BCIConnect connecting to ORDDB, call ...