Skip to Content
avatar image
Former Member

IQ 16.0 No SYSAM License Available ERROR

Hi,

I have a unserved  license for my host. But the system always complains"no sysam license available".  I copied the license file in the C:\Sybase\SYSAM-2_0\licenses folder already and check the lmp file for the database. I ve done everything but still no luck.

can anyone help me with this?

I attached the license file here since it is available only on my host.

# Sybase Software Asset Management License File. DT License for SAP IQ

# Enterprise Edition

PACKAGE IQ_EE SYBASE COMPONENTS=IQ_CORE SUPERSEDE ISSUED=29-sep-2015 \

  SIGN2="07C6 F0BC C4EE E616 1D82 B7E9 E2FF DA6F EF17 C9A9 1845 \

  26C7 E686 F379 9B18 082C 8CBB 0313 4EE0 E918 AF92 3BB9 0942 \

  7CE4 F006 E931 E76E A075 B235 744F"

# License for 005056af7f8a uspalw546

INCREMENT IQ_EE SYBASE 2017.02100 10-feb-2017 uncounted \

  VENDOR_STRING=PE=EE;LT=DT;AP=IQ HOSTID=005056af7f8a \

  ISSUER="CO=Sybase, Inc.;V=15.0;AS=D;CP=1;MP=550;EGO=" \

  ISSUED=29-sep-2015 NOTICE="SAP Internal License Key" \

  SN=1-1889-OW111122 TS_OK SIGN2="1FED 0E1D 476B EB74 45F3 50C7 \

  ECCA 5252 F990 61A2 D7EB ECE8 E6DC 9CBA 2031 0FAA 89CB A375 \

  D02C 1982 0416 2564 3B01 2ED8 58CB 9582 F120 0CEF 7142 409C"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 07, 2015 at 10:43 PM

    Hi,

    Here are possible causes:

    1. Insufficient core

        - You can see the error messages regarding insufficient cores in iqmsg file.

    2. Not identical LT between license file and lmp file.

        LT=DT(license) =! LT=CP(lmp)

    3. invalid hostid

       - you can know this problem with sysam utility.

         ~/SYSAM-2_0/bin/sysam diag

    ==

    Gi-Sung Jang

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Adding to Gi-sung Jang's response:

      2. Not identical LT between license file and lmp file.

          LT=DT(license) =! LT=CP(lmp)

      If the license type (LT) in the INSTANCE.lmp does not match the license file (something.lic), you can simply update the LT= directly in the INSTANCE.lmp file.  Make sure you change ONLY that line.  As always, save a copy of the file before you edit it.

      1. Insufficient core

          - You can see the error messages regarding insufficient cores in iqmsg file.

      3. invalid hostid

         - you can know this problem with sysam utility.

           ~/SYSAM-2_0/bin/sysam diag

      me> $SYBASE/SYSAM-2_0/bin/cpuinfo

      License hostid:        898436573062

      Detected 32 logical processor(s), 16 core(s), in 2 chip(s)

      The number of cores you need for the license is the "logical processors".  In the example above you would need 32 core license. The host id that sysam will use is also shown in the cpuinfo output.

      jason

  • Oct 07, 2015 at 10:34 PM

    Could you please post complete error message from .iqmsg and sp_iqlmconfig output

    Add comment
    10|10000 characters needed characters exceeded