[Info-vax] Other than Oracle, What MySQL/DBMS options are there for OpenVms?

[Stephen Hoffman]

On 2019-03-22 18:31:53 +0000, Simon Clubley said:

> On 2019-03-22, Bill Gunshannon <bill.gunshannon at gmail.com> wrote:
>> On 3/21/19 11:04 PM, Stephen Hoffman wrote:
>>> 
>>> Irrespective of what I've seen listed in Wikipedia, PostgreSQL is *not* 
>>> available for OpenVMS,
>> Just out of curiosity, is there a particular reason for this?  Other 
>> than just no one being interested enough to work on a port.
> IIRC, there are technical limitations with certain functionality not 
> available on VMS. I think one of the issues was to do with SSIO.

Among other details, there's a latent OpenVMS storage I/O corruption.

A discussion of Shared Stream I/O (SSIO) issues, per HP:

> On OpenVMS, concurrent POSIX write() calls to the same file can corrupt data
> - POSIX I/O on OpenVMS not atomic 
> − Data updates can get lost
> − Disk can get mixed data from overlapping writes 
> Consistency not guaranteed for files opened for shared write

http://de.openvms.org/TUD2012/opensource_and_unix_portability.pdf



-- 
Pure Personal Opinion | HoffmanLabs LLC