Topic
  • 2 replies
  • Latest Post - ‏2011-10-27T03:02:18Z by SystemAdmin
Hekmati
Hekmati
1 Post

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

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

    ‏2011-10-17T23:34:00Z  
    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

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

    ‏2011-10-27T03:02:18Z  
    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.
    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)