I'm trying to ready an area for update but it continues to time out. if anyone has any input it would be greatly appreciated, please see MSG below:
-
00FF08 STATUS=0000 BIND SUBSCHEMA-->IDMSSECU
00FF08 STATUS=0000 READY AREA PROT UPDATE . AREA->DDLSEC
TASK:CIT00A01 PROG:HBG02DPW WAITING FOR LTXNLOCK 00008008 00
TXNID:344134 PROG:HBG02DPW SUBSCHEMA:IDMSSECU MODE:UIX
TSKID:5 TASK:DRIVER PROG:RHDCRUSD HOLDS LTXNLOCK 00008008 00
TXNID:248741 PROG:RHDCRUAL SUBSCHEMA:IDMSSECU MODE:IX
TASK:ADS2 PROG:ADSOMAIN(HBG02DPW) STALLED WAITING FOR LTXNLOCK
TASK:ADS2 PROG:ADSOMAIN ABENDED WITH CODE D002
S SIGNED OFF UCFLQ001 AT 10:42:44.15 15.273
READY CMD IS CAUSING ABEND TIME OUT
Moderator: Moderator Group
READY CMD IS CAUSING ABEND TIME OUT
WK Stewart
-
- Active Member
- Posts: 732
- Joined: Thu May 24, 2012 4:07 am
-
- Active Member
- Posts: 732
- Joined: Thu May 24, 2012 4:07 am
If the modules in question are user-written, then there is a logic problem.w1s2015 wrote:Thanks for the reply, but I'm aware that there's a deadlock, my question is how does one resolve this locking issue? Does one have to contact CA?
If the modules are CA-written, then contacting CA would be a good move.
See if CA have a support community on their website. Other users of the products may have some insights.
IDMS ADS DEADLOCK
The code is user-written, and I appreciate the advice about the CA-community, I'll try that avenue. I wonder if you can use the ready cmd when your using select statements to alter records via OCF. Thanks again!
WK Stewart
-
- Active Member
- Posts: 732
- Joined: Thu May 24, 2012 4:07 am
IDM ADS - READY CMD LOCK
Well I omitted the Ready cmd for update, and used the COMMIT cmd, seems to be working. I'll still contact CA to ascertain whether you can use the READY cmd & SQL/ALTER in the same DIALOG/SUBROUTINE. Thanks for you assistance and insight...
WK Stewart
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page