DSXchange

Hi Ray,

Will be both, ODBC and SQL enterprise stage.

Sql server 2008 will be our source and target database.

Thanks,
Hoa

Hi,

We are planning to upgrade our external source SQL server 2005 database to SQL server 2008 database.

are any issues connecting Datastage PX 8.1 jobs to SQL server 2008 database?

Please advise!

Thanks,
Hoa Nguyen

Hi Andrew,

There are three different places where the file, mqs.dll, can be found as below:

C:\Windows\system32;
C:\IBM\InformationServer\Server\DSComponents\bin;
C:\IBM\InformationServer\Server\DSComponents\StagingArea\installed\MQSeries\server\windows;

Thanks,
Hoa

Hi Sainath, I searched the DSXchange's knowledge base and found one but it's Unix environment. I am on Windows. Below is the environment settings from a datastage job. You could please point me as to where I can add the path if it's not already there Thanks, Hoa Environment variable settings: ALLUSE...

Hi Andrew,

I looked at the job's log and the path points to the mqs.dll is there:

The path below is from the job's log:

C:\IBM\InformationServer\Server\DSComponents\bin;

PLease help!

Thanks,
Hoa

Hi, I got a job, read data from a sql server table, output to transfomer, then XML output, then WebSphere MQ. But the job failed to run with the error message below: main_program: Fatal Error: Fatal: Shared library (mqs.DLL) failed to load: errno = (-126), system message = (The specified module coul...