Sybase IQ 16.0 No sysam license avaliable error.

[Former Member]

I have upgraded the Sybase license one month back then at that time its working fine but now when I connect the Interactive SQL with one of my windows host I am getting an error No sysam license available.

I checked the Licence file there I have

PE=EE;LT=DT

so i maintained the same thing in .lmp file aslo but still the issue dos'nt solved.

Can you please help me out from this problem

Best regards,

Mastan

[Gisung]

Hi,

You can find the path of iqmsg file with the following sql.

select * from sysdbfile where dbfile_name='IQ_SYSTEM_MSG';

And I want to see the output of "sysam diag" on the E:\SYBASE_IQ_16.0\SYSAM-2_0\bin\

Best Regards,
Gi-Sung Jang

[Former Member]

Hi

Gi-Sung Jang,

Please find the location of Bin file

E:\SYBASE_IQ_16.0\SYSAM-2_0\bin

I tried to find the .iqmsg file in the whole logs as well as installation directory but I did not find. I tried to refer one wiki also "https://wiki.scn.sap.com/wiki/display/SYBIQ/IQ+Trace+Files+and+Log+Files" but failed. could you plz help on this

Best regards,

Mastan

[Gisung]

Hi,

Please post the error message in iqmsg file and the output of sysam diag (~/SYSAM-2_0/bin).
ex) /home2/gjang_home/SYSAM-2_0/bin>./sysam diag

IQ is to checkout the license validation when starts up.
And if there are any problems regarding license, the error is logged in iqmsg file.

Best Regards,
Gi-Sung Jang