Distributed Transaction Stage using Oracle

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
chuckd248
Participant
Posts: 12
Joined: Tue May 19, 2009 6:13 am

Distributed Transaction Stage using Oracle

Post by chuckd248 »

Does anyone know if there is any documentation on using the DTS stage with Oracle???...

I've gone through the latest DS Redbook(July 2008) but since DB2 was the only option as that went to press, it does not provide any Oracle-specific information... neither does the DS QS Connectivity Guide for Distributed Transactions...

We have a job as follow: MQ Connector --> XML Input --> Transformer --> DTS (trying to load 3 Oracle tables as a single transaction)... it continues to fail withe a "dlopen() -126" error which I'm gussing is due to some variable not being set correctly or domething of that nature. in the DTS stage...

I'm just looking for some doc, if it exists...

Thanks...
Post Reply