AFCG Abend in RLS

Harsh Pawar · New User Joined: 04 Jun 2008 Posts: 3 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

Garry Carroll · Posted: Tue Jul 01, 2008 4:01 pm Post subject:

Abend AFCG in RLS suggests a conflict where using READ UPDATE. The necessary REWRITE, UNLOCK, DELETE, ENDBR is missing.

Garry.

Harsh Pawar · New User Joined: 04 Jun 2008 Posts: 3 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.