DSXchange

There is a limit on some operating systems; it's actually the number of subdirectories in a directory. On Solaris 5.2 that limit is 32K, which effectively limits the maximum number of jobs to around 5000. It's mainly cropped up as a problem in the Version Control project, and the workaround is to us...

I understood that the only supported Linux for 7.x is Red Hat AS3.

I have never even attempted to authenticate on Linux via Active Directory.

Do you have a D:\tmp folder? You need one. This is referred to as /tmp by MKS Toolkit.

You can tell from the score what partitioning algorithm is used. Generally, unless there are overriding requirements (such as DB2 stage), Auto will use Same on a parallel-parallel link.

You ARE using NLS, otherwise the message would not have been generated. That is to say, you have NLS enabled, whether you believe you are using it or not. NLS_LANG is an external environment variable, not used by DataStage, but checked for compatibility. You simply need to set it with the same map n...

You're wrong to generalize like that. The format could be anything. The CFF stage can handle many different formats. Reading the pertinent chapter in the manual, or the topics in on-line help, would be a good start point.

Do you log in with administrator privileges?

Try reducing the number of simultaneously starting processes (there's a startup concurrency environment variable).

Ten million source records once, ten million daily, ten millon per second?

Post the full detail of the error message, so that we can get all the other information that you're not telling us.

Is the question IF condition THEN truncate ELSE don't or is the question truncate only certain rows?

The two conditions either side of your AND connector can never simultaneously be true. NullChecking() is only true for "" or NULL.

You can connect to dBase files using an ODBC driver for dBase. DataStage can act, among other things, as an ODBC client.

That logic can only generate 1 or 0, so why do you say you are "getting negative values"?

Did you build the expression with the expression editor? If not, please do so - you may have made one small typing error.

(1) Don't ever complain about performance or network problems - you will encounter both. (2) Clear file is VERY fast. Faster than anything with hashed files. It is not a "transactional" process. There are substantial dangers associated with your two servers, one hashed file approach if the hashed fi...