Search found 3 matches

by forest416
Thu Jan 11, 2018 12:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in transformer - Input port 0 already connected
Replies: 7
Views: 5946

Re: Mystery error in transformer stage

I have same error when the filter command line has multiple commands connected by pipeline '|'. It can be re-produce by simplest case: head|head I thought to have a work around by quoting the command by "()" to make it as sub-shell, no luck. Looks that the filter command can only be ONE co...
by forest416
Wed Mar 15, 2017 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FIle extract Issues
Replies: 4
Views: 2705

1. Read the whole one in one big field, field length long enough to capture the longest line. 2. use sub string function to split 1 to 18th field, use the '[ ]' operator 3. for the 19th field, split the value though field() function, using ',' as field separator. If the sub-field count (comma delimi...
by forest416
Tue Feb 28, 2017 12:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multi-instance dataset to Oracle job - slow
Replies: 6
Views: 4413

Hi, As you said, the connections are from one host to multiple target host. There might be bottleneck at the Datastage server side. It may hit the limit of Datastage server host bandwidth. (I pretty sure, the bandwidth usage won't reach to 100MiB/s, if you are on gigabit network. The actual maximum ...