SQLstream s-Server Licensing

<< Click to Display Table of Contents >>

Navigation:  Administering SQLstream Blaze >

SQLstream s-Server Licensing

Previous pageReturn to chapter overviewNext page

SQLstream s-Server supports multi-threaded architecture. It leverages multiple CPU cores common in today's servers by executing queries in parallel. You can configure the number of parallel threads before starting up SQLstream s-Server. In most cases, SQLstream s-Server will run as many parallel threads for every available CPU cores on a host machine. Nevertheless, that the optimum number of parallel threads is influenced by the anatomy of queries running in s-Server's runtime.

SQLstream licensing directly affects this facet of s-Server, because the number of parallel threads of execution cannot exceed the number of cores for which s-Server is licensed. In other words, a license for 8 CPU cores allows you to run SQLstream s-Server with 8 parallel threads.

Initial trial license

When you first install SQLstream s-Server, you are granted a trial license for 60 days of product evaluation. This trial license places no limit on the number of parallel number of threads in SQLstream s-Server.

Expiration of evaluation period and throttle mode

After the evaluation period, SQLstream s-Server will start in a "throttle mode." In throttle mode, s-Server will run one execution thread for for one hour. After a grace period of 1 hour, s-Server will shut itself down.

Installing a trial license

SQLstream s-Server's installers installs a 60 day evaluation license if there is no trial license installed already. (If an existing license is found, this license will be used.) After the trial license expires, you need to request a new trial license from SQLstream. In most cases, SQLstream will provide a new trial license.

To load a new license, open a shell window and run the following commands:

$ cd $SQLSTREAM_HOME/s-Server/licensing

$ LD_LIBRARY_PATH=.: ./appactutil -local <asrFileName>


Note: $SQLSTREAM_HOME refers to the installation directory, such as /opt/sqlstream/5.1.0.XXX.

Viewing licenses

To view currently activated licenses, open a shell window and run the following command:

$ showLicenses.sh


This command will return something like the following:

Searching for SQLstream s-Server licenses...

 1. A permanent license for 10 cores found

 2. Evaluation license found; Expires 13-aug-2012


SQLstream s-Server will use the first unexpired license it finds.

Purchasing and activating a license

Once you purchase a license for SQLstream s-Server, you will receive an "entitlement ID." This is essentially a registration key that you will enter into s-Server.

To activate the license using this entitlement ID

1.Open a shell window and enter the following:

$ cd $SQLSTREAM_HOME/s-Server/licensing

$ LD_LIBRARY_PATH=. ./appcomptranutil -new activate_request.xml -activate <entitlementID>


The activation request will be generated as an xml file called "activate_request.xml."

2.Send this file to support@sqlstream.com.

SQLstream will process the activation request and generate an xml repsonse, a file called "activate_response.xml."

Upon receiving activate_response.xml, you will need to activate (load) the license on the host machine.

3.To do so, open a shell window and run the following commands:

$ cd $SQLSTREAM_HOME/s-Server/licensing

$ LD_LIBRARY_PATH=. ./appcomptranutil -process activate_response.xml


Once you do so, your license is activated and SQLstream s-Server will run parallel threads per the terms of your license.

Viewing details on an installed license

To view detailed information about installed licenses, open a shell window and run the following command:

$ cd $SQLSTREAM_HOME/s-Server/licensing

$ LD_LIBRARY_PATH=.: ./appactutil -view


This shows detailed information about installed licenses. Each license has a "Fulfillment ID".

Returning a license

To return a license open a shell window and run the following command:

$  LD_LIBRARY_PATH=.: ./appcomptranutil -new <license_return.xml> -return <fulfillmentID>


The customer needs to send license_return.xml to SQLstream and process the response file sent by SQLstream to complete the return.

$  LD_LIBRARY_PATH=.: ./appcomptranutil -process <license_return.response.xml>

Deleting a license

To delete a license, open a shell window and run the following commands:

$ cd $SQLSTREAM_HOME/s-Server/licensing

$ LD_LIBRARY_PATH=.: ./appactutil -delete <fulfillmentID>