Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2011-10-27T03:02:18Z by SystemAdmin
Hekmati
Hekmati
1 Post
ACCEPTED ANSWER

Pinned topic No. of Session for Informix 11.5 if we buy 5xD0D20ll

‏2011-10-17T11:08:48Z |
Dear Informix Experts
Our company decided to buy license a copy of Informix 11.5 Ultimate edition for 5 users. I have a question : is the No. of sessions unlimited for every user if we buy 5xD0D20LL ?
Thanks a lot
M.Hekmati
Updated on 2011-10-27T03:02:18Z at 2011-10-27T03:02:18Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    228 Posts
    ACCEPTED ANSWER

    Re: No. of Session for Informix 11.5 if we buy 5xD0D20ll

    ‏2011-10-17T23:34:00Z  in response to Hekmati
    Hi.

    Having just been through an IBM licensing review and from my understanding of that process, you will be allowed 5 sessions open at any one time. However, the database server runs it's own sessions that are not counted. Here is a query that should help you to identify your session utilisation count.

    select count(*) concurrentsessions
    from sysmaster:sysrstcb
    where sysmaster:bitval(flags,1)>0 { only count busy threads }
    and sysmaster:bitval(flags,'0x80000')!=0 { only count primary threads }
    and sysmaster:bitval(flags,'0x200')==0 { remove daemon threads}
    and sysmaster:bitval(flags,'0x40')==0 { remove log backup users }
    and sysmaster:bitval(flags,'0x80')==0 { remove onmonitor users }
    and sysmaster:bitval(flags,'0x2000')==0 { remove page cleaners}
    and sysmaster:bitval(flags,'0x00000400')==0 { remove archive threads}
    and sysmaster:bitval(flags,'0x00004000')==0 { remove recovery threads}
    and sysmaster:bitval(flags,'0x00100000')==0 { remove idx blder }
    and sysmaster:bitval(flags,'0x00200000')==0 { remove btree scanner }
    and sysmaster:bitval(flags,'0x04000000')==0 { remove main loop}
    and flags < ";

    I'm making the assumption that this is consistent internationally.

    There is no easy way to restrict user sessions on the database server. In 11.5 there is a LIMITNUMSESSIONS configuration parameter, but the notes on this say:

    "The LIMITNUMSESSIONS configuration parameter is not intended to be used as a means to adhere to license agreements."

    This is because the LIMITNUMSESSIONS doesn't stop DBSA connections which count towards the overall user limit.

    Regards.
    • SystemAdmin
      SystemAdmin
      228 Posts
      ACCEPTED ANSWER

      Re: No. of Session for Informix 11.5 if we buy 5xD0D20ll

      ‏2011-10-27T03:02:18Z  in response to SystemAdmin
      Correction to SQL script as posted in my prior response. For some reason the last line of the script should read flags < 0x20000000 (with quotes) but for some reason if I put quotes around the 0x20000000 it doesn't display.

      select count(*) concurrentsessions
      from sysmaster:sysrstcb
      where sysmaster:bitval(flags,1)>0 { only count busy threads }
      and sysmaster:bitval(flags,'0x80000')!=0 { only count primary threads }
      and sysmaster:bitval(flags,'0x200')==0 { remove daemon threads}
      and sysmaster:bitval(flags,'0x40')==0 { remove log backup users }
      and sysmaster:bitval(flags,'0x80')==0 { remove onmonitor users }
      and sysmaster:bitval(flags,'0x2000')==0 { remove page cleaners}
      and sysmaster:bitval(flags,'0x00000400')==0 { remove archive threads}
      and sysmaster:bitval(flags,'0x00004000')==0 { remove recovery threads}
      and sysmaster:bitval(flags,'0x00100000')==0 { remove idx blder }
      and sysmaster:bitval(flags,'0x00200000')==0 { remove btree scanner }
      and sysmaster:bitval(flags,'0x04000000')==0 { remove main loop}
      and flags < 0x20000000 -- (add quotes around 0x20000000)