If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to make commit to fail

Hello,

I am in a process of testing of Oracle transparent Gateway which supposed to provide us with the 2 phase commit between Oracle and DB2 databases.
One of the test scenario calls for simulation of the commit on the Oracle side to fail and make sure that both changes (Oracle and DB2 ) rolled back. I have not yet been successfull trying to make "commit " to fail.
Your input will be greatly appreciated.

One, who thinks that the other one who thinks that know and does not know, does not know either!

I am in a process of testing of Oracle transparent Gateway which supposed to provide us with the 2 phase commit between Oracle and DB2 databases.
One of the test scenario calls for simulation of the commit on the Oracle side to fail and make sure that both changes (Oracle and DB2 ) rolled back. I have not yet been successfull trying to make "commit " to fail.
Your input will be greatly appreciated.

Did you try to put the tablespace in read only mode which in turn fail your transaction in Oracle?

My goal was to make a commit to fail so I can validate that 2 phase commit is working properly. So far I could not accomplish it and suggested solutions although greatly apprecicated did not solve my problem

One, who thinks that the other one who thinks that know and does not know, does not know either!

My goal was to make a commit to fail so I can validate that 2 phase commit is working properly. So far I could not accomplish it and suggested solutions although greatly apprecicated did not solve my problem

Open two sessions, keep the commit ready and in another session drop the dblink, simultaneously commit enter and DROP the DBlink(OR)

2. DELETE the ODBC system DNS file
3. you can even unplug the DB2 server network cable - Rough though!

which will commit at the local server and since there is no response from the remote will fail (2PC).