Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

LTXNLOCK on IDMS DB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
rajasekar2810

New User


Joined: 22 Apr 2008
Posts: 6
Location: india

PostPosted: Mon Nov 03, 2008 11:07 am    Post subject: LTXNLOCK on IDMS DB
Reply with quote

Hi

Can any one tell me about what is LTXNLOCK concept in IDMS DB.
Back to top
View user's profile Send private message

nelson.pandian

Active User


Joined: 09 Apr 2008
Posts: 133
Location: Phoenix, AZ

PostPosted: Sun Nov 16, 2008 12:15 am    Post subject:
Reply with quote

Hallo

Quote:
Can any one tell me about what is LTXNLOCK concept in IDMS DB.

From were did you find this LTXNLOCK?????
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Sun Nov 16, 2008 12:49 am    Post subject: Reply to: LTXNLOCK on IDMS DB
Reply with quote

maybe in a deadlock message ??

Code:
DC001000 T:20425 ADS2 P:DBCRUPD C:DEAD WAITING ON R:LTXNLOCK 00000008 0A60730D
DC001001 TXNID:000369476 RUID:000369476 RUNAME:DBCRUPD SSC:DBCRSSC1
Back to top
View user's profile Send private message
rajasekar2810

New User


Joined: 22 Apr 2008
Posts: 6
Location: india

PostPosted: Sun Nov 16, 2008 10:53 am    Post subject: Reply to: LTXNLOCK on IDMS DB
Reply with quote

Yes exactly in the IDMS logs I find this out.
Let me share my findings;

This situation happens when a record DB key is dead locked by some transaction and that record is requested by some other transactions and the TASK is getting in to loop.This leads to 0069 error.
Do you have any more idea on this.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Nov 16, 2008 11:18 am    Post subject:
Reply with quote

Hello,

Quote:
happens when a record DB key is dead locked by some transaction
Possibly you mean "locked" rather than "dead locked". One transacton might lock something, but not cause a deadlock.

A deadlock is typically caused when 2 different processes read 2 different tables in not the same order. Pg1 reads TbA key1 with lock. Pg2 reads TbB key2 with lock. To this point - no problem. Now, Pg2 needs to read TbA key1 with lock - it cannot because of the lock issued by PgA. It will wait until the lock is freed. What causes the deadlock is while Pg2 is waiting, PgA needs to read TbB key2 with lock. At this point the deadlock (sometimes called a "fatal embrace") is detected and the request causing the deadlock is terminted with an error.

The way to prevent this is to make sure the code locks rows in multiple tables in the same order or make sure the programs do not run concurrently.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm
No new posts ADS 3270 Batch simulator for IDMS rel... gpowell382 IDMS/ADSO 1 Thu May 05, 2016 8:02 pm
No new posts ALTER of an IDMS AREA with NEW/OLD pa... Awanti IDMS/ADSO 2 Mon Mar 14, 2016 10:01 pm
This topic is locked: you cannot edit posts or make replies. Sticky: CA IDMS v18.5 Manuals Pandora-Box IDMS/ADSO 0 Sun Dec 13, 2015 5:37 pm
No new posts Need documents or links to understand... sherlinpraveenkumar IDMS/ADSO 5 Wed Oct 28, 2015 4:40 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us