Skip to Content
avatar image
Former Member

Sybase IQ 16.0 No sysam license avaliable error.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 20, 2017 at 10:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2017 at 11:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2017 at 05:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded