F.E. Version

Can anyone tell me what the F.E. Version number maps to with an onstat -g ses? I'm trying to find anything running old drivers from our daemons and can't seem to find any mapping for this anywhere.

It is the internal ESQL/C version corresponding to the CSDK with which a client app was compiled. V9.41 is equivalent to CSDK v4.10, V9.31 is CSDK v3.70, etc. V7.24 was the last ESQL/C independent of the CSDK. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 5, 2014 at 2:32 PM, NATE HICKS <nathaniel.hicks@trnswrks.com>wrote: > Can anyone tell me what the F.E. Version number maps to with an onstat -g > ses? > I'm trying to find anything running old drivers from our daemons and can't > seem to find any mapping for this anywhere. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0112bfb8ed8ffa04f3e17bc4

Is there a list or something for this? A way to find out what the f.e. version is mapped to is really what I'm looking for I think. And as always thank you Art!

There is not public mapping or documentation of which I am aware. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 5, 2014 at 3:19 PM, NATE HICKS <nathaniel.hicks@trnswrks.com>wrote: > Is there a list or something for this? A way to find out what the f.e. > version > is mapped to is really what I'm looking for I think. And as always thank > you > Art! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c37ae48cace804f3e2376e

Hi, I was looking at this only yesterday and was thinking that it would be useful if there was a list of mappings. A further two for the wish list is being able to get F.E. Version from sysmaster, rather than just 'onstat -g sql'; and the version being detailed enough to see what fix pack of the CSDK you're using. Seeing this post, I decided to look into this in more detail. One anomoly I noticed while cross-referencing these is that because 'dbaccess' never used to be shipped with CSDK or I-Connect, I found 'dbaccess' binaries from old releases mixed with newer CSDKs on our application servers. In the case of a connection from 'dbaccess', the version reported on the Informix server is not that of the CSDK: it's the version of an older CSDK related to the 'dbaccess' binary. However to complicate things, 'dbaccess' binaries are stamped with an Informix server version, not the corresponding CSDK version as seen on the server. More cross-referencing connections gave further anomolous results. This really makes me wonder what exactly F.E. Version is showing. The 11.70 manual says "the version of the SQLI protocol used by the client program". It appears to be sometimes reporting the CSDK version on the client, presumably in the case of non-compiled applications, and sometimes the value is coming from the application binary. I haven't definitely worked this out. Some of my results then; you can see they are not consistent at all: 9.24 -> 3.50.UC8 (seems wrong: connection from dbaccess 9.40.xC3) 9.28 -> 3.50.xC8 (seems wrong: application connection, maybe compiled against old CSDK) 9.29 -> 2.90.xC1 9.35 -> 3.50.xC8 9.37 -> 3.70.xC7 or 3.70.xC8 The first value is the F.E. Program value reported on the Informix server and what I found it matched to when I checked out what was installed on the client machine. Ben.

You can see the FE version for a connection in sysmaster in several tables: syssqlcurses, syssqlcurall, syssqscb, syssqlstat However, very odd thing, for me (v12.10.FC2 w/CSDK v 4.10.FC2) I get feversion is 9.03 from all sysmaster records but onstat -g ses reports v9.24 when I connect using dbaccess! For my own utilities (ex: myschema) compiled with CSDK v4.10.FC2, onstat -g ses report v9.41 while sysmaster reports v9.03. Weird! Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Mar 6, 2014 at 6:08 AM, BENJAMIN THOMPSON < benjamin.thompson@bskyb.com> wrote: > Hi, > > I was looking at this only yesterday and was thinking that it would be > useful > if there was a list of mappings. A further two for the wish list is being > able > to get F.E. Version from sysmaster, rather than just 'onstat -g sql'; and > the > version being detailed enough to see what fix pack of the CSDK you're > using. > > Seeing this post, I decided to look into this in more detail. > > One anomoly I noticed while cross-referencing these is that because > 'dbaccess' > never used to be shipped with CSDK or I-Connect, I found 'dbaccess' > binaries > from old releases mixed with newer CSDKs on our application servers. In the > case of a connection from 'dbaccess', the version reported on the Informix > server is not that of the CSDK: it's the version of an older CSDK related > to > the 'dbaccess' binary. However to complicate things, 'dbaccess' binaries > are > stamped with an Informix server version, not the corresponding CSDK > version as > seen on the server. > > More cross-referencing connections gave further anomolous results. This > really > makes me wonder what exactly F.E. Version is showing. The 11.70 manual says > "the version of the SQLI protocol used by the client program". > > It appears to be sometimes reporting the CSDK version on the client, > presumably in the case of non-compiled applications, and sometimes the > value > is coming from the application binary. I haven't definitely worked this > out. > > Some of my results then; you can see they are not consistent at all: > > 9.24 -> 3.50.UC8 (seems wrong: connection from dbaccess 9.40.xC3) > 9.28 -> 3.50.xC8 (seems wrong: application connection, maybe compiled > against > old CSDK) > 9.29 -> 2.90.xC1 > 9.35 -> 3.50.xC8 > 9.37 -> 3.70.xC7 or 3.70.xC8 > > The first value is the F.E. Program value reported on the Informix server > and > what I found it matched to when I checked out what was installed on the > client > machine. > > Ben. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c364867bf3d704f3ef66fd

Hi Art, Thanks for pointing out which system tables it's in. I was expecting syssessions but it's clear that underneath it's more complicated. Maybe this is why it's not documented? Ben.