|
View previous topic :: View next topic
|
| Author |
Message |
Harsh Pawar
New User
Joined: 04 Jun 2008
Posts: 25
Location: Noida
|
|
|
|
Hi ,
I am getting AFCG abend.
Previously I was using Non-RLS mode and not got AFCG. But after implementing RLS , it started.
Any help would be greatly appreciated.
Regards,
Harry |
|
| Back to top |
|
 |
Garry Carroll
Senior Member
Joined: 08 May 2006
Posts: 1193
Location: Dublin, Ireland
|
|
|
|
Abend AFCG in RLS suggests a conflict where using READ UPDATE. The necessary REWRITE, UNLOCK, DELETE, ENDBR is missing.
Garry. |
|
| Back to top |
|
|
Harsh Pawar
New User
Joined: 04 Jun 2008
Posts: 25
Location: Noida
|
|
|
|
I got the resolution,
I was getting AFCG since i was updating the file by alternate-key as well as Base-key.
A transaction performing updates by the alternate key may be acquiring locks in a different order to a transaction performing updates by the base key. So mixing the two may cause dead-lock. |
|
| Back to top |
|
|
|
|
