DSXchange

I meant an option on the compression utility, such as Eric exemplified.

Try using Table Read method in the DB2 Connector.

The Sequential File stage uses STREAMS I/O, so should not be a bottleneck. Rows/sec is a meaningless metric since we don't know how wide your rows are.

Most compression utilities have options that allow the output file to be split on size.

Can you start Director from the Designer's Tools menu?

Upstream of the Pivot stage generate a delimited list of column names, and pivot on that also.

That, or try escaping the backslashes. DIR /B C:\\XML\\TEST.xml But, with UNIX commands, you will still have the problem that drive letter is not recognized. MKS Toolkit regards the current drive as "the filesystem" and its root as the filesystem root. So you should probably (a) make sure ...

The ls command ought to work, as you have MKS Toolkit installed. But there's no reason you couldn't use the DIR command, ideally with the /B switch.

On the other hand, most Connectors are implemented for server as well as for parallel jobs. Further research is required...

To which actual version did you apply Fix Pack 3? What does your official support provider have to say? Have you searched IBM website for known issues around this Fix Pack?

Why not use separate flows, one for CA and FL and the other for the other states? Only the latter performs the lookup, and the data flows are reunited using a Funnel stage.

Just out of curiosity, what is the behaviour when you use system variable @FM rather than Char(254)?

The GRANT command I mentioned creates the entry in UV_USERS. In theory, at least, you should not manually edit UV_USERS but only ever change its contents using GRANT and REVOKE commands.

nagikondaveeti wrote: Please make sure all invocation Ids are different from each other especially when job is running in multi instance mode.

It's not a problem if you're not in multi-instance mode.

Ray or whomever - doesn't this rule out the use of RCP? :? No, it's exactly the kind of thing RCP is designed for. Imagine there are 10 columns coming in to the Transformer stage, and the update field is created within the Transformer stage. 11 columns per row will be transferred to the Transformer...

Once you have the XSD file, you need to import it as a table definition.
In Designer, Import > Table Definitions > XML Table Definitions