| View previous topic :: View next topic |
| Author |
Message |
Amit79kr
Beginner
Joined: 06 Jul 2007
Posts: 12
Topics: 4
|
 Posted: Wed Jan 14, 2009 2:37 pm Post subject: Getting AFCY/AFCI abends.... |
 |
|
Hello,
I am getting AFCY/AFCI abends apparently not for same prgrams all time. They are not forced PURGE or PURGE transactions. I am not sure if its a time out issue. The user is the only one who is runnig the transaction in that region. Can I get some pointers how to resolve the issue. Please excuse pointing to documents and IBM libraries.. thats not I am intending to get...The VSAM file is small so no question of REORG and I checked the LISTCAT...
Any pointers to read abend aid for the said issue is welcome...
Apologies if I am blunt.
Thanks |
|
| Back to top |
|
 |
Amit79kr
Beginner
Joined: 06 Jul 2007
Posts: 12
Topics: 4
|
| Posted: Sun Feb 08, 2009 3:35 am Post subject: |
|
|
Hi All,
The issue got resolved. Actualy the issue was with two SQL queries that were holding on to the same resource (from two seperate thread) for more than 30 seconds. During this time other threads wanted to read through the same resource and getting AFCY abend due to time out.
Initialy I thought of increasing the DTIMOUT parameter, but experts advised not to do so as it will only increase the time of abend when it happens, and not actualy resolve the issue. So we have backed out the two queries until we are able to fine tune them.
Thanks. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
