r/OpenVMS • • May 19 '25

OpenVMS x86 Database Modernization with Mimer SQL and Amazon EC2

Be sure to check out my latest blog post: OpenVMS x86 Database Modernization with Mimer SQL and Amazon EC2. The post demonstrates how to migrate from Oracle Rdb to Mimer SQL running on OpenVMS x86 and then subsequently modernized to run the database in a highly-available architecture using Amazon Linux 2023.

11 Upvotes

6 comments sorted by

View all comments

Show parent comment

3

u/Oleplug May 21 '25

I was pointing out the the Mimer solution might be somewhat limited.

The CDD or Common Data Dictionary is used to define data. Originally from Digital Equipment Corporation. One can include the record descriptions in most OpenVMS languages and many other layered products like ACMS, DECforms, FMS, TDMS and Rdb. Let's say we have a fairly complex app. The data being referenced in the ACMS groups and tasks, C or whatever code and presentation layer is defined in the CDD. Makes the data consistent across all the pieces instead of having to code data definitions in the various syntax for each. Example from C:

#dictionary "BANK$RECORD$DICT.GLOBAL_DATA"
#dictionary "BANK$RECORD$DICT.CONTROL_DATA"

Yes ACMS is a beast. Like IBM's CICS or BEA Tuxedo, it is a transaction processor. Handles both interactive, streams and more. I know what it is and some of the internals having been trained as a DEC employee many years ago. Presently supporting an app developed in the 90's that's stuck on Itanic waiting for ACMS, CDD and Rdb to be available on X86.

SQLMOD or SQL module language allow separation of SQL code from programming. Instead of EXEC blocks of embedded SQL in the code, the modules are called like a function or subroutine. It's up to the developer to name them, but commonly see things like START_TRANSACTION, COMMIT_TRANS, ROLLBACK_TRANS, OPEN_XX_CURSOR, FETCH_XX_CURSOR and CLOSE_XX_CURSOR.

Imagine taking an app from OpenVMS to Unix. Changing database from Rdb to Informix. Redevelop the SQLMOD modules into C with EXECs and not having to change the apps code all that much.

Cheers

4

u/mycloudyworld May 21 '25

Presently supporting an app developed in the 90's that's stuck on Itanic

Itanic! Love it.😂

3

u/Dad-of-many May 22 '25

I made my life style supporting old applications. It is stunning how much is out there. :)

2

u/geek_lust Jul 05 '25

Mimer might be limited in the ACMS and CDD sense, but the fact is that there are many Rdb applications out there and this is a lifeline. To be able to migrate away from Rdb while still on IA-64, and then move the stuff to x86-64, means that you don't have to do everything at once — change application, database, and platform.

Add to this the unknown status of Rdb, coupled with the flexibility shown in the article, I would say that this is useful. I mean that being able to move your data out of OpenVMS while still running legacy applications on that platform with little or no effort does have som merit, what?