Originally Posted by
BV1963
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).
"What is past is PROLOGUE"
Reply With Quote