590 lines
9.9 KiB
HTML
590 lines
9.9 KiB
HTML
<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
|
|
> |