Distributed Files

When installing Mimer SQL with the PRODUCT INSTALL command, a new directory named [MIMERxxxxx] is created under SYS$COMMON:, where xxxxx is the version number of the product. A few files are placed outside the Mimer directory in system directories.

Files in System Directories

The names of files placed in system directories are suffixed with _xxxxx, where xxxxx is the version number of the Mimer product.

File Name

Description

SYS$MANAGER:MIMER$SETUP_xxxxx.COM

Command procedure that defines logical names and commands so a process can use this version of Mimer.

SYS$SHARE:MIMCOMM_xxxxx.EXE

Image for fast Mimer access in 32-bit Java

SYS$SHARE:MIMCOMM64_xxxxx.EXE

Image for fast Mimer access in 64-bit Java

SYS$SHARE:MIMER$DBP_xxxxx.EXE

Protected image for shared memory communication

SYS$SHARE:MIMER$DBS_xxxxx.EXE

Executable code for single-user access

SYS$SHARE:MIMER$API_xxxxx.EXE

Shareable image with the Mimer SQL C API

SYS$SHARE:MIMER$ODBC_xxxxx.EXE

Image containing the ODBC interface

SYS$SHARE:MIMER$SQL_xxxxx.EXE

Image containing the API for Embedded SQL

SYS$STARTUP:MIMER$SHUTDOWN_xxxxx.COM

Command procedure that deinstalls shareable images. Should be called from SYS$MANAGER:SYSHUTDWN.COM

SYS$STARTUP:MIMER$STARTUP_xxxxx.COM

Command procedure that installs shareable images. Should be called from SYS$MANAGER:SYSTARTUP_VMS.COM

SYS$SYSROOT:[000000]MIMERxxxxx.DIR

Directory tree with files for this specific version of Mimer SQL

Files in the Mimer Root Directory

File Name

Description

VERSION.DAT

Contains the version number of the Mimer SQL distribution.

Documentation Files (MIMER$DOC)

File Name

Description

DTOA_LICENSE.TXT

License text for the DTOA library used by Mimer SQL,

MIMER_LICENSE.TXT

License text for Mimer SQL

MIMJDBEN.PDF

JDBC usage guide.

MIMPERF_T4.TXT

Describes how to add Mimer SQL performance metrics to the T4 tool.

MIMSQLEN.PDF

The Mimer SQL documentation.

MIMVMS.PDF

The VMS guide.

RELNOTEN.PDF

Mimer SQL Release Notes.

Example Files (MIMER$EXAMPLES)

File Name

Description

BLOBSAMP.EC

Example of a program written in embedded C that stores and retrieves binary data.

BLOBSAMP.MSQ

BLOBSAMP_PRG.C

A Module SQL example that stores and retrieves binary data.

COMINGSOON.EC

Example program in embedded C that calls a PSM procedure.

COMINGSOON.MSQ

COMINGSOON_PRG.C

A Module SQL program that calls a PSM procedure.

DEFAULTKEY.MCFG

Mimer license for up to ten simultaneous users. For testing purposes.

DSQL_CALLER.C

DSQL_MODULE.MSQ

A Module SQL program using dynamic SQL.

DSQL.EC

Embedded C examples that demonstrates the use of dynamic SQL.

DSQL.H

Header file for the dynamic SQL example.

DSQLSAMP.C

Main program for the dynamic SQL example.

DYNCALL.EC

Example program in embedded C that demonstrates a dynamic query.

EXAMPLE.EC

Very simple embedded C example.

EXAMPLE.ECO

Very simple embedded COBOL example.

EXAMPLE.EFO

Very simple embedded FORTRAN example.

Example.java

Java example program using JDBC.

EXAMPLE.MSQ

EXAMPLE_PRG.C

EXAMPLE_PRG.COB

EXAMPLE_PRG.FOR

EXAMPLE_PRG.PAS

Simple Module SQL example with code in various languages calling the procedure.

EXDAT.SQL

A BSQL script that populates an example database.

EXDEF.SQL

A BSQL script that creates example users, tables and procedures.

MIMERAPIEX1.C

Simple Mimer SQL C API test program.

MIMERAPIEX2.C

Simple Mimer SQL C API test program.

MIMERAPIEX3.C

Simple Mimer SQL C API test program.

MULTILANG.EC

An embedded C program coded in UTF-8 having a table name using Unicode characters.

OSQL.C

An ODBC example

SIMPLE.EC

Simple embedded SQL program in C.

SIMPLE.ECO

Simple embedded SQL program in COBOL.

SIMPLE.EFO

Simple embedded SQL program in FORTRAN.

SIMPLE.MSQ

SIMPLE_PRG.C

SIMPLE_PRG.COB

SIMPLE_PRG.FOR

SIMPLE_PRG.PAS

A simple Module SQL example with code calling the procedures from C, COBOL, FORTRAN and PASCAL.

SINGLEDEFS.DAT

Contains a template for database parameters in single-user mode, see the Mimer SQL System Management Handbook.

SQLHOSTS.DAT

Contains a template for the SQLHOSTS.DAT file.

The actual SQLHOSTS file is pointed to by the MIMER_SQLHOSTS logical name (normally SYS$MANAGER:SQLHOSTS.DAT).

Do not edit this template file.

T4$MIM_MON.COM

Command procedure that helps with integrating Mimer SQL with the T4 tool. See MIMER$DOC:MIMPERF_T4.TXT for more information

Executable Programs (MIMER$EXE)

File Name

Description

BSQL.EXE

Program that executes SQL statements which are entered interactively or read from a command file. It is described in the Mimer SQL User’s Manual.

DBANALYZER.EXE

Program that analyzes a database schema and provides suggestions for optimizations.

DBC.EXE

Program that can check if a databank file is internally consistent. It is described in the Mimer SQL System Management Handbook.

DBOPEN.EXE

Program that opens and restarts all databanks in a database. It is described in the Mimer SQL System Management Handbook.

ESQL.EXE

Pre-processor for embedded SQL.

EXLOAD.EXE

Program to load the example database.

MIMCONTROL.EXE

The MIMCONTROL command, which is used to control database servers,The MIMCONTROL Command.

MIMER$SETUP_CLEAR.COM

Procedure to remove logical names, commands and symbols pointing to this version.

MIMEXPER.EXE

The Mimer SQL Experience database server. Do not start this program directly. Use MIMCONTROL to start a database server and specify which type of server to start by setting the parameter ServerType in the MULTIDEFS.DAT file.

MIMINFO.EXE

Program that can display status information for a database server.

MIMINM.EXE

The Mimer SQL InMemory database server. Do not start this program directly. Use MIMCONTROL to start a database server and specify which type of server to start by setting the parameter ServerType in the MULTIDEFS.DAT file.

MIMLICENSE.EXE

Application used to administrate the license key(s).

MIMLOAD.EXE

Utility to load and unload data.

MIMPERF.EXE

A program to display server performance counters.

MIMREPADM.EXE

Administration utility for Mimer Replication.

MIMSYNC.EXE

Utility to bring two replicated Mimer systems back into sync.

MIMTCP.EXE

The program executed by the MIMTCP server, see The MIMTCP Server. Do not start this program directly.

MSQL.EXE

A preprocessor for Module SQL. Described in the Module SQL chapter of the Mimer SQL Programmer’s Manual.

REPSERVER.EXE

Mimer Replication server.

SDBGEN.EXE

Program used to create the initial Mimer SQL system databank files in a database, described in the Mimer SQL System Management Handbook.

SQLMONITOR.EXE

SQL Monitor tool. Described in the Mimer SQL System Management Handbook.

TCPCONTROL.COM

Procedure to manage MIMTCP processes.

Library Files (MIMER$LIB)

File Name

Description

MIMER.CLD

Command definitions for all the executable programs supplied with the Mimer SQL software.

MIMER.HLB

HELP library for Mimer.

MIMER$API.OPT

Options file used for linking Mimer SQL C API applications.

MIMER$ODBC.OPT

Options file used for linking ODBC applications.

MIMER$SQL.OPT

Options file used for linking Mimer SQL embedded applications.

MIMERAPI.H

Header file for Mimer SQL C API programs.

MIMERRORS.H

Header file for Mimer SQL C API programs.

MIMJDBC3.JAR

JDBC 3 driver.

MIMODBC.H

C-definitions for Mimer ODBC specific descriptor attributes, working with 64-bit integers.