DSXchange

I asked my Admins if I can change the ports, both of them informed me to used same ports. Tried option of installing 8.7 and shutdown and tried to install 9.1 (all client tiers), same error. Tried option of installing 8.7 and shutdown and tried to install 9.1 Datastage only, Install successful. Afte...

The ports were default when installing both 8.7 and 9.1, also admins for the projects informed me to use these ports (different admins and different project). I am not sure if any other ports will work ?

Correction we are trying to install 9.1.0.0 version (from version.xml).

Thanks,
-Sam.

Hi I have IIS 8.7 on my system and I tried to install IIS 9.2 (will be working on multiple projects) . While installing 9.2 I am getting "Port 19443 is not available" error. When taking to both 8.7 and 9.2 admins, they confirmed to use "19443" port. How to install 9.2 with the sa...

Job parameters.

compare variables used by job when run from sequence and run individually and see if there is any difference.

if you have good memory use lookup stage or re-partisan depending on record count Or add MsgHandlers

Can this be added to odbc.ini when datadirect 5.0 is used too? Please let me know.

While creating a new SQL Server DSN in .odbc.ini, is it possible to add the below parameter to it? This is an effort to see if the ODBC SQL Server timeout never happens if this is possible. The datadirect version that is considered in this case is Data Direct 6.0.

LoginTimeout=0

Thanks!

So far we also resorted to restarting the jobs.

Thanks for the suggestions Ray. The volume of data is less in our case which is less than 100000 records. Are there any options to set the odbc DSN for this connection on datastage server to never timeout? Please let me know.

Hi, I am using datastage version 7.5.2. There are several jobs in the project that connect to SQL Server database using ODBC stage. Randomly the jobs are failing with the below error. Some of the times the jobs are running absolutely fine but other times they fail with time out error. "APT_Comb...

Hi Ray, Sorry I could not attend this training. Are there any recorded videos/documents for this session? if yes, how can we access them.

since it is in one parentinfo, you need to remove duplicate after reading complete file.

you can select all 50 user and map their crediantials at once, it might be hard initially but will get used to it :D .

IBM has migrator tool which migrates plugins to connectors, try that and it might work.