helpinghand
search
needassistance
 
Mimer SQL on OpenVMS
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.

While retaining compatibility for old customers, new versions contains enhanced database functionality. For the latest version the following features can be mentioned:
  • Support for distributed transactions with XA

  • A new utility for bulk data load and unload

  • Unicode and Collations allows language specific sorting

  • Automatic block fetch of data enhances read performance


Description

A Mimer SQL Engine distribution contains several components:

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. By using special interlocked instructions found in the Alpha architecture together with $HIBER and $WAKE calls, the local client/server communication is extremely fast.

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.

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 8.2 or later) on any platform.

Two versions of the driver are included. The mimjdbc2.jar driver supports JDBC 2 with J2EE extensions and is intended for modern Java 2 platforms.

The mimjdbc1.jar driver supports the old JDBC version 1.2 specification and is suitable for use with Java 1.1.8 or later. Use this version on platforms that supports older Java versions.

Use h18000.www1.hp.com/java/alpha/index.html 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.


Documentation

The Mimer SQL product for OpenVMS includes the Mimer manuals if Adobe PDF format. To view the manuals, either use the XPDF utility that is available on the OpenVMS Freeware CD-ROM, or 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, 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.

Notes

The VAX architecture is not supported by later Mimer SQL Engine versions since the DecThreads upcall mechanism is not available there.

Mimer SQL V9.2 should be used with OpenVMS 7.3 or later. If you use OpenVMS 7.3, the patch PTHREAD_V0300 is needed. If you use OpenVMS 7.3-1, the patch PTHREAD_V0100 is needed.

Links

OpenVMS documentation (http://h71000.www7.hp.com/doc/).

OpenVMS patches (http://h71000.www7.hp.com/serv_support.html).

Download Mimer SQL Engine for Open VMS from our download page.

For further details, please see our Howto and Feature articles. Or, contact Mimer SQL Support.
Last updated: 2003-12-16

 

Powered by Mimer SQL

Powered by Mimer SQL