DSXchange

The " uvsh " or " dssh " that DataStage uses is not documented. At one time it was identical the IBM UniVerse product and is now a subset with some small changes, so you can use the publicly available free documentation published by IBM on these pages to get a feel for what is inside the uvsh progra...

Is the metadata identical for both columns?

Yes, you can use the "dsjob" command to do a lot of things, including running jobs.

I haven't seen that error message before. Is the job "CF_SP_OLD" imported correctly?

SSC_Night wrote:...Since a change of DB2 database, one job doesn't start properly...

What change and how does the job that no longer works use DB2? Can you make a copy of the job and replace the DB2 stage or stages with something else (RowGenerator or Copy) then see if the error goes away?

As Ray has already pointed out, using InputArg(0) is invalid. Did you make the changes that he suggested?

There is no tool that will enable you to do this type of automated exchange. The stage settings for optimal use of either DB2 or TeraData are quite different. If all of your DB2 stages use similar or identical settings, and all table and column names are identical as well as using 100% identical dat...

I haven't seen or heard of this before. The sporadic nature of the problem is strange enough but I would look into the application for a potential cause instead of assuming it was a bug in the product.

Complex Flat Files read and parse COBOL structures. But first you need to get the data from your host to the UNIX DataStage server and you need to send them back after processing. Do you have a method arranged to do this transfer?

Craig - thanks for that. I would have gone back and corrected my post to disable smilies, but then your corrective post would have made absolutely no sense at all

There is a version of DataStage that runs on the mainframe which is the best choice for this; otherwise you will need to ensure that FTP, C:D or other method exists with which the data can be transferred from and to the host in order for it to be processed by DataStage.

There is no command, either UNIX or from within DataStage, to prevent log files from being generated.
PX Jobs allow certain log entries to be suppressed, you can check out "message handlers" in the documentation to see how to do this.

I'm a bit confused about the requirement. If your job is in the after-job subroutine already then it will complete anyway, specifying a non-zero return code from this subroutine will ensure that the job's status is aborted. Could you perhaps explain a bit more on what conditions need to occur in ord...

IOPS = "I/O per second"? This number realy should come out of your application. I/O operations to disk depend upon several factors and SANs are notoriously difficult to configure correctly in order to use them at anywhere close to the manufacturer's numbers. Parallel jobs will write to disk in sever...

Please post in the correct forum, this one is used for posting Testimonials about the product, not for problems.