<docbook><section><title>HowCanIDetectMyIngresDBMSVersion</title><para> </para><title>Detecting the Ingres DBMS version</title>Detecting the Ingres DBMS version
<para>Ingres versions have been very confusing over the years.
 They went up to Ingres 6.x; then renamed to Ingres II 1.x and 2.x; then renumbered back to Ingres II 9.x, which was also branded r3 (3.0.x) and Ingres 2006; and now Ingres 9.3; and coming soon Ingres 10.x.</para><para>There are a few ways to learn the version of <emphasis>your</emphasis> Ingres installation.</para><para>If you have any functional SQL connection to the Ingres instance, you should be able to execute the following query -- </para><programlisting>SELECT _version();
</programlisting><para> Output will look something like this -- </para><programlisting>II 2.6/0305 (hp2.us5/00)
</programlisting><para> There are simple text files on Windows and Unix which should reveal the version information -- 
</para><table><title /><tgroup><thead /><tbody>
<row><entry> <emphasis>Windows</emphasis>  </entry><entry> <span style="color: red">
      UNKNOWN tag:
      http://www.w3.org/1999/xhtml:nowiki$II_SYSTEM/ingres/version</span>  </entry></row>
<row><entry> <emphasis>Unix</emphasis>  </entry><entry> <span style="color: red">
      UNKNOWN tag:
      http://www.w3.org/1999/xhtml:nowiki$II_SYSTEM/ingres/version.rel</span>  </entry></row>
</tbody></tgroup></table>
<para>This (and much more) information may also be found in the <computeroutput>install.log</computeroutput> file, typically found in the  <computeroutput>$II_SYSTEM/ingres/files/</computeroutput> directory, where it will look something like this -- </para><programlisting>This procedure will set up the following release of the Ingres
Intelligent DBMS:

		 II 2.6/0305 (hp2.us5/00)
</programlisting></section></docbook>