| View previous topic :: View next topic |
| Author |
Message |
gotluru
Beginner
Joined: 17 Dec 2002
Posts: 29
Topics: 6
|
 Posted: Fri Feb 28, 2003 9:33 am Post subject: Why I am getting -913 instead of -911? |
 |
|
Hi All,
Good Morning..
In our application we are getting -913(Deadlock with no rollback) for any contentions. Because of this some transactions are committing. How we can get -911's(Deadlock with rollback) instead of -913's?
Any Help is Appreciated..
Thanks,
Prasad |
|
| Back to top |
|
 |
Himesh
CICS Forum Moderator
Joined: 20 Dec 2002
Posts: 80
Topics: 21
Location: Chicago
|
|
| Back to top |
|
|
gotluru
Beginner
Joined: 17 Dec 2002
Posts: 29
Topics: 6
|
| Posted: Fri Feb 28, 2003 9:48 am Post subject: |
|
|
Hi Himesh,
Thanks for your quick response..
I know why we are getting dead locks. Problem with -913, when dead lock occurs at 4 th sql first 3 sql's are committing(cobol/db2). We need system to be it's initial state after deadlock also.
Prasad |
|
| Back to top |
|
|
vallishar
Beginner
Joined: 17 Dec 2002
Posts: 53
Topics: 14
Location: BengaLuru
|
| Posted: Fri Feb 28, 2003 10:52 am Post subject: |
|
|
Prasad,
| Quote: |
If you are using CICS and a deadlock occurs, the CICS attachment
facility decides whether or not to roll back one of the application
processes, based on the value of the ROLBE or ROLBI parameter. If your
application process is chosen for rollback, it receives one of two
SQLCODEs in the SQLCA:
|
Did u check the ROLBE/ROLBI parameter of the transaction ?
_________________
If you're not failing every now and again, it's a sign you're not doing anything very innovative. |
|
| Back to top |
|
|
gotluru
Beginner
Joined: 17 Dec 2002
Posts: 29
Topics: 6
|
| Posted: Fri Feb 28, 2003 11:32 am Post subject: |
|
|
Hi Vallish,
Thanks for your response. I think rolbe/rolbi are specific to cics transactions. In this case db2 is trying to rollback to initial state(-911) and when it fails it is going for -913's.
My question is how i can force always -911's in this kind of situvations?
Prasad |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
