Introduction

About Mimer SQL 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
MIMSETUP Syntax
MIMSETUP Examples
Logical Names Defined by MIMSETUP
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
Using a Memory Resident Buffer Pool
Determining Buffer Pool Size
Process Quotas for the Database Server
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 (MIMDOC)
Example Files (MIMEXAMPLES)
Executable Programs (MIMEXE)
Library Files (MIMLIB)
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 9 Applications With Mimer SQL Version 10

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