Ingres II HOWTO

Pal Domokos

pal.domokos@usa.net

V1.1, 20 June, 2000

Revision History
Revision V1.1	20 June, 2000	Revised by: pd
Extended with material on the full version of Ingres II 2.0
Revision V1.01	23 December, 1999	Revised by: pd
Minor fixes
Revision V1.0	7 November, 1999	Revised by: pd
Original version

This document helps install the Ingres II Relational Database Management System on Linux. It covers the setup of both the free Software Development Kit and the full version of Ingres. Further sections try to make it easier to start working with Ingres.

Table of Contents

1. Introduction

1.1. Copyright
1.2. Disclaimer
1.3. New Versions of the HOWTO
1.4. Credits
1.5. Audience

2. Ingres

2.1. University Ingres and Commercial Ingres
2.2. The Software Development Kit
2.3. The Beta Version
2.4. The Ingres II Full Edition
2.5. The Unicenter TNG Framework

3. System Requirements

3.1. Hardware
3.2. Software
3.3. Kernel Parameters
3.4. The ingres User and II_SYSTEM

4. Preparing for the Installation

4.1. Ingres Environment Variables
4.2. II_LOG_FILE and II_DUAL_LOG
4.3. Database Locations
4.4. The iidbdb Database
4.5. II_DATABASE
4.6. II_CHECKPOINT
4.7. II_DUMP
4.8. II_JOURNAL
4.9. II_WORK
4.10. Other Ingres Environment Variables

5. The Installation Process

5.1. Starting the Installation Program
5.2. Express Install
5.3. Manual Install
5.4. Completing the Initial Configuration
5.5. Re-installation
5.6. Command Line Install (SDK)
5.7. Client Installation (Full Version)
5.8. The Installer's Log
5.9. Checking the Installation

6. Basic System and Database Administration

6.1. Starting and Stopping Ingres
6.2. New Ingres Users and Locations
6.3. Creating and Destroying Databases
6.4. Collation Sequences
6.5. Backup and Recovery
6.6. Configuring Ingres
6.7. Monitoring Ingres
6.8. Message Files

7. Ingres/Net

7.1. User Authentication
7.2. Login Account Passwords
7.3. Installation Passwords
7.4. ingvalidpw
7.5. Setting up the Client
7.6. Setting up the Server
7.7. Using Net

8. ICE (Internet Commerce Enabled)

8.1. Configuring Apache
8.2. ICE Setup

9. Miscellaneous Topics

9.1. Automatic Startup and Shutdown
9.2. ingmenu
9.3. Circumventing Ingres Net
9.4. Forms-Based Development Tools
9.5. Ingperl and Perl DBI
9.6. Ingres links

1. Introduction

1.1. Copyright

Please freely copy and distribute (sell or give away) this document in any format. It is requested that corrections and/or comments be forwarded to the document maintainer. You may create a derivative work and distribute it provided that you:

Send your derivative work (in the most suitable format such as SGML) to the LDP (Linux Documentation Project) or the like for posting on the Internet. If not the LDP, then let the LDP know where it is available.
License the derivative work with this same license or use GPL. Include a copyright notice and at least a pointer to the license used.
Give due credit to previous authors and major contributors. If you are considering making a derived work other than a translation, it is requested that you discuss your plans with the current maintainer.

1.2. Disclaimer

To put it briefly: there is no warranty about the validity of any other statement in this document. Read and use at your own risk.

Furthermore, I am not an employee of Computer Associates International and I have no official links with CA. This HOWTO is not official documentation.

All copyrights are held by their respective owners. Use of a term in this document should not be regarded as affecting the validity of any trademark or service mark.

1.3. New Versions of the HOWTO

The latest version of this HOWTO can always be found on the Linux Documentation Project's site, in various formats:

The LDP has many mirrors around the world, as listed on http://www.linuxdoc.org/mirrors.html. Some of these mirrors may be out of date, though. Therefore I suggest you check LDP's primary site for new versions.

HOWTOs are also bundled with most Linux distributions. If you are reading this HOWTO from your Linux CD, also take a look at LDP's main site to check if a newer version exists.

1.4. Credits

I would like to thank for all the feedback I have received so far. I found especially valuable the contributions of Jorgen Heesche (on forms-based development tools), and Gerhard Hofmann (on the automatic startup and shutdown of Ingres).

Last, but not least, my thanks go to CA for making it possible for me to examine the Ingres II 2.0 Enterprise Edition for Linux.

Naturally, I continue to welcome any comments, criticisms and suggestions. Just email me at <pal.domokos@usa.net>.

1.5. Audience

This HOWTO aims to help install Ingres II on (Intel) Linux. As always, help is useful for those who need it and can utilize it as well.

Therefore:

If you are an Ingres pro familiar with Linux then you do not really need to read this HOWTO. Skim through it though if you have time.
If you have no previous background in relational database management (experience with at least one real RDBMS, not some dBase-like file management system), you do not know UNIX and have just started using Linux, this HOWTO will not make an easy reading for you. Even then, I do not want to persuade you not to try to install and use Ingres. Do not give up easy!

If you are not a novice in database management and have some working knowledge of Linux, this HOWTO is for you! We are not going to discuss the basics of relational database management or SQL in this document, neither are we going to elaborate on how to edit text files on Linux. You can find as much information on these topics as you want in numerous places. This HOWTO is not an Ingres guide, either: the Ingres manuals serve that purpose.

The objective of this HOWTO is that the reader can prepare for, then implement the installation of Ingres II on Linux, through simple and understandable steps. It also gives starting points for basic Ingres system and database administration.

I can only hope that the HOWTO reaches its goal.