DSXchange

Rajan, Ray already suggested you ...There is also some help available in DS Manager PDF file under chapter Working with Parallel Routines Once you do that it will answer some of your questions. The general subject of C++ code and creating/compiling/linking such is a bit outside of this forum's scope...

Hello JezT,

What is the category and job name? :D

Can you not just use custom SQL to your database in order to do this?

The read speed should be measured in a simple job that outputs nothing (i.e. to a sequential file /dev/null) or with a transformer constraint. Try starting off with a 1 node configuration file in addition to your 4 way file and see what the speeds are.

Have you checked the startup script for DataStage used during system boot, perhaps there is a limit set there. Once a limit has been reduced it cannot be raised higher by user processes. If you have set up DataStage so that it can be restarted by an admin, or if you have root access to your machine,...

What do you mean by "Server" files? The project doesn't contain node name, but there are files in the DataStage server directory that do. If you change your host name you will find that DataStage ceases to function.

I wonder if Visio installs some DLL to which the DataStage clients object? If the problem doesn't happen until you install Visio then you will probably have to call up somebody's support lines.

What Craig has stated is that in order to avoid real data truncation your source column cannot contain more than 4 characters. To avoid the warning your datatype's metadata needs to be 4 or less characters as well.

Try putting your stage variable into an output link to a peek stage. You will see that you most likely did not convert your date correctly.

xli,

both values for nofiles that you have are "real". This value can be set per session and only the maximum is set at the system level.

I am fairly certain that someone has changed your $DSHOME/dsenv file and inadvertantly set the ulimit nofiles restriction there.

Hello Arunkg, The error ..error like something has broken (check the data stage server properly... is pretty imprecise and we can't do much to help you there. How are you shutting down your Windows server; does the shutdown process show any problems? You could also try to go into the control panel a...

I've never seen that one before; DataStage doesn't require Visio and it certainly hasn't been installed on any machines I've worked on. But I vaguely recall having had a similar problem in the past where I was prompted to install some unrelated application when I started one of the client programs. ...

You are calling user-written after job subroutine called "DoJobReport" and the error is coming from that program. You will find it by opening up your Manager and browsing the routines.

Yes, I'm going to use Jamaican rum to ensure that all those nasty bacteria have no chance of surviving! Enjoy the show, I'd like to be there.

Kumar - the normal hashed files don't hold information about their path or system name. Indices hold absolute paths and thus can only be copied correctly when the target path remains the same. The DataStage server installation directory contains not only indices (thus it needs to go in the same plac...