|
View previous topic :: View next topic
|
| Author |
Message |
kgumraj
Active User
Joined: 01 May 2006
Posts: 151
Location: Hyderabad
|
|
|
|
Hello,
I have Commit and rollback logic like this.
| Code: |
Para-1.
Insert table-A
add 1 to counter
Insert table-A
add 1 to counter.
if counter = 2
perform para-2.
Para-2.
exec sql commit.
move zero to counter. |
When again processing Para-1, we are getting SQLCODE -30090 error.
How can this be solved.
| Quote: |
| FYI: We are accessing remote database |
|
|
| Back to top |
|
 |
UmeySan
Active Member
Joined: 22 Aug 2006
Posts: 771
Location: Germany
|
|
|
|
Hi !
Does this has something to do with the point, that DB2 UDB does not support 2 phase commit over TCPIP ???
If yes, DB2DRDA1READONLY=NO for UDB
Attention: IBM declared: to use only at your own risk !!!
Read more at IBM on the web !!!
Regards, UmeySan |
|
| Back to top |
|
|
|
|
