Using the Demonstration Database Server

If you chose to have the installation program configure a demonstration database server, the installer automatically configures and initializes a sample Dynamic Server named demo_on and sets the ONCONFIG environment variable to a sample onconfig file, $INFORMIXDIR/etc/onconfig.demo.

3As of IBM Informix Dynamic Server, Version 10.00.xC3, 3you can name the demonstration database. The onconfig file 3will be located in $INFORMIXDIR/etc/onconfig.demo_db_name.

When the installation program initializes the demonstration database server, three databases, sysmaster, sysuser, and sysutils, are built automatically. However, it takes several minutes to build these databases, and the system is not completely initialized until messages like the following appear in the message log ($INFORMIXDIR/demo/server/online.log):

09:28:59  'sysmaster' database built successfully.
09:29:00  'sysutils' database built successfully.
09:29:00  'sysuser' database built successfully.

After the server is installed, you can manually configure the demo database to use this server.

1. Set the INFORMIXDIR environment variable.

   For information on setting the INFORMIXDIR environment variable, see Configuring the Database Server.

2. Set the PATH environment variable.

   For information on setting the PATH environment variable, see Configuring the Database Server.

3. Set ONCONFIG to onconfig.demo_on.
4. Set INFORMIXSERVER to demo_on.

INFORMIXSQLHOSTS will default correctly to INFORMIXDIR/etc/sqlhosts; if you change the name or location of this file for your use, then you will have to set INFORMIXSQLHOSTS to reflect the new name and path.

The installation creates additional configuration and log files to support the demo_on database server in $INFORMIXDIR/demo/server. For information on the configuration settings for demo_on, see the $INFORMIXDIR/demo/server/profile_settings file.