Readu locks should always be for the shortest period of time. Having locks
open for long periods of time can cause issues such as the lock table
filling up causing other issues. The performance issues can be significant
and this is why RDBMS go to optimistic locking.
Unless the record is lock
I have tested your programs with one major difference on my UV9.6: PGM2 eventually
abandoms the wait but does not go into the THEN block, i.e., the 'READU END' is not
displayed. As per Martin's email, the time to wait is controlled by the LOCK.WAIT.
Sibut Pascal <[EMAIL PROTECTED]> wrote:Dear al
Brian,
This is absolutely horrendous (my personal opinion). See the email below
dated a couple of years back from Charles Stevenson that describes the
problem and the fix. This is so nasty that I kept the mail!
Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton N
Do you have AUTOLOGOUT set?
Issue an AUTOLOGOUT 0 (zero) to unset it, or AUTOLOGOUT to check it.
Regards,
Brian Leach
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sibut Pascal
Sent: 11 October 2004 17:12
To: '[EMAIL PROTECTED]'
Subject: [U2] Readu lo
Are you running the deadlock universe process? That could be doing it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sibut Pascal
Sent: 11 October 2004 17:12
To: '[EMAIL PROTECTED]'
Subject: [U2] Readu lock lost after 1 hour.
Dear all,
I had problem in