<HTML ><HEAD ><TITLE >Ingres</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.63 "><LINK REL="HOME" TITLE="Ingres II HOWTO" HREF="index.html"><LINK REL="PREVIOUS" TITLE="Introduction" HREF="intro.html"><LINK REL="NEXT" TITLE="System Requirements" HREF="sysreq.html"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >Ingres II HOWTO</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="intro.html" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="sysreq.html" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="INGRES" >2. Ingres</A ></H1 ><P >In this section the <SPAN CLASS="APPLICATION" >Ingres II Relational Database Management System</SPAN > is introduced and you come to know how to get it.</P ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="UNIV" >2.1. University Ingres and Commercial Ingres</A ></H2 ><P >Let us start with an important fact: there are two different types of <SPAN CLASS="APPLICATION" >Ingres</SPAN >. The original one, which was designed and developed in the seventies by a research group led by Michael Stonebraker at the University of California, Berkeley, was the first open source relational database management system: it was free to use and distribute, source code included. In fact, it <EM >is</EM > still free software, although its development stopped in 1989. Its last version (version 8.9) made it into some Linux distributions as well. If you are interested in it, you can download it from, say, the SuSE site. The packages are:</P ><P ></P ><UL ><LI ><P ><A HREF="ftp://ftp.suse.com/pub/suse/i386/current/suse/ap1/ingres.rpm" TARGET="_top" > The main software</A ></P ></LI ><LI ><P ><A HREF="ftp://ftp.suse.com/pub/suse/i386/current/suse/ap1/ingrtool.rpm" TARGET="_top" > The tools</A ></P ></LI ></UL ><P >In 1979, with the foundation of Relational Technology, the career of <SPAN CLASS="APPLICATION" >Commercial Ingres</SPAN > started. Since 1995 it has been distributed by Computer Associates. Its latest version is <SPAN CLASS="APPLICATION" >Ingres II 2.0</SPAN >. This HOWTO deals with the installation of this type of <SPAN CLASS="APPLICATION" >Ingres</SPAN >.</P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="SDK" >2.2. The Software Development Kit</A ></H2 ><P ><SPAN CLASS="APPLICATION" >Ingres</SPAN >, being commercial software, is not free to use. However, <SPAN CLASS="ACRONYM" >CA</SPAN >, like most <SPAN CLASS="ACRONYM" >RDBMS</SPAN > vendors, offers a free version of it (the Software Development Kit) to everyone who is interested in learning <SPAN CLASS="APPLICATION" >Ingres</SPAN >. The <SPAN CLASS="ACRONYM" >SDK</SPAN > has two variants, one for Windows NT and one for Linux. These variants are not quite the same as far as the included components are concerned. Obviously, we are engaged in installing the <SPAN CLASS="ACRONYM" >SDK</SPAN > for Linux here. This contains the following elements:</P ><P ></P ><UL ><LI ><P >Intelligent DBMS: the database engine.</P ></LI ><LI ><P >Internet Commerce Enabled (<SPAN CLASS="ACRONYM" >ICE</SPAN >): <SPAN CLASS="APPLICATION" >Ingres</SPAN >' propriatery <SPAN CLASS="ACRONYM" >CGI</SPAN > solution to connect a database to the Web.</P ></LI ><LI ><P >Enhanced Security: the tool supporting mandatory access control.</P ></LI ><LI ><P >C2 Security Auditing: the possibility of C2 level auditing.</P ></LI ><LI ><P >Terminal Monitors: forms-based and command line <SPAN CLASS="ACRONYM" >SQL</SPAN > interfaces.</P ></LI ><LI ><P >Querying and Reporting Tools: forms-based querying, report-writing and report-running tools plus a forms editor.</P ></LI ><LI ><P >Querying and Reporting Runtime: like the previous one, but without the forms editor.</P ></LI ><LI ><P >Vision Pro: integrated, forms-based development environment with a code generator.</P ></LI ><LI ><P >Embedded <SPAN CLASS="ACRONYM" >SQL</SPAN > Precompilers: precompilers for embedding <SPAN CLASS="ACRONYM" >SQL</SPAN > statements in <SPAN CLASS="ACRONYM" >3GL</SPAN > applications. Supported languages are: C, C++, COBOL, and Fortran.</P ></LI ></UL ><P >You can order a free copy of the <SPAN CLASS="APPLICATION" >Ingres</SPAN > <SPAN CLASS="ACRONYM" >SDK</SPAN > CD on <A HREF="http://www.cai.com/registration/cd_ingres.htm" TARGET="_top" > http://www.cai.com/registration/cd_ingres.htm</A >.</P ><P >Remember that you are not allowed to use the <SPAN CLASS="ACRONYM" >SDK</SPAN > in a business environment. It is for evaluating <SPAN CLASS="APPLICATION" >Ingres</SPAN > and prototyping applications only.</P ><P >The <SPAN CLASS="ACRONYM" >SDK</SPAN > CD contains both the Windows NT and the Linux versions of the Software Development Kit. You can find the Linux files in the following directories:</P ><P ></P ><UL ><LI ><P ><TT CLASS="FILENAME" >/doc</TT >: the manuals in <SPAN CLASS="ACRONYM" >PDF</SPAN > format, together with the Linux version of <SPAN CLASS="APPLICATION" >Acrobat Reader</SPAN > (<TT CLASS="FILENAME" >linux-ar-40.tar.gz</TT >). The installer will not copy the documentation to hard disk. These manuals are also available on <A HREF="http://www.cai.com/products/ingres/documentation_set.htm" TARGET="_top" > http://www.cai.com/products/ingres/documentation_set.htm</A >. I will reference some of them later in this document.</P ></LI ><LI ><P ><TT CLASS="FILENAME" >/int_lnx</TT >: this directory contains <TT CLASS="FILENAME" >ingres.tar</TT >, the tarball to be installed. <TT CLASS="FILENAME" >ingres.tar</TT > can be installed directly from the CD or you can copy it to hard disk first.</P ></LI ></UL ><P >Do not forget to read the <TT CLASS="FILENAME" >Readme</TT > file in the root directory on the CD.</P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="BETA" >2.3. The Beta Version</A ></H2 ><P >The freshest beta version of the <SPAN CLASS="ACRONYM" >SDK</SPAN > can always be downloaded from <A HREF="http://www.cai.com/products/betas/ingres_linux/ingres_linux.htm" TARGET="_top" > http://www.cai.com/products/betas/ingres_linux/ingres_linux.htm</A >.</P ><DIV CLASS="NOTE" ><P ></P ><TABLE CLASS="NOTE" WIDTH="100%" BORDER="0" ><TR ><TD WIDTH="25" ALIGN="CENTER" VALIGN="TOP" ><IMG SRC="../images/note.gif" HSPACE="5" ALT="Note"></TD ><TD ALIGN="LEFT" VALIGN="TOP" ><P >At the time of writing, the version of the downloadable beta is 2.5. The next revision of the HOWTO will cover the installation of this version, too. The 2.0 beta is still available on <A HREF="ftp://ftp.cai.com/pub/marketing/ingres/ingresII9808libc6.tar" TARGET="_top" > ftp://ftp.cai.com/pub/marketing/ingres/ingresII9808libc6.tar</A >.</P ></TD ></TR ></TABLE ></DIV ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="FULL" >2.4. The Ingres II Full Edition</A ></H2 ><P >In February 2000 Computer Associates announced the general availability of <SPAN CLASS="APPLICATION" >Ingres II 2.0</SPAN > for Linux. Besides the components found in the <SPAN CLASS="ACRONYM" >SDK</SPAN >, the full edition contains more modules, such as:</P ><P ></P ><UL ><LI ><P >Net: this component makes possible for <SPAN CLASS="APPLICATION" >Ingres</SPAN > utilities and user applications to access databases residing on different installations.</P ></LI ><LI ><P >Replicator: support for replication functions.</P ></LI ><LI ><P >Star: for handling distributed databases.</P ></LI ><LI ><P >Enterprise Access: communication with different database management systems and other, non-relational data sources (used to be called Gateways).</P ></LI ><LI ><P >Protocol Bridge: for communicating with clients on different types of networks.</P ></LI ><LI ><P >Spatial Object Library: for handling two-dimensional spatial objects.</P ></LI ></UL ><P >The CD, besides the <TT CLASS="FILENAME" >/doc</TT > and <TT CLASS="FILENAME" >/int_lnx</TT > directories that are common with the SDK, contains <TT CLASS="FILENAME" >install.sh</TT >, the general <SPAN CLASS="APPLICATION" >Ingres</SPAN > installer and its files. More on <TT CLASS="FILENAME" >install.sh</TT > later, in subsection <A HREF="install.html#START" >Starting the Installation Program</A >.</P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="TNG" >2.5. The Unicenter TNG Framework</A ></H2 ><P >At last, let me note that the Linux version of <SPAN CLASS="ACRONYM" >CA</SPAN >'s <SPAN CLASS="APPLICATION" >Unicenter TNG Framework</SPAN > also includes <SPAN CLASS="APPLICATION" >Ingres</SPAN > as its embedded database management system. For this reason, knowing <SPAN CLASS="APPLICATION" >Ingres</SPAN > may come in handy when using <SPAN CLASS="APPLICATION" >Unicenter</SPAN >, too. You can order a free <SPAN CLASS="APPLICATION" >Unicenter TNG Framework</SPAN > CD on </P ><P ></P ><UL ><LI ><P ><A HREF="http://www.cai.com/registration/tng_framework_linux/index.htm" TARGET="_top" > http://www.cai.com/registration/tng_framework_linux/index.htm</A > for RedHat, or</P ></LI ><LI ><P ><A HREF="http://www.cai.com/registration/tng_framework_linux/suse_linux.htm" TARGET="_top" > http://www.cai.com/registration/tng_framework_linux/suse_linux.htm</A > for SuSE.</P ></LI ></UL ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="intro.html" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="sysreq.html" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Introduction</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >System Requirements</TD ></TR ></TABLE ></DIV ></BODY ></HTML >