Using INGRES on the Sun Workstations

Before using INGRES you should verify path settings and environment variable assignments.

-- In your .login file, ensure the following environment variable assignments exist:

setenv TERM_INGRES sun-cmdf
setenv II_SYSTEM /usr/local

-- In your .cshrc (or .sol1) file, ensure the following path settings and the environment variable assignment exist:

set path = ( ... /usr/local/ingres/bin /usr/local/ingres/utility /usr/local/ingres/X11R4 ... )
setenv LD_LIBRARY_PATH $OPENWINHOME/lib:/usr/local/ingres/X11R4/lib

Before using INGRES for the first time you need to run the INGRES/NET MANAGEMENT UTILITY in order to set up remote authorization for your own individual (private) database.

-- Start the INGRES/NET MANAGEMENT UTILITY by entering the following from the UNIX command line:

netu

-- Once inside NETU, follow these instructions to set up remote authorization:

1. Select A (Modify Remote Authorization Entry) from the menu.
2. From Modify Remote Authorization Entry, enter add as the desired option.
3. Enter P for Private access to your database.
4. Enter sundown for the remote v_node name.
5. Enter your login name for the remote User Name.
6. Enter your login password (or some other password of your chosing) for the remote Password.
7. Re-enter your password (this is just to check for typos).
8. Enter exit to exit Modify Remote Authorization Entry.
9. Select E (Exit) to quit NETU.

After you've set up remote authorization you should be able to run INGRES from the UNIX command line by using ingres dbfile, sql dbfile, or quel dbfile, depending on the query language you wish to use. [Note: dbfile is the name of the database file you wish to run INGRES on.]

Please note that the INGRES system requires each user to be listed in a special access file before granting access to the system.

NOTE: The system administrator should already have entered all students in the CS 3522 Database Theory class into the INGRES access file. Additionally, the INGRES server is located on sundown and is currently only available remotely from certain workstations. This inconvenience may be resolved soon, but if you are unable to gain access to INGRES on one workstation, try another. I was able to get access to INGRES from bluejay as of 3/1/95.