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$COMMON:[MIMERxxxxx]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. To unpack the ZIP file, just execute it. The installation files will be extracted and placed in the current directory.
$ RUN MIMER-I64VMS-MIMER1106A.ZIPEXE
UnZipSFX 6.00 of 20 April 2009, by Info-ZIP (http://www.info-zip.org).
inflating: MIMER-I64VMS-MIMER1106A-U1100-6A-1.PCSI$COMPRESSED
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 MIMER1106A
Performing product kit validation of signed kits ...
%PCSI-I-CANNOTVAL, cannot validate SIV$DKA300:[PER.SLASK]MIMER-I64VMS-MIMER1106A-U1100-6A-1.PCSI$COMPRESSED;1
-PCSI-I-NOTSIGNED, product kit is not signed and therefore has no manifest file
The following product has been selected:
MIMER I64VMS MIMER1106A U11.0-6A 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 MIMER1106A U11.0-6A
* This product does not have any configuration options.
Execution phase starting ...
The following product will be installed to destination:
MIMER I64VMS MIMER1106A U11.0-6A DISK$I64SYS:[VMS$COMMON.]
Portion done: 0%...10%...20%...30%...40%...50%...60%...70%...90%...100%
The following product has been installed:
MIMER I64VMS MIMER1106A U11.0-6A Layered Product
MIMER I64VMS MIMER1106A U11.0-6A
Insert the following lines in SYS$MANAGER:SYSTARTUP_VMS.COM:
@SYS$STARTUP:MIMER$STARTUP_1106A
Insert the following lines in SYS$MANAGER:SYSHUTDWN.COM:
@SYS$STARTUP:MIMER$SHUTDOWN_1106A
Users need to add the following lines to their login command procedure:
$ @SYS$SYSROOT:[MIMER1106A]SETUP 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$COMMON:[MIMERxxxxx]SETUP.COM for this process
To continue using the newly installed Mimer SQL product in the current process you should execute the SETUP procedure.
$ @SYS$SYSROOT:[MIMER1106A]SETUP VMS
MIMER version 11.0.6A Beta Test Jun 29 2021 Rev 35581
Node name: SIV VMS IA64
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 Mimer SQL SETUP command procedure.
Install your Mimer SQL license key
Mimer requires a license key to be installed. Use the MIMLICENSE command to administrate Mimer licenses. A license for testing purposes is included in the Mimer distribution and can be reached by the logical name MIMER$EXAMPLES.
The MIMLICENSE command is described further in section Installing the Mimer SQL License Key.
$ MIMLICENSE /FILE=MIMER$EXAMPLES:DEFAULTKEY.MCFG
Mimer SQL License Manager Version 11.0.6A Beta Test
Copyright (C) Mimer Information Technology AB. All rights reserved.
License key file: SYS$SPECIFIC:[SYSMGR]MIMERKEY_IA64.DAT
Number Expires Version Module Users Netusers
------ ---------- ------- ------------ ----- --------
-6 2022-01-31 11.0 Beta test *** test and development
Mimer SQL 10 10
Imm restart
XA
Key file updated
Note: The database server must be restarted to enable the new key settings
The Mimer SQL SETUP command procedure
Use the SETUP command procedure in the top directory of a particular Mimer installation to define logical names and commands for the current process. For example:
$ @SYS$SYSROOT:[MIMER1106A]SETUP VMS
MIMER version 11.0.6A Beta Test Jun 29 2021 Rev 35581
Node name: SIV VMS IA64
The parameter to SETUP specifies what style of commands you wish to use. You can also clear any definitions made by a previous SETUP command.
@SYS$SYSROOT:[MIMER1106A]SETUP VMS
This command specifies that Mimer version 11.0.6A 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 SPWAN 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$SYSROOT:[MIMER1106A]SETUP UNIX
This command specifies that Mimer version 11.0.6A 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$SYSROOT:[MIMER1106A]SETUP 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 DKA100:[SYS0.SYSCOMMON.MIMER1106A.] |
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$MIMERAPI |
Selected version of MIMER$MIMERAPI 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 SETUP:
$ @SYS$SYSROOT:[MIMERxxxx]SETUP
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. |
/FILE=file-name |
Adds a license key from a .mcfg file. |
/DELETE=key-id |
Deletes the specified key. |
/REMOVE |
Removes all keys. (Each key must be verified.) |
/LIST |
Lists the contents of the key file. |
/COMBINED |
Describes what the combined keys permits. |
/SILENT |
Silent mode, i.e. execution with no output. |
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 MIMER1106A
The following product has been selected:
MIMER I64VMS MIMER1106A U11.0-6A Layered Product
Do you want to continue? [YES]
The following product will be removed from destination:
MIMER I64VMS MIMER1106A U11.0-6A DISK$I64SYS:[VMS$COMMON.]
Portion done: 0%...20%...30%...40%...50%...60%...70%...80%...90%...100%
The following product has been removed:
MIMER I64VMS MIMER1106A U11.0-6A 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 commands to the OpenVMS startup file SYS$MANAGER:SYSTARTUP_VMS.COM, or the OpenVMS shutdown file SYS$MANAGER:SYSHUTDWN.COM, or the OpenVMS system login file SYS$MANAGER:SYLOGIN.COM, remove these commands.
5If you have added any database-specific commands to the system startup file SYS$MANAGER:SYSTARTUP_VMS.COM, or the shutdown file SYS$MANAGER:SYSHUTDWN.COM, you should remove them.