Mimer SQL RDBMS for OpenVMS 9.2.3C Apr  5 2005
=====================================================================


Introduction
------------
Mimer SQL is a high performance Relational Database Management System
(RDBMS), targeted at mission-critical production environments. Mimer
SQL offers scaleable performance, including multi-processor support,
and because it is available on all major UNIX, Linux, Windows
XP/NT/2000/98 and OpenVMS platforms, it is ideally suited for open
environments where interoperability is important.

The Mimer SQL product is available for both the Alpha and Integrity
(Itanium) platforms.

Mimer SQL's run-time characteristics, such as high performace,
ease-of-use, stability and self-tuning, makes it well suited for
software products with an embedded DBMS and for
Internet/intranet/extranet applications where a maximum of database
up-time and a minimum of database administration are often required.

Through its 100% conformance to the SQL standards, a native
implementation of the ODBC interface and a JDBC driver, a Mimer SQL
database can be accessed by a large number of different development
tools.

For further details and questions, visit http://www.mimer.com


The package
-----------
The Mimer SQL distribution contains the following:

- Complete documentation
- A default license allowing up to ten concurrent users for development
  and testing.
- Tools, utilities, libraries, examples, etc.
- Java-based debugger for PSM (stored procedures)
- Embedded SQL preprocessor for C, FORTRAN and COBOL
- ODBC driver shared library
- JDBC driver, type-4, written in 100% Java. Three drivers are supplied,
  compatible with JDBC 1 (requires JDK 1.1.8), JDBC 2 (requires Java 1.2)
  and JDBC 3 (requires Java 1.4 or later).
- Client/server support for TCP/IP. The OpenVMS platform can act as
  both client and server and access Mimer SQL clients or servers on
  all platforms where Mimer SQL is supported.


Documentation
-------------
The Mimer SQL documentation is currently in PDF format. The
documentation is included in the OpenVMS distribution. The
documentation can be located by following the MIMDOC9 logical name
which is defined by the MIMSETUP9 command procedure.


Unpacking Mimer SQL on OpenVMS
------------------------------
NOTE: On Integrity, you need OpenVMS 8.2
      On Alpha, you need OpenVMS 7.3 or later!
      If you use OpenVMS 7.3 you need the PTHREAD-V0300 patch
      If you use OpenVMS 7.3-1 you need the PTHREAD-V0400 patch
      Patches for OpenVMS can be found at:
        http://www.support.compaq.com/patches/


The Mimer SQL software is distributed as a self-extracting ZIP file.
This version of Mimer SQL for Open VMS can be fetched from the
following FTP addresses:
        ftp://ftp.mimer.com/pub/dist/openvms_alpha/mimer923C.exe
        ftp://ftp.mimer.com/pub/dist/openvms_integrity/mimer923C.exe

To unpack the file, simply execute it. A new directory will be created
in your current default directory.
        $ SET DEF somedisk:[000000]
        $ COPY [somewhere]MIMER923C.EXE []
        $ RUN MIMER923C


Installing the Mimer SQL software
---------------------------------
Before Mimer SQL can be used, some images must be installed. This is
done by running the MIMSETUP9 command procedure. Since this must be
done each time the system is booted, you may want to include the
following commands in your SYSTARTUP_VMS.COM file.
        $ @somedisk:[MIMER923C]MIMSETUP9 SYS


Define Mimer SQL DCL commands
-----------------------------
You may want to add the following command to your LOGIN.COM file:
        $ SET COMMAND MIMLIB9:MIMER


Creating a new Mimer SQL database
---------------------------------
First create a home directory for your database:
        $ CREATE/DIR somedisk:[TESTDB]

Add the database to the SYS$MANAGER:SQLHOSTS.DAT list. Edit the file
and add a line under the "LOCAL" section:
        $ EDIT SYS$MANAGER:SQLHOSTS.DAT
        (Add a line: "TESTDB      somedisk:[TESTDB]")

Create the initial databank files. You may use the default values for
all questions except the SYSADM password. Do not forget the password
you enter for SYSADM!
        $ SDBGEN TESTDB

Start a database server for the database:
        $ MIMCONTROL/START TESTDB


Executing SQL statements
------------------------
You can define a logical name to set the default database you are using:
        $ DEFINE MIMER_DATABASE TESTDB

Enter SQL statements interactively by using the BSQL program.
Remember to end each statement with a semicolon (;).
Passwords are case sensitive!

        $ BSQL
        Username: SYSADM
        Password:         (The one you mustn't forget!)
        SQL> CREATE IDENT MYUSER AS USER IDENTIFIED BY 'MYPWD';
        SQL> SELECT CURRENT_TIMESTAMP FROM MIMER.ONEROW;


Further reading
---------------
* The "Mimer SQL VMS Guide" in the documentation package.
* The rest of the manuals in the documentation package.
* The examples directory (MIMEXAMPLES9:).
* The Mimer web site:   http://www.mimer.com


Good luck!
info@mimer.com