SQL/R A.04.00 Release Notes

SQL/R A.04.00 License keys

SQLR A.04.00 requires a license key version A.04.00 or above. A previous license key for an older version does no longer work.

The Online License Request form may be used to request license keys for the Eloquence and SQL/R products. This is an automated process and provides an immediate license key if the prerequisites are met.

System specific license
A system specific license is available for a system that was previously registered and is covered by a maintenance agreement or where a temporary license was issued for this system.
Installation license
This obtains a temporary license valid for 30 days. Please note that an installation license may be requested only once per system and product. If a license was issued before for a system then requesting an installation license will not succeed.

To request a license key the sytem ID must be obtained with the gethwid utility. Please be aware that a system may use more then a single ID number and the system may have been registered with any of these ID. The gethwid -a option is used to obtain all results for use with the online license request form to identify a system.

Alternatively, please contact the Marxmeier team at info@marxmeier.com to request a license key.

Please note: The installation on HP-UX and Windows does no longer provide the option to create a temporary license key during installation. Please use the online license request form to obtain a temporary license key for the initial installation or an updated license key for a supported license.

When using Eloquence with the free Personal Edition license option and no SQL/R license is present, a free two user SQL/R license is granted for evaluation and testing purposes.

The SQL/R software id (SWID) necessary to request a license key may be obtained using the gethwid utility. The installed license keys may be verified using the chklic utility.

It is necessary to install SQL/R to use these utilities. They are located in the SQL/R etc installation subdirectory, by default:

HP-UX and Linux: /opt/sqlr/4.0/etc/gethwid
/opt/sqlr/4.0/etc/chklic
Windows (64-bit): C:\Program Files (x86)\Marxmeier\SQLR\4.0\etc\gethwid
C:\Program Files (x86)\Marxmeier\SQLR\4.0\etc\chklic

By default, the gethwid utility only returns a primary SWID. By specifying the -a option, all applicable SWID values are output.

For example:

On HP-UX and Linux:

/opt/sqlr/4.0/etc/gethwid
3535806523

/opt/sqlr/4.0/etc/gethwid -a
3535806523
P2366910547
M2366910547

On 64-bit Windows:

C:\> "C:\Program Files (x86)\Marxmeier\SQLR\4.0\etc\gethwid.exe"
3247020679

Any license keys must be added to the license file manually. It is recommended to comment out (or delete) any previous license keys when adding the new A.04.00 license key(s) to the license file.

HP-UX and Linux: /etc/opt/sqlr/4.0/license
Windows (64-bit): C:\Program Files (x86)\Marxmeier\SQLR\4.0\etc\license

The chklic utility may be used to verify the license file.

A copy of the default license key template file is also available.

HP-UX and Linux: /opt/sqlr/4.0/newconfig/config/license
64-bit Windows: C:\Program Files (x86)\Marxmeier\SQLR\4.0\etc\license.sam

When editing the license file on Windows, please pay attention to not modify the template file by accident, which may happen when your Windows Explorer folder settings suppress the display of known file extensions (like .sam) by default.

Please notice:

The SQL/R A.04.00 gethwid utility may return a different SWID on some HP-UX systems when using partitions (npar/vpar) compared to SQL/R releases before A.03.00. In this case the SWID value starts with a 'P'. The previous SWID is still valid, though.
When requesting an updated license key please provide the previous SWID (or uname -i output) in addition to the new 'P' SWID.
On Windows the SQL/R SWID might in some cases differ from the Eloquence SWID