DSXchange

Your post reports this is on DataStage 7.x, but what version exactly? That error has been reported for various reasons (Netezza, Oracle, LDAP) on 8.1 and in some cases patches or fix packs are available to resolve it. Have you contacted support to report it?

There is a technote on the ibm web site for 61223 error. Could be caused by a stage from a special pack like SAP, etc. in which case the pack must be installed on the new server first. Or it could be a bad index on the DS_STAGETYPES file, in which case it involves running the DS.REINDEX ALL command ...

Any time I see "2 GB" I get suspicious because a lot of operating systems, by default, impose 2 GB limitations on file size and those can cause errors or hangs. Check your OS (ulimit -a) or check with your DataStage and/or Unix administrator to make sure that the right ulimit file size set...

Concern 1: It looks like from the screen shot that each ABAP stage is running sequentially because of the fan-out icon on each link. I've not used the ABAP stage myself, but the icon indicates that each one is running sequentially, so you only have 6 simultaneous connections when the job starts. Con...

This IBM web site has a study guide: http://www-03.ibm.com/certify/certs/28000402.shtml I don't know about the "try it again" voucher. The IBM web site has a link for a sample test, but all it does is take you back to the study guide bullet list. It would be nice if there was a sample test.

I think what jwiles is suggesting is that if rows-per-id is 1 then pass the row through but when rows-per-id is greater than 1 in the transformer then you do your logic to trim off the * and compare role with duty, if equal then pass the row through otherwise drop the row. You can do all that with ...