Sybase IQ Starts With Graced License

If Sybase IQ cannot check out a license and starts in grace mode, execute the sysam diag feature_name command to check for available licenses.

Execute the sysam diag feature_name command from the $SYBASE/SYSAM-2_0/bin directory, where feature_name is the SySAM feature name for Sybase IQ or the optional feature that is in grace mode. The feature name is printed in the Sybase IQ error log, <dbname>.iqmsg file, and in the optional e-mail notifications.

If the sysam diag command shows no licenses available for check-out, this may be due to one of the following reasons:

Served Models

  • Verify that the license server is running and reachable from the machine you are using. Use sysam status to verify that you can access the license server. If you cannot access the license server, see if the license server is running.

  • If the license server is running, use sysam status -f feature_name to determine whether the license server is serving a license for the given feature. If not, obtain the correct licenses from the Sybase Product Download Center or SAP Service Marketplace.

  • All licenses on the license server may be in use. If sysam status -f feature_name indicates that no licenses are available, obtain additional licenses or shutdown Sybase IQ.

Unserved Models

  • The license for the given feature may not be copied in the local licenses directory. Obtain the correct licenses from the Sybase Product Download Center or SAP Service Marketplace and copy them to the local licenses directory.

  • The license may have been activated for a different machine or activated with incorrect Host ID. Check-in and reactivate the license with the correct Host ID.

Wrong License

  • The available licenses are for a different operating system or architecture. Obtain license for the correct platform from the Sybase Product Download Center or SAP Service Marketplace.

  • If you are running in a terminal server environment, unserved licenses cannot be used. Set up served licenses for a terminal server environment.

  • The available license may not authorize use of this version of Sybase IQ.

  • For information about date based versioning, see "Installing Product Updates, EBFs, and Support Renewal" in the Sybase Software Asset Management Users Guide.

  • For information about how to update your license, see the Updating your Sybase licenses section in the Sybase Software Asset Management Users Guide.

Product Edition or License Type

If the diag command shows the license for the given feature is available for check-out, the reason that Sybase IQ cannot check-out the license could be that the product edition or license type does not match the requirement.

  • If the edition and license type configuration parameters are set, Sybase IQ uses only the license that matches these settings.

  • Run sp_iqlmconfig to see the configured values.

  • Check the VENDOR_STRING attribute of the licenses to make sure a matching license exists. If a matching license does not exist, obtain a suitable license from the Sybase Product Download Center or SAP Service Marketplace, or adjust the Sybase IQ configuration.

If Sybase IQ cannot start because the grace period expired, examine the iq.default.lmp file located in the $IQDIR15/Sysam directory under your parent installation directory for values. These values are stored in two lines that start with PE= and LT=. These lines are present only if the configuration is set.