sybase IQ license check

[Former Member]

Hi Team,

Is there a stored procedure /system view / system table , Where we can get IQ information  like validity  of license . 

I am using un severed licensing mode .

Thanks,

Razal

[tayeb_hadjou]

Same as in unserved license. See in boot messages of IQ message file:

Example:

"Using licenses from:....

Checked out license for x IQ_CORE (xxxx) will expire Wed Apr 01 00:00:00 2020".

[former_member213865]

this is msg while booting....served lic is on other hosts..still not able to find

I. 05/24 03:21:55. 0000000000 Using licenses from: /APP/SYSAM-2_0/licenses/IQLICF.lic:/APP/SYSAM-2_0/licenses/IQLICP.lic:/home/iqip1/*.lic I. 05/24 03:21:55. 0000000000 Checked out license for 18 IQ_CORE (9999.12310/permanent/15F2 0A4C E701 DBD6). I. 05/24 03:21:55. 0000000000 This product is licensed to: XX COMPANY I. 05/24 03:21:55. 0000000000 Checked out license for 1 IQ_MPXNODE (9999.12310/permanent/1DC8 7FA5 5919 2BAD).

[tayeb_hadjou]

Hi Razal,

Is this solved ?

Thanks,

Tayeb.

[Former Member]

Hi,

Unfortunately no, I was looking for expiry date in specific which is not available in that stored procedure.

Thanks,

Razal

[tayeb_hadjou]

Expiration date is usually logged in boot messages in iqmsg file.

Eg.

I. 06/08 04:17:05. 0000000000 Using licenses from: /sybase//iq154/SYSAM-2_0/licenses/keyserver.lic:/sybase/iq154/IQ-15_4/demo/*.lic

I. 06/08 04:17:06. 0000000000 Checked out license for 14 IQ_CORE (2015.0331/31-mar-2015/16yyyyyyyy) will expire Wed Apr 01 00:00:00 2015.

I. 06/08 04:17:06. 0000000000 WARNING: IQ functionality that requires the IQ_CORE license will be disabled on Wed Apr 01 00:00:00 2015, unless a suitable IQ_CORE license is obtained before that

date.

I. 06/08 04:17:06. 0000000000 This product is licensed to:zzzzz

Regards,

Tayeb.

[tayeb_hadjou]

Hi Mohammed,

System procedure sp_iqlmconfig and first lines from srvlog/iqmsg logs :

Verify Your License

Regards,

Tayeb.