DSXchange

The node "DDC2-97752ZE" must be your DataStage server. From the server, after you ping it using Ray's suggestion, also enter "hostname" and it should be "DDC2-97752ZE"

Disabling combination will tell you in which stage you are getting the error, but in this case it will be output enterprise stage.

There are too many factors involved for that question to be answered adequately. Is this Windows or UNIX? What is the budget? Is the DB for data and XMETA on the same machine(s)? What type of work at the 100+ users doing? Will they all be logged on at the same time? How fast is the network? What dis...

If you get a 1-user license for the compiler, then concurrent users will queue, meaning that compiles might be slower than expected when multiple users compile but no errors will occur. Note that only transform stages need the c++ compiler, the other stages don't.

You have a character in your data which is not mappable in the IBM-1051 character set.

In your designer "General" tab you can select a container. Once on the canvas, you can right-mouse click and convert it to a shared container. Or in the Designer menu you can choose "new" and then select a shared container directly. I'm sure there are more methods, which as also ...

Is the error in the sequential file read stage of the multiinstance job? What platform are you running on and have you compared your kernel settings on the development and production machines? NFILES or the like might be triggering the error.

I assumed that PX would implicitly convert the CHAR to a VARCHAR; since one cannot trim a CHAR field; but perhaps this isn't happening in your case. Try creating a VarChar stage variable, assign it the value Trim(In.PolicyNumber) then use that stage variable for your right() function.

If you execute the exact same SELECT statement from your favorite DB access tool, how long does that take? Odds are high that this lengthy period isn't related to DS but to the database.

Are you certain that "DDC2-97752ZE" isn't your client pc host name?

Basically, Datastage isn't detecting that your fastname machine is local and trying to execute a rsh to it - hence the error message. Could it be case-sensitive on Windows?

I don't know where in the repository this information is to be found, but since DataStage uses the system scheduler you can glean the information from there.

Is your DataStage host called "DDC2-97752ze"?

Oops, I just reread your post. I mistakenly assumed that the designer and director could login OK while the admin couldn't. But upon re-reading I see that you didn't mention the other 2 clients. If all 3 have connection issues then I would start by looking at your grants and access rights as defined...

If you haven't sourced the dsenv file correctly, then the 'orchadmin' command won't work. As Ray suggested, check it from your designer. It will probably work, as the dsenv file is executed by the background process.

did you use the designer menu option and "check" the configuration file for correctness?