DSXchange

I did, it was an AIX patch issue in my case and I referenced the offending pieces.

Try to run the following command

netstat -a |grep dsrpc

For us it shows the machine number in use by the developer. That will show everyone using DataStage on that machine, not project. Gives you a place to start at least.

I just called DataDirect yesterday about my issue and Ultramundane is right. They will not help with a branded ODBC, you must contact IBM for the issue. I thought all the messages would be somewhere in /branded_odbc/locale/en_US/LC_MESSAGES. I think it will give you the number like that when it eith...

I wanted to update everyone with the resolution that we had for this. We eventually found jobs that would drop the connection after 5 minutes. The issue dealt with AIX 5.3 TL5 where a bug was introduced dealing in this version with TCP/IP packets being dropped due to keep alive issues. Patching with...

It appears that I am using 4.2 DataDirect drivers which are not compatible with MS SQL Server 2005. I got the version from the odbc.ini file, I'm still trying to figure out from a Unix command line how to tell which version is truly loaded.

Kenneth,

To funny on the 22 hour job

I can land to a file and then load easily, but then I would incur the cost of picking the data back up again and then loading which would break the pipeling concept. The total job would run in 40 minutes, I know this because to go ahead and get my data out there I did just what you mentioned, drop t...

Still isn't going very well. I've checked with the DBA's and they are saying that all the timeout connections are set to unlimited. I would like to note this is connect to MS SQL Server 2005. From reading the documentation I see this. SQLServer Wire Protocol (VMmsss20.so) MS SQLServer 7.0 MS SQLServ...

Searched all forums and found some information to try there.

I have a job that is reading in a large amount of data from sequential files and then aggregating it and finally writing it directly to an ODBC stage. If the job process a small amount of data it works properly. When I process a large amount of data such that the aggregator doesn't allow any rows to...

It appears that I have an issue with my configuration file. The AIX box has 8 CPUs. If I create a 7 CPU config file and validate it, everything is fine. If I create an 8 CPU configuration file I get the following message. Can someone help explain how to resolve it? ##W TOCK 000000 10:30:59(008) <mai...

This may help.

viewtopic.php?t=92392

If you use a transformer in EE you can click on the contraints and set a number. I'm pretty sure that this field does not allow a parameter value. To do the 1% thing you can use a transformer again. I know, I know, not the most efficient EE stage, but it's just an idea. You'll obviously need to dete...

From what I have read the only way to get rid of the message is to catch the field in a modify stage or a transformer in the subsequent output stage from the aggregator. I have talked with some folks from Ascential about it and it seemed to be like that is just the way it is.

Another method is shown below: