How to identify the Sybase IQ license you have is a sub-capacity one.

[Former Member]

The Solaris Sparc  machine on which Sybase IQ 16 is installed is having 64 cores . But IQ works only when 8 cores are enabled and rest are disabled.

This is limiting the Server to be used by other applications . Is the 8 core license I am having is not  a sub-capacity license ?

[Gisung · Accepted solution]

Hi,

Additionally, please post the output of "cpuinfo -v2".

You can find details how IQ recognizes the cpu info as follows.

[hpita:/gjang/SYSAM-2_0/bin]cpuinfo -v2

...

2015/08/05 16:09:33  is_vpar: Partition ID: ade9747b-266c-11d9-b851-fef500abc8c0

2015/08/05 16:09:33  is_vpar: Machine   ID: ade9747b-266c-11d9-b851-fef500abc8c0

2015/08/05 16:09:33  is_vpar: Partition ID equals Machine ID. Not an HP vPar

2015/08/05 16:09:33  os_is_vm: 0x0

2015/08/05 16:09:33  os_get_cpu_info: 2 logical processors currently in this pset.

2015/08/05 16:09:33  os_get_cpu_info: 2 cores currently in this pset.

2015/08/05 16:09:33  os_get_cpu_info: System-wide currently 2 LCPUS 2 CPUs.

2015/08/05 16:09:33  os_get_cpu_info: socket_id: 0, core_id: 0, logical_id: 0, siblings: 0.

2015/08/05 16:09:33  os_get_cpu_info: socket_id: 0, core_id: 0 (new package)

2015/08/05 16:09:33  os_get_cpu_info: socket_id: 1, core_id: 1, logical_id: 0, siblings: 0.

2015/08/05 16:09:33  os_get_cpu_info: socket_id: 1, core_id: 1 (new package)

2015/08/05 16:09:33  os_get_cpu_info: 2 cores in 2 sockets. Determine chip count using knowledge of ....

....

2015/08/05 16:09:33  os_get_machine_cpu_info: logical: 2, cores: 2, chips: 2, packages: 1

2015/08/05 16:09:33  Machine-wide physical CPUs: 2

2015/08/05 16:09:33  Machine-wide CPU Chips: 2

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

==

Gi-Sung Jang

[Former Member · Accepted solution]

Please find the output of cpuinfo-v2

bash-3.2# ./cpuinfo -v2

....

2015/08/26 17:43:19  FLEXnet Licensing API/v11.5.0.0 build 58045 sun64_u8

2015/08/26 17:43:19  Hostid [101349370]: 90a01234

2015/08/26 17:43:19  os_is_vm: start VM detection check

2015/08/26 17:43:19  os_exec_cmd_via_popen: executing /usr/bin/zonename 2>&1

2015/08/26 17:43:19  os_exec_cmd_via_popen:: popen() OK (errno = 0), returning descriptor ffffffff7f1497c0

2015/08/26 17:43:19  is_zone: zonename=kcdbsvr02-zone

2015/08/26 17:43:19  os_exec_cmd_close: closing pipe descriptor at ffffffff7f1497c0

2015/08/26 17:43:19  is_zone: TRUE

2015/08/26 17:43:19  v12n_is_vm: TRUE

2015/08/26 17:43:19  os_is_vm: 0x40

2015/08/26 17:43:19  cannot get info for processor set

2015/08/26 17:43:19  os_get_cpu_info: sysconf(_SC_NPROCESSORS_ONLN) = 8.

2015/08/26 17:43:19  os_get_cpu_info: sun4v

2015/08/26 17:43:19  os_get_cpu_info: UltraSPARC-T2+

2015/08/26 17:43:19  os_get_cpu_info: chip_id: 0, core_id: 1054 (new chip)

2015/08/26 17:43:19  os_get_cpu_info: UltraSPARC-T2+

2015/08/26 17:43:19  os_get_cpu_info: chip_id: 0, core_id: 1054 (existing core)

2015/08/26 17:43:19  os_get_cpu_info: UltraSPARC-T2+

2015/08/26 17:43:19  os_get_cpu_info: chip_id: 0, core_id: 1054 (existing core)

2015/08/26 17:43:19  os_get_cpu_info: UltraSPARC-T2+

2015/08/26 17:43:19  os_get_cpu_info: chip_id: 0, core_id: 1054 (existing core)

2015/08/26 17:43:19  os_get_cpu_info: UltraSPARC-T2+

2015/08/26 17:43:19  os_get_cpu_info: chip_id: 0, core_id: 1054 (existing core)

2015/08/26 17:43:19  os_get_cpu_info: UltraSPARC-T2+

2015/08/26 17:43:19  os_get_cpu_info: chip_id: 0, core_id: 1054 (existing core)

2015/08/26 17:43:19  os_get_cpu_info: UltraSPARC-T2+

2015/08/26 17:43:19  os_get_cpu_info: chip_id: 0, core_id: 1054 (existing core)

2015/08/26 17:43:19  os_get_cpu_info: UltraSPARC-T2+

2015/08/26 17:43:19  os_get_cpu_info: chip_id: 0, core_id: 1054 (existing core)

2015/08/26 17:43:19  os_get_cpu_info: 1 cores in 1 chips

2015/08/26 17:43:19  os_get_cpu_info: logical: 8, cores: 1, chips: 1, packages: 1

2015/08/26 17:43:19  Logical CPUs: 8

2015/08/26 17:43:19  Physical CPUs: 1

2015/08/26 17:43:19  CPU Chips: 1

2015/08/26 17:43:19  cpuinfo: Hostid = 90a01234

License hostid:        90a01234

Detected 8 logical processor(s), 1 core(s), in 1 chip(s)

Output of sp_iqlmconfig

(DBA)> sp_iqlmconfig;

Property                                      Value                              

Licence Notice                                      

Edition                                       EE                                 

License Type                                  CP                                 

Application Type                              IQ                                 

IQ_CORE License Count in use                  1 (CPU core based)                 

Optional license in use : IQ_UDA              No                                 

Optional license in use : IQ_LOB              No                                 

Optional license in use: IQ_SECURITY          No                                 

Optional license in use: IQ_MPXNODE           No                                 

Optional license in use: IQ_VLDBMGMT          No                                 

IQ_VLDBMGMT License Count in use              0                                  

Optional license in use: IQ_UDF               No                                 

Optional license in use: IQ_IDA               No                                 

Optional license in use: IQ_URIDA             No                                 

Optional license in use: IQ_TS_FSF            No                                 

Email Severity                                NONE                               

SMTP Host                                     smtp                               

SMTP Port                                     25                                 

Email Sender                                  sybase                             

Email Recipients                                                           

(20 rows)

Execution time: 0.106 seconds

We have a license of 8 Core .So 8 core in our case is 8 logical processor as given in the output of cpuinfo.

[Gisung · Accepted solution]

Hi,

According to the output of cpuinfo -v2, IQ recognizes the cpu license as 1 Core.

Because IQ only checks the number of core not logical processor.

You can find the count in use in sp_iqlmconfig output.

IQ_CORE License Count in use 1 (CPU core based).

And IQ only find 1 CPU Chip on this machine.

2015/08/26 17:43:19  Physical CPUs: 1

2015/08/26 17:43:19  CPU Chips: 1

I think You need to check this machine is partitioned logically such as LPAR...

8 logical processors might be affected by hyper-threading , SMT...

Here is an associated KBA regarding Subcapacity license.

2109212 - SySam 2.0 : How to configure the subcapacity with Solaris.

https://i7p.wdf.sap.corp/sap/support/notes/2109212

==

Gi-Sung Jang

[former_member188490]

Hi Amit,

Based on what you describe, you probably have unserved license for 8 core with HOSTID = default host-id in .lic file.

Please check  SyBooks Online

If you are using sub-capacity & unserved license, your .lic file will have HOSTID = the machine-ID, the partition-ID, or the resourceset-ID, depending upon your configuration.

Hope that helps.

Regards

Milind ..