1752590 Members
3618 Online
108788 Solutions
New Discussion юеВ

Re: Informix DB version

 
SOLVED
Go to solution
Sanjiv Sharma_1
Honored Contributor

Informix DB version

Hi,

What is the command to check the Informix DB version in IDS2000 ver. 9.x and 7.x?

Thanks,
Everything is possible
4 REPLIES 4
Michael Tully
Honored Contributor
Solution

Re: Informix DB version

As long as the instance is up and you have your env set correctly

$ onstat -
Informix Dynamic Server 2000 Version 9.21.FC5X9 -- On-Line -- Up 2 days 11:42:09 -- 3746104 Kbytes
Anyone for a Mutiny ?
Ricky B. Nino
Frequent Advisor

Re: Informix DB version

Hi,

#onstat -
this will display the version of your INFORMIX DB.

#onstat -a
this will display all info related to your INFORMIX DB.

regards...
Opportunities expand for people willing to put time and effort into learning new skills.
Ravi_8
Honored Contributor

Re: Informix DB version

Hi,

If you already have a database instance running
$onstat command returns you with options,using any one of theose option you can find the installed informix version, i am not sure about that option.
never give up
Animesh Chakraborty
Honored Contributor

Re: Informix DB version

#onstat -V (Caps V)
or
#oncheck -V
It should work while database is down.
I can not shutdown my databse to test it now :))
Did you take a backup?