Informix version
Hi, I am not familiar with Informix but need to know the version of Informix that we use. Is there a system table that I can query to get this info ? Any suggestion will be appreciated. Thanks in advance for reply. VL
On 6 Dec 2004 16:47:39 -0800, Vadim.Loevski@sro.vic.gov.au (vl) wrote:
>Hi,
>
>I am not familiar with Informix but need to know the version of
>Informix that we use. Is there a system table that I can query to get
>this info ? Any suggestion will be appreciated.
>
>Thanks in advance for reply.
>
>VL
Assuming that your platform is UNIX, you could try . . .
dbaccess -V
JWC
1. If one has signed in to the client as user "informix" and has the
environmental variables set correctly, almost all the Informix commands
will return the version of the database instance if one adds a "-V"
option. For some of the commands, the Informix engine does not need to
be "up" for these commands to work.
$ oncheck-VInformix Dynamic Server Version7.31.UC7 Software Serial
NumberAAA#A000000
$ onmonitor-VInformix Dynamic Server Version7.31.UC7 Software Serial
NumberAAA#A000000
INFORMIX-4GL Version7.00.U
$ onbar-VInformix Dynamic Server Version7.31.UC7 Software Serial
NumberRDS#N000000
$ onparams-VInformix Dynamic Server Version7.31.UC7 Software Serial
NumberAAA#A000000
$ dbaccess-V
DB-Access Version7.31.UC7Software Serial NumberAAA#A000000
$ onstat-VInformix Dynamic Server Version7.31.UC7 Software Serial
NumberAAA#A000000
$ onstat-shared memory not initialized forINFORMIXSERVER'jayhawk7'
$
2. The release notes will always be under the release/en_us/0333
directory where the Informix product is loaded, i.e.
$INFORMIXDIR/release/en_us/0333.
%whoami
bavila
% head/opt/informix/informix7/release/en_us/0333/IDS_7.3
=================================
MACHINE SPECIFICNOTES
FOR
Informix Dynamic Server 7.31.UC7PRODUCTRELEASE
DATE:09 Aug2000
=================================
PORT NUMBER: 121146, 121151, 121141,121156
IRIS JOB NUMBER: 26763
% head/opt/informix/informix7/release/en_us/0333/ONBARDOC_7.3
=================================
DOCUMENTATIONNOTES
FOR
Backup andRestore Guide for Informix Dynamic
Server7.31.UC7
DATE:09 Aug2000
=================================
Table ofContents
%
3. Another way of checking for the version is writing an SQLstatement
that will query the engine:
$ echo"select unique dbinfo('version', 'full') fromsystables"|dbaccesssysmaster
Databaseselected.
(constant)
InformixDynamic Server Version 7.31.UC7
1row(s) retrieved.
Databaseclosed.
$
Hope this helps. Good luck.
Brice Avila