Re: Should COBOL be lockedUP for good?...
- From: "Richard" <riplin@xxxxxxxxxxxx>
- Date: 18 May 2005 13:15:15 -0700
> I think I'd drive the locking more actively than waiting for
> system-supplied timeouts.
That seems to be primarily a Windows deficiency, or at least a
deficiency of Fat Client using shared files. MS-DOS based systems were
even worse as there seemed to be no timeout at all.
Unix had no record locking mechanism until Xenix was added so compiler
systems built their own locking (or used C-ISAM's).
I mainly used DRI multiuser systems for many years, starting with MP/M
II and MF CIS Cobol + FileShare the Level II and Cobol/2 on
Concurrent-DOS. These gave OS level record locks that were reliable and
released immediately if the process stopped or crashed.
Before I moved to Linux I tested to ensure that automatic unlocking
occurred reliably and quickly. Running a small number of systems on
Windows (granted it was long ago) had demonstrated that if a client
machine is switched off or rebooted, or the 'close' tag clicked, while
it held a lock invaribly resulted in eventually having to reboot the
whole network (well at least the file server).
I don't think that 'Timeouts' are sensible. There may be good reasons
why I would want to lock a record for some hours, there are certainly
good reasons why I want all locks released immediately if the client
dies.
> Anyway, why go to all that trouble when an RDBMS will handle it all
properly?
You raise a good point. What exactly does happen on Windows if I do a
'SELECT .. FOR UPDATE' and obtain a lock and then turn simply pull the
network cable from my client machine ?
Would it remain locked awaiting my next instruction ? Would it be
polling the client machine to see if I was still there ? or would it
..... timeout ?
.
- References:
- Re: Should COBOL be lockedUP for good?...
- From: Robert Jones
- Re: Should COBOL be lockedUP for good?...
- From: William M. Klein
- Re: Should COBOL be lockedUP for good?...
- From: Michael Russell
- Re: Should COBOL be lockedUP for good?...
- Prev by Date: Cobol history question -- lawsuit against standards committee
- Next by Date: Re: IBM S/390 memory model amd COBOL
- Previous by thread: Re: Should COBOL be lockedUP for good?...
- Next by thread: Re: Should COBOL be lockedUP for good?...
- Index(es):
Relevant Pages
|