How to see records locked by a port in Jbase

219 views
Skip to first unread message

JOSE L MARTINEZ-AVIAL

unread,
Jun 15, 2021, 1:41:12 PM6/15/21
to jb...@googlegroups.com
Hello,
   Is there anyway I can get a list of tables/records locked by a port in Jbase?

thank you

JL

Jim Idle

unread,
Jun 16, 2021, 2:10:00 AM6/16/21
to jBASE

--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAHB4ARuhvHw5Xqowr2PppX%3DkLqxYAnfpTMF0BqswkJ9No6V28g%40mail.gmail.com.

bdeck...@gmail.com

unread,
Jun 16, 2021, 10:34:04 AM6/16/21
to jBASE
jBASE also allows you to query the lock table as if it was a file using normal query techniques.  This was implemented using jBASE's database abstraction model called jEDI.  This jEDI is called the jLock JEDI.  You can read all about it here:  https://docs.zumasys.com/jbase/record-locking/locking-models/#using-the-lock-jedi-to-display-and-clear-locks

Jim Idle

unread,
Jun 17, 2021, 2:10:19 AM6/17/21
to jBASE
I object to those example programs using Greg and not FB. What is the world coming to when age old traditions are violated willy nilly?


To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/bbb89e52-2727-4944-b696-fe46cb0c9b11n%40googlegroups.com.

bdeck...@gmail.com

unread,
Jun 17, 2021, 10:01:09 AM6/17/21
to jBASE
The Zumasys influence has made jBASE a much kinder and gentler product :-)

Jim Idle

unread,
Jun 18, 2021, 12:01:52 AM6/18/21
to jBASE
Going to the dogs mate! ;)

Good luck!

Jim



To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/954400fe-a684-4b51-8b79-099c6145d63bn%40googlegroups.com.

Joshua Camacho

unread,
Jun 18, 2021, 4:41:34 PM6/18/21
to jb...@googlegroups.com
SHOW-ITEM-LOCKS

--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAHB4ARuhvHw5Xqowr2PppX%3DkLqxYAnfpTMF0BqswkJ9No6V28g%40mail.gmail.com.
--

Robert Burke

unread,
Jun 18, 2021, 4:41:44 PM6/18/21
to jBASE
Hi Jose,

You can view jBASE record locks by using the list-item-locks command. You can also view the lock table held by the jBASE distributed lock service by using the jdls -dvL command.

Thanks,
Robert Burke 

JOSE L MARTINEZ-AVIAL

unread,
Jun 21, 2021, 11:42:53 AM6/21/21
to jb...@googlegroups.com
Hello all,
  thanks for the feedback. Actually what I meant was to ask how we can programmatically get the list of items that are locked. I know we can use show-item-locks from the command line, but I want to be able to do it programmatically.

Thanks

JL

--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/28d770a6-5b09-4e19-a2f8-a907dca33a64n%40googlegroups.com.

Mvreply

unread,
Jun 21, 2021, 11:55:06 AM6/21/21
to jb...@googlegroups.com

Jose,

The link previously supplied:

 

https://docs.zumasys.com/jbase/record-locking/locking-models/#using-the-lock-jedi-to-display-and-clear-locks

 

has examples of jBASE Dynamic Objects (jabba) code being used to obtain details of all locks.

 

See the section on “Finding and reporting record locks”.

 

You must be running a current version of jBASE however -> 5.7.10 or later.

 

Mike

bdeck...@gmail.com

unread,
Jun 21, 2021, 12:09:28 PM6/21/21
to jBASE
While the object interface example depicted in the link provided previously is the best option, you can still use the old-style EXECUTE/CAPTURE and then parse methods of old to provide a programming API of your own.

See the JBC Execute command here:

and take note of the section on the "CAPTURING" clause.

-BD

Jim Idle

unread,
Jun 22, 2021, 12:45:40 AM6/22/21
to jBASE
It sounds very likely to me that you will get more useful answers if you tell us what you are trying to achieve, rather than how to do something.

For instance, why do you need to get the information programmatically? What do you intend to do with the information? Are you trying to track down some application issue? 

Perhaps there are better ways to do what you are trying to do.

To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAHB4ARvcToh8mUCRzEg1N8YW7WdP-VJ6dFK1ovwYm4stvxq6vw%40mail.gmail.com.

JOSE L MARTINEZ-AVIAL

unread,
Jul 1, 2021, 6:29:08 PM7/1/21
to jb...@googlegroups.com
Hello Jim,
  Yep, you are correct. We are using T24 over TAFC. We have some programs that create Funds Transfer, but before creating them the program makes sure nobody is locking one particular account by doing a READU over the account. If the account is locked we do a sleep for a few seconds and try again, until we reach a limit and desist, or the account is unlocked. We are able to pinpoint the port and user that is locking the account, but not the Funds Transfer ID he/she is processing at that moment. We can check it by doing the show-item-locks, but we are looking for a way to do it programmatically so we can retrieve the FT record involved in the lock.

JL

To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAGPPfg-2aBadLA9mDsHCyWxt95M%3DNikv8XXUzp6cFKh4XeT%3DBQ%40mail.gmail.com.

Mvreply

unread,
Jul 1, 2021, 6:33:08 PM7/1/21
to jb...@googlegroups.com

Jose,

In that case, you are not going to get any meaningful answers out of this group, as the code base for the Zumasys/jBASE version is different to that for the Temenos/jBASE one.

 

Mike

 

From: jb...@googlegroups.com <jb...@googlegroups.com> On Behalf Of JOSE L MARTINEZ-AVIAL


Sent: 01 July 2021 23:28
To: jb...@googlegroups.com

Rick Weiser

unread,
Jul 2, 2021, 2:21:00 PM7/2/21
to jBASE
Hi Jose,

As Mike states, this forum is not for T24/Temenos questions.  You will need to contact Temenos for these type questions.

Rick

Jim Idle

unread,
Jul 4, 2021, 11:34:03 PM7/4/21
to jBASE
I should think that T24 keeps that information somewhere outside the locking system. There is, or was, an F.LOCKED file for instance. It also seems that perhaps T24 is too granular (or maybe it has to lock the whole account). So, you will find out that a port/user has a lock taken, but the Fund Transfer ID is a different record to the account record I presume? If the account being locked prevents any other account processing, then maybe that fund transfer isn't even locked? 

I think that you are better asking T24 support for sure as I bet that there are application routines that you can call to find this out.

However, a more philosophical question is "Why do you need to know this?" - if the account is locked, then you either wait for it not to be, or you do not. I am not sure why knowing the funds transfer that someone else is working on benefits anyone? However, I do not know what your code is doing or who is to use it of course, so maybe it is useful information. HOnestly though, I would just use SHOW-ITEM-LOCKS and parse the output. I believe it has a -m option for machine output, expressly for this purpose. 

Jim



To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAHB4ARt5yu50Fq5Prm8y3mGoYJFRVsHzS0YvqeS%3D%3DotBt0abSw%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages