IQ 16.0 No SYSAM License Available ERROR

[Former Member]

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"

[Gisung]

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

[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

[saroj_bagai]

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