DSXchange

Start by learning to write in English rather that SMS-ese. DSXchange prefers a professional standard of written English, not least because many of our members do not have English as a first language.

You have marked this thread as Resolved. Please post HOW it was resolved, to aid future searchers.

Unless you're using the new migration tool, you will need to re-install IIS. IBM will only, at least for now, permit use of the new tool in conjunction with the "concierge" service, they say to make sure that the tool is correctly used.

Welcome aboard. I'd start by looking for locks - maybe even deadlocks - in your target.

You will need to uninstall IIS, either physically or logically. IBM has some scripts (AppServerAdmin.sh and the new Concierge service (migration tool assistant) that may be able to help. Ultimately you need to get all information from your old repository into the new, and there's little or no docume...

A Nested Condition activity - which is basically a placeholder activity that only has triggers - would be ideal.

Data Sets, if the descriptor file name ends in ".v", are virtual Data Sets, corresponding with links in the job. Buffer operators are inserted by the Orchestrate framework to handle conditions in which flows from multiple inputs are likely to be arriving at different rates and which, witho...

I personally refuse to attempt to diagnose any error thrown by APT_CombinedOperatorController. Disable operator combination, find out which particular stage is throwing the error, then get back to us.

Column Generator.
Build.

To name two.

Yes, but in Australia we did away with peerages some decades ago!

It depends (as always). If the columns that identify duplicates are indexed, then it's better done in the database, because it can be solved quickly in the index. A unique sort of some kind removes duplicates fairly efficiently. The Remove Duplicates stage gives you the opportunity to specify the fi...

Your SELECT statement returns seven columns. You must therefore provide seven columns in the record schema.

Are you setting Field Delimiter String property or Field Delimiter ?

For large volumes of data you can use two adjacent Sort stages, one that sorts in parallel and the other which executes sequentially, using a Sort Merge collector and does not otherwise sort at all.

DataStage is pedantic about date formats. For example if 30-09-2010 is OK then 30-9-2010 is not. Make sure that you return an absolutely consistent date format, with two digits each for day and month. YYYY-MM-DD is preferred as this is the default format in DataStage.