This chapter describes how to install the Mimer SQL software on OpenVMS. It also documents how to remove a Mimer SQL installation.
•Execute the distribution file to obtain the installation files
•Use PRODUCT INSTALL to install Mimer SQL
•Add commands in SYS$MANAGER:SYSTARTUP_VMS.COM, SYS$MANAGER:SYSHUTDWN.COM and SYS$MANAGER:SYLOGIN.COM
•Execute SYS$MANAGER:MIMER$SETUP.COM to define Mimer commands for this process
•Install your Mimer SQL license key
Execute the distribution file to obtain the installation files
The software is distributed as a self-extracting ZIP file. The file is named MIMERxxxxx-I64.ZIPEXE for the Itanium version, and MIMERxxxxx-X86.ZIPEXE for the x86_64 version. To unpack the ZIP file, just execute it. The installation files will be extracted and placed in the current directory.
$ run mimer1108a-i64.zipexe
UnZipSFX 6.00 of 20 April 2009, by Info-ZIP (http://www.info-zip.org).
inflating: MIMER-I64VMS-MIMER1108A-U1100-8A-1.PCSI$COMPRESSED
inflating: mimer-i64vms-mimer1108a-u1100-8a-1.pcsi$compressed_VNC
Use PRODUCT INSTALL to install Mimer SQL
Use the command PRODUCT INSTALL to install Mimer SQL, just like any other layered product. Please note that the product name includes the version number which is unusual. New versions of Mimer will have new version numbers in the product name which will make all versions of Mimer to appear as different products. This allows multiple versions to be installed at the same time on a machine. The user can select any version by running its SETUP command procedure.
$ product install mimer1108a
Performing product kit validation of signed kits ...
%PCSI-I-VSIVALPASSED, validation of DKA100:[000000]MIMER-I64VMS-MIMER1108A-U1100-8A-1.PCSI$COMPRESSED;1 succeeded
The following product has been selected:
MIMER I64VMS MIMER1108A U11.0-8A Layered Product
Do you want to continue? [YES]
Configuration phase starting ...
You will be asked to choose options, if any, for each selected product and for
any products that may be installed to satisfy software dependency requirements.
Configuring MIMER I64VMS MIMER1108A U11.0-8A: Mimer SQL for OpenVMS
Copyright © 2023 Mimer Information Technology AB. All rights reserved.
Produced by Mimer Information Technology AB
A development license for ten users is included
* This product does not have any configuration options.
Execution phase starting ...
The following product will be installed to destination:
MIMER I64VMS MIMER1108A U11.0-8A DISK$VSI84-2:[VMS$COMMON.]
Portion done: 0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
The following product has been installed:
MIMER I64VMS MIMER1108A U11.0-8A Layered Product
MIMER I64VMS MIMER1108A U11.0-8A: Mimer SQL for OpenVMS
Insert the following lines in SYS$MANAGER:SYSTARTUP_VMS.COM:
@SYS$STARTUP:MIMER$STARTUP_1108A
Insert the following lines in SYS$MANAGER:SYSHUTDWN.COM:
@SYS$STARTUP:MIMER$SHUTDOWN_1108A
Users need to add the following lines to their login command procedure:
$ @SYS$MANAGER:MIMER$SETUP_1108A VMS
Add commands in system startup files
As instructed by the PRODUCT INSTALL command, you should add commands to execute Mimer startup and shutdown procedures.
The procedure SYS$STARTUP:MIMER$STARTUP_1106A installs required shareable images. Add a command to do this in SYS$MANAGER:SYSTARTUP_VMS.COM.
The procedure SYS$STARTUP:MIMER$SHUTDOWN_1106A deinstalls shareable images. Add a command to do this in SYS$MANAGER:SYSHUTDWN.COM.
Any process that is running Mimer SQL must execute the SETUP command procedure for the version of Mimer SQL it wants to use. By adding the SETUP command in SYS$MANAGER:SYLOGIN.COM, a default SETUP is provided for all processes. This makes it easier to manage a version upgrade of Mimer SQL since the command is in a central place.
Execute SYS$MANAGER:MIMER$SETUP_xxxxx.COM for this process
To continue using the newly installed Mimer SQL product in the current process you should execute the SETUP procedure.
$ @SYS$MANAGER:MIMER$SETUP_1108A VMS
An alternative is to log out and log in again. The new process should have executed the SYS$MANAGER:SYLOGIN.COM procedure where you have added the SETUP command.
The SETUP procedure is described further in section The SYS$MANAGER:MIMER$SETUP_xxxxx command procedure.
Install your Mimer SQL license key
Mimer requires a license key to be installed. A license for testing purposes is included in the Mimer distribution and is found in MIMER$EXAMPLES:DEFAULTKEY.MCFG. When Mimer is installed for the first time on a machine, the default key is installed automatically.
If you need to install a new license use the MIMLICENSE command.
The MIMLICENSE command is described further in section Installing the Mimer SQL License Key.
$ MIMLICENSE /FILE=MIMER$EXAMPLES:DEFAULTKEY.MCFG
License key file: SYS$SPECIFIC:[SYSMGR]MIMERKEY_IA64.DAT
Number Expires Version Module Users Netusers
------ ---------- ------- ------------ ----- --------
-6 2023-09-30 11.0 Beta test *** test and development
Mimer SQL 50 50
Imm restart
In-memory
XA
Key file updated
Note: The database server must be restarted to enable the new key settings
The SYS$MANAGER:MIMER$SETUP_xxxxx command procedure
Use the MIMER$SETUP_xxxxx procedure found in SYS$MANAGER to select a Mimer version. The procedure defines logical names and defines commands for the current process. For example:
$ @SYS$MANAGER:MIMER$SETUP_1108A VMS
@SYS$MANAGER:MIMER$SETUP_1108A VMS
This command specifies that Mimer version 11.0.8A should be used. Logical names are defined in the process logical name table. Mimer commands are defined in VMS style (like: MIMCONTROL/START).
Note that if you create a subprocess (by using the SPAWN command), the command definitions will not be active in the there. Use the SETUP command again in the subprocess.
If no parameter is given to the SETUP procedure, VMS will be assumed.
@SYS$MANAGER:MIMER$SETUP_1108A UNIX
This command specifies that Mimer version 11.0.8A should be used. Logical names are defined in the process logical name table. Mimer commands are defined in UNIX style (like: mimcontrol --start).
UNIX command definitions will be transferred to any subprocess you start with the SPAWN command.
@SYS$MANAGER:MIMER$SETUP_1108A CLEAR
Clears all logical names and command definitions made by an earlier invocation of the SETUP procedure.
Logical Names Defined by SETUP
The SETUP command defines the logical names listed below
Logical name |
Description |
---|---|
MIMER$ROOT |
Points to the Mimer installation directory, such as SYS$COMMON:[MIMER1108A] |
MIMER_SQLHOSTS |
Points to the file defining database names |
MIMER$LIB |
Location of header files, etc |
MIMER$DOC |
Location of Mimer documentation |
MIMER$EXAMPLES |
Directory containing example files |
MIMER$EXE |
Location of Mimer executable files |
MIMER$SQL |
Specifies selected version of MIMER$SQL image |
MIMER$ODBC |
Selected version of MIMER$ODBC image |
MIMER$API |
Selected version of MIMER$API image |
MIMER$DBP |
Points to shareable image for shared memory communication |
MIMCOMM |
Selected version of MIMCOMM image |
MIMCOMM64 |
Selected version of MIMCOMM64 image |
Installing the Mimer SQL License Key
Mimer SQL for OpenVMS is free for development and evaluation. A development and evaluation license key is included in the Mimer SQL distribution and is automatically installed.
This means that, as long as you use Mimer SQL for development and/or evaluation, you can set up a complete Mimer SQL environment and work with Mimer SQL without adding any additional license keys.
Mimer SQL for OpenVMS in Production
If you want to use Mimer SQL in production, you must purchase a valid run-time license key and then install it. Please contact your local Mimer SQL representative, see https://www.mimer.com/contact/, or send an e-mail to info@mimer.com.
Node Name
Your representative will need to know the node name of the computer on which the Mimer SQL database server will run.
To obtain the node name, use MIMLICENSE/CPUID:
$ MIMLICENSE/CPUID
GOOFY VMS IA64
Receiving Your Run-time License Key
Your run-time license key and instructions for installing it will be e-mailed to you.
When you receive the file, save it in an accessible directory.
You use the MIMLICENSE utility to administrate the license key file. You can add, remove and update keys using MIMLICENSE.
You can also use MIMLICENSE to list and describe the contents of the key file.
Note:When entering the Mimer SQL license key, you must have appropriate access to the key file.
Adding a License Key using MIMLICENSE
To add a license key
1Assuming a SETUP with VMS-style commands, enter the following:
$ mimlicense /FILE=file_name.mcfg
For example, if the license key file you received was named mimerkey1234.mcfg, you would enter the following:
$ mimlicense /FILE=mimerkey1234.mcfg
The MIMLICENSE program is controlled by options specified on the command-line.
Argument |
Function |
---|---|
/ADD=hexcode |
Adds a license key. |
/COMBINED |
Describes what the combined keys permits. |
/CPUID |
Show the CPU id of the machine. |
/DELETE=key-id |
Deletes the specified key. |
/FILE=file-name |
Adds a license key from a .mcfg file. |
/LIST |
Lists the contents of the key file. |
/NOLOGO |
Silent mode, i.e. execution with no output. |
/REMOVE |
Removes all keys. (Each key must be verified.) |
/VERSION |
Show version number of the MIMLICENSE command. |
The Mimer SQL license keys are stored in the file:
SYS$SPECIFIC:[SYSMGR]MIMERKEY.DAT
Removing a Mimer SQL Installation
Caution:If you plan to remove any Mimer SQL databases, see Removing a Mimer SQL Database before removing the Mimer SQL installation. |
To remove a Mimer SQL installation:
1Check that no Mimer SQL applications or database servers are using the installation.
2Remove the selected Mimer SQL version by using the PRODUCT REMOVE command:
$ PRODUCT REMOVE MIMER1108A
The following product has been selected:
MIMER I64VMS MIMER1108A U11.0-8A Layered Product
Do you want to continue? [YES]
The following product will be removed from destination:
MIMER I64VMS MIMER1108A U11.0-8A DISK$VSI84-2:[VMS$COMMON.]
Portion done: 0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
The following product has been removed:
MIMER I64VMS MIMER1108A U11.0-8A Layered Product
3If there are no other Mimer SQL installation trees in the system, you may want to delete the SQLHOSTS file and the Mimer SQL license key file:
$ DELETE SYS$SPECIFIC:[SYSMGR]SQLHOSTS.DAT.*
$ DELETE SYS$SPECIFIC:[SYSMGR]MIMERKEY_IA64.DAT.*
4If you have added any Mimer SQL-related or database-specific commands to the OpenVMS startup files, you need to remove them. Look in:
SYS$MANAGER:SYSTARTUP_VMS.COM
SYS$MANAGER:SYSHUTDWN.COM
SYS$MANAGER:SYLOGIN.COM