DRS rollback not occuring with IPC stage

chulett · Post by **chulett** » Mon Feb 12, 2007 1:37 pm

Nope - if you read the pdf documentation on the stage, you'll note all the various clients that must be loaded and configured to use the stage for them.

For example, to select 'Oracle' you must have the Oracle client software and sqlnet 'configured' in the same manner as OCI requires. No mention of setting up ODBC other than when selecting that option or leveraging a type that needs it - like Informix.

And this comment leads off Chapter 1:

DRS can be configured at runtime to read from or write to a number of different supported relational database management systems using native interfaces.

DSguru2B · Post by **DSguru2B** » Mon Feb 12, 2007 1:42 pm

The keyword there is native interfaces where as for odbc, a generic connection handle is used.

I_Server_Whale · Post by **I_Server_Whale** » Mon Feb 12, 2007 1:42 pm

Thanks Craig and Narasimha for the clarification!

narasimha · Post by **narasimha** » Mon Feb 12, 2007 1:54 pm

Good that you got the topic out, made everybody give a thought in that direction

news78 · Post by **news78** » Tue Feb 13, 2007 8:30 am

So it is a known fact that if a job uses IPC stage we cannot do rollback if the job aborts? Why so? (I assume this happens because IPC creates two processes?)