Introduction

Since the first release of Mimer on VMS in 1982 (Mimer version 3.1 on VAX VMS 3), a large number of Mimer users have deployed their solutions on the VMS platform.

Mimer SQL on OpenVMS provides a server platform that provides performance and scalability for mission-critical database applications.

Description

Mimer SQL is used in many mission critical systems running OpenVMS on HP Integrity servers worldwide. With Mimer SQL customers benefit from a high performance and zero maintenance DBMS.

For features in Mimer SQL, see the article Mimer SQL overview as a starting point.

Default License

A default license for testing and development is included, it allows up to ten concurrent users. For license upgrades, please contact Mimer SQL sales.

Database Server

The Mimer SQL database server is a single, multi-threaded process. By using DecThreads, good SMP scalability is achieved.

Clients using TCP/IP or Decnet can access the server. For clients running on the same platform, a special shared-memory based communication method is used.

Embedded SQL

An embedded SQL preprocessor is included. It enables SQL commands to be embedded in programs written in C, C++, FORTRAN and COBOL. The embedded syntax complies with the ISO standard for embedded SQL.

Module SQL

A Module SQL preprocessor is included. It enables separation of SQL code and a host application written in C, FORTRAN, COBOL or Pascal into different source files, simplifying modularity and reuse of SQL code.

JDBC Driver

A JDBC driver is included in the distribution. The driver is a type 4 driver, which means that it is written entirely in Java. This provides the driver with full portability so that it can be copied or downloaded to any Java-enabled platform. The driver uses TCP/IP to access a Mimer SQL server (version 10.0 or later) on any platform.

If the JDBC application executes on the same node as the Mimer SQL server, it can also use a shared memory for fast communication by mapping a native library.

The supplied driver conforms to JDBC 3 (requires Java 1.4 or later).

Use vmssoftware.com/products/openjdk/ for more information about Java on OpenVMS.

ODBC Driver

The Mimer ODBC driver is a client library that enables applications to access Mimer SQL database servers running on any platform. The driver complies with the ODBC 3.52 specification.

By using the ODBC driver on OpenVMS, you can develop ODBC applications and execute them on the OpenVMS platform.

Unlike other platforms, OpenVMS does not include a Driver Manager that enables OpenVMS applications to dynamically load drivers for different database products. Until such a Driver Manager becomes available on OpenVMS, you can link your applications directly to the Mimer ODBC driver.

Note that in order to run an ODBC application on a Windows platform, the Windows ODBC driver has to be installed on the client side. This driver can then access Mimer database servers on any platform (including OpenVMS). There is no need to install any special software on the server side in order to use ODBC.

Mimer SQL C API

Mimer SQL C API is a native C library suitable for tool integration and application development in environments where API standardization is not a requirement. The following characteristics describe the API:

  • Simplicity
  • Platform independence
  • Small footprint
  • Tight fit with the Mimer SQL application/database communication model.

The so called “MimerAPI” is provided in the MIMERAPI shared library and the mimerapi.h header file provides prototypes and other handy defines. See Database API article for MimerAPI and the Mimer SQL Programming Manual, found in the Mimer SQL Documentation Set at the Documentation page.

Documentation

The Mimer SQL product for OpenVMS includes the Mimer manuals in Adobe PDF format. If your OpenVMS system does not have software installed to view PDF files, you should transfer the files to another platform with better PDF viewing support.

Alternatively, point your browser to the Mimer SQL documentation page and read the documentation in HTML format.

Utilities

Mimer SQL includes command-line utilities for creating databases, load and unload of data, backups, performance monitoring, etc.

There is also a program that enables SQL statements to be executed interactively from a command prompt.

The Mimer SQL distribution also contains examples of database programs and SQL statements.

T4

The product includes an adapter to the T4 tool. This allows Mimer SQL server metric data to be collected together with OpenVMS metrics.

For more information on T4, see vmssoftware.com/products/t4/

Products

Developer and evaluation versions of Mimer SQL for all platforms, including OpenVMS, are available for free download from the Mimer SQL developer web site downloads page.

Notes

Mimer SQL V11 requires Open VMS 8.4-2L1 or later on the HP Integrity Server platform.

Links

For further details, please see our Howto and Feature articles. Or, contact Mimer SQL Support.

Graphic Element - Cube