DSXchange

The tools have made great strides since Ascential was purchased by IBM. And we have only seen the tip of the future. All the separate tools are being integrated into one tool, allowing for easier development and closer to the one stop shop that many of us would appreciate finally having. As for supp...

In order to alleviate the Mutex error (which is still an issue but may be related to the IPC stage), we changed 2 parameters; spintries (10) and spinsleep (10000). Stopped the ds engine, performed a regen, started the ds engine.

This is 1/3 of the total memory on the UNIX computer and is driving the Admin crazy... We need to lower the amount used. So, how do we lower the amount used and what is considered an acceptable value ?

Thanks,

Lester

You could have this done in the source stage, outerjoining the 7 dimension tables. Thsi will allow the Database to perform all the lookup work, which it can perform as LOT better then the Job via a hash or OCI lookup.... Thanks, Lester Hope this might be discussed earlier, when searching I could not...