Introduction

About Mimer SQL Engine for OpenVMS
The Mimer SQL Database Server
Embedded SQL
JDBC Driver
ODBC Driver
Utilities
OpenVMS System Requirements
User Requirements
Documentation Resources
Documentation Conventions
Terms and Definitions

Installing Mimer SQL

Overview
Unpacking the Mimer SQL Distribution File
Unpacking the ZIP File
The Mimer SQL Directory Tree
Setting-up the Mimer SQL Environment
MIMSETUP9 Syntax
MIMSETUP9 Examples
Logical Names Defined by MIMSETUP9
Installing the Mimer SQL License Key
Mimer SQL for OpenVMS in Production
The MIMLICENSE Utility
Removing a Mimer SQL Installation

Establishing a Database

Overview
Creating a Home Directory
Editing the SQLHOSTS File
Adding a Local Database
Specifying the Default Database
Generating System Databanks and SYSADM
SDBGEN
Generating the System Databanks
Accessing a Remote Database
Adding a Remote Database
Mimer SQL System Settings
Setting-up Logical Names and Install Images
Setting the Command Style
Automatic Database Server Start
Automatic Database Server Shutdown
Removing a Mimer SQL Database

Managing a Database Server

The MIMCONTROL Command
Database Server Parameters - the MULTIDEFS File
MIMCONTROL Syntax
MIMCONTROL (/STATUS/DCL)
The MIMTCP Server
Controlling MIMTCP servers
Troubleshooting Tips

Running Mimer SQL Applications

Executing Mimer SQL Utilities
Using the DCL command RUN
Using OpenVMS Command Definitions
Using the DCL$PATH Logical Name
Running the PSM Debugger
Starting the PSM Debugger
Selecting a Mimer SQL Installation

Using the JDBC Driver

Using the JDBC Driver
Defining Java Commands
Setting CLASSPATH
Verifying the Environment
Testing the Connection

Appendix A Distributed Files

Root Directory Files
Documentation Files (MIMDOC9)
Example Files (MIMEXAMPLES9)
Executable Programs (MIMEXE9)
Library Files (MIMLIB9)
Shared Images

Appendix B Data Types Used in Mimer SQL

Compiling Applications Using Floating Point Data Types
Internal Mimer SQL Representation
External Data Types Supported by Mimer SQL

Appendix C Using Version 8 Applications With Mimer SQL Version 9

Relink the Application
Remap the Shareable Libraries
Continue With the Old Shared Library

Appendix D Using Version 7 Applications With Mimer SQL Version 9

License Keys
Communication Methods
Re-linking Applications
Remapping Shareable Libraries
Client-server Access
Local Client/server Access