Preparing for Automatic Startup

Prepare the operating-system registry or scripts to automatically start and stop the database server.

Preparing for Automatic Startup on Windows

Change the Informix password in the Service control application when you change the Informix password on Windows.

To start the database server automatically when Windows starts

From the Service control application window, select the Dynamic Server service and click the Startup button.
Select Automatic in the Status Type dialog box.
In the Log On As dialog box, select This Account and verify that informix is in the text box.

Preparing the UNIX Startup and Shutdown Scripts

You can modify the UNIX startup script to initialize the database server automatically when your computer enters multiuser mode. You can also modify your UNIX shutdown script to shut down the database server in a controlled manner whenever UNIX shuts down.

To prepare the UNIX startup script, add UNIX and database server utility commands to the UNIX startup script so that the script performs the following steps.

ISA provides a sample UNIX script for startup and shutdown that you can customize in $INFORMIXDIR/etc/ids-example.rc.

To prepare the UNIX startup script

Set the INFORMIXDIR environment variable to the full pathname of the directory in which the database server is installed.
Set the PATH environment variable to include the $INFORMIXDIR/bin directory.
Set the ONCONFIG environment variable to the desired configuration file.
Set the INFORMIXSERVER environment variable so that the sysmaster database can be updated (or created, if needed).
Execute oninit, which starts the database server and leaves it in online mode.
If you plan to initialize multiple versions of the database server (multiple residency), you must reset ONCONFIG and INFORMIXSERVER and re-execute oninit for each instance of the database server.
If you are using IBM Informix Storage Manager (ISM) for managing database server backups, you must start the ISM server on each node.
For information about how to start the ISM server, see your IBM Informix Installation Guide.

If different versions of the database server are installed in different directories, you must reset INFORMIXDIR and repeat the preceding steps for each different version.

To shut down the database server in a controlled manner whenever UNIX shuts down, add UNIX and database server utility commands to the UNIX shutdown script so that the script performs the following steps.

To prepare the UNIX shutdown scrip

Set the INFORMIXDIR environment variable to the full pathname of the directory in which the database server is installed.
Set the PATH environment variable to include the $INFORMIXDIR/bin directory.
Set the ONCONFIG environment variable to the desired configuration file.
Execute onmode -ky, which initiates an immediate shutdown and takes the database server offline.
If you are running multiple versions of the database server (multiple residency), you must reset ONCONFIG and re-execute onmode -ky for each instance.

If different versions of the database server are installed in different directories, you must reset INFORMIXDIR and repeat the preceding steps for each version.

In the UNIX shutdown script, the database server shutdown commands should execute after all client applications have completed their transactions and exited.