DSXchange

My question is more specific to DataStage EE and not a generic comparison between SMP and MPP. Specifically, is there any advantage of using EE on a SMP architecture? By doing so, will we not defeat the basic purpose of parallel extender? If we use SMP, don't you think simply using Server Edition be...

Hi,

Is is better to have DataStage EE on an MPP architecture? What are the pros and cons of using an SMP architecuture?

Regards

Hi, I am struggling with ETL Capacity Planning and Sizing for DataStage jobs. Maybe this is just wishful thinking, but are there any templates to estimate how much space (in-process and landing) an ETL jobs will require? Please note that I am interested only in ETL capacity sizing for final datasets...

Hi,
We are trying to identify the peformance bottlenecks in some of our jobs. In many cases, we have observed, that the Transformer stage is taking a long time, especially those that have Stage Variable defined.

Would we be better off by eliminating stage variables (if possible)?

Hi,
Can two independent jobs read one dataset simultaneously?

hi,
We are getting the following error while trying to extract data in parallel using a user-defined query (in a DB2 Enterprise Stage)

main_program: Fatal Error: Multiple calls to setNodeMap() must specify the same numberOfPartitions.

Help!