Re: How to know the Informix Version running
Also 'ifx_getversion clientsdk' if that information is of interest.
Regards,
Johann Tienhaara
Informix Software Ireland
Obnoxio The Clown wrote:
>
> onstat -
>
> From: "Thierry Achaintre" <thierry.achaintre@euriware.fr>
> >
> >Can someone tell me how can I do to determine which version and release =
> >of Informix is running on an AIX box ?
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
But it is harder to find the answer when the server is
not on the same machine as the client.
The only imperfect way I know of is to interrogate SysTables
for the Owner of the tabname ' VERSION' (yes, there's a blank in there).
Unless, that is, someone cares to enlighten me...
Johann Tienhaara wrote:
> Also 'ifx_getversion clientsdk' if that information is of interest.
>
> Obnoxio The Clown wrote:
> >
> > onstat -
> >
> > From: "Thierry Achaintre" <thierry.achaintre@euriware.fr>
> > >
> > >Can someone tell me how can I do to determine which version and release =
> > >of Informix is running on an AIX box ?
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN
#include <disclaimer.h>
Doesn't that just reflect the install version and not subsequent
upgrades?
Jonathan Leffler wrote:
>
> But it is harder to find the answer when the server is
> not on the same machine as the client.
>
> The only imperfect way I know of is to interrogate SysTables
> for the Owner of the tabname ' VERSION' (yes, there's a blank in there).
>
> Unless, that is, someone cares to enlighten me...
>
> Johann Tienhaara wrote:
>
> > Also 'ifx_getversion clientsdk' if that information is of interest.
> >
> > Obnoxio The Clown wrote:
> > >
> > > onstat -
> > >
> > > From: "Thierry Achaintre" <thierry.achaintre@euriware.fr>
> > > >
> > > >Can someone tell me how can I do to determine which version and release =
> > > >of Informix is running on an AIX box ?
>
> --
> Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
> Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN
> #include <disclaimer.h>
--
Paul Watson #
WF Software Ltd # You are only young once
Tel: +44 1436 674729 # but you can be immature
Fax: +44 1436 678693 # for ever
www.wfsoftware.com #
Paul Watson wrote:
> Doesn't that just reflect the install version and not subsequent
> upgrades?
It's not quite that simple. If you upgrade the server and it has
something different in the catalog (or elsewhere in the reserved
pages, or ...), then the version gets changed. At least, that's
more or less my understanding. But you're right, it isn't guaranteed
to be the same as the UC9X3 version that you've got installed, and
that's why I said it was an imperfect method. I think it is usually
reliable to the 7.24 vs 7.30 vs 7.31 level, but I'm not even certain
of that.
So, I'm still hoping someone will enlighten me how to determine the
exact version that's running on the remote server without using rlogin
and running onstat or oninit on the remote machine...
> Jonathan Leffler wrote:
> > But it is harder to find the answer when the server is
> > not on the same machine as the client.
> >
> > The only imperfect way I know of is to interrogate SysTables
> > for the Owner of the tabname ' VERSION' (yes, there's a blank in there).
> >
> > Johann Tienhaara wrote:
> > > Also 'ifx_getversion clientsdk' if that information is of interest.
> > >
> > > Obnoxio The Clown wrote:
> > > > onstat -
> > > >
> > > > From: "Thierry Achaintre" <thierry.achaintre@euriware.fr>
> > > > >
> > > > >Can someone tell me how can I do to determine which version and release
> > > > >of Informix is running on an AIX box ?
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN
#include <disclaimer.h>
Jonathan Leffler wrote:
>
[cutting]
>
> So, I'm still hoping someone will enlighten me how to determine the
> exact version that's running on the remote server without using rlogin
> and running onstat or oninit on the remote machine...
>
Manually maintain it in your own table:-)))
--
Paul Watson #
WF Software Ltd # You are only young once
Tel: +44 1436 674729 # but you can be immature
Fax: +44 1436 678693 # for ever
www.wfsoftware.com #
Jonathan Leffler wrote:
>
[cutting]
>
> So, I'm still hoping someone will enlighten me how to determine the
> exact version that's running on the remote server without using rlogin
> and running onstat or oninit on the remote machine...
>
Maybe this should be added as part of the return of dbping???? I'm sure
if Informix release the dbping src somebody would sort it out for
them;-)
--
Paul Watson #
WF Software Ltd # You are only young once
Tel: +44 1436 674729 # but you can be immature
Fax: +44 1436 678693 # for ever
www.wfsoftware.com #