Automatic Startup Command
You can have Ingres start up and shut down automatically. To add an automatic startup command, you must know the startup mechanism your environment uses. See the administration manual for your UNIX environment, or ask your system administrator to assist.
Typically, UNIX startup scripts are organized either in directories by run-level, or in startups scripts in /etc.
Note: For additions or variations necessary for your platform, see the Readme file.
If your environment uses the “directory-by-run-level” method, we recommend that you sequence your Ingres script so that it starts late in the startup sequence, and shuts down early in the shutdown sequence.
If your environment uses one or a few startup scripts, edit the rc.local script. Look for a shell function called localrc, or simply add the Ingres startup near the end.
When writing the Ingres startup script, make sure that you set all necessary shell environment variables, and run the ingstart command as instance owner. At a minimum, you must set II_SYSTEM and PATH. In most UNIX environments, you must also set the shared library path (LD_LIBRARY_PATH, LD_LIBRARY_PATH_64, LIBPATH, SHLIB_PATH, or SH_LIB_PATH).
For example:
II_SYSTEM=/inghome; export II_SYSTEM
PATH=$PATH:$II_SYSTEM/ingres/bin:$II_SYSTEM/ingres/utility; export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$II_SYSTEM/ingres/lib
export LD_LIBRARY_PATH
su ingres -c "ingstart"
If shared libraries are not supported on your operating system, there is no need to set the shared library path variable.
Depending on your UNIX environment, you may want to redirect the output of the ingstart command to a file or to /dev/console.
You must add the appropriate commands to the system startup file on each machine running a DBMS Server or client.