Execute the oninit utility from the command line to initialize database server shared memory and bring the database server online. If you use the oninit -i option, you can also initialize disk space.
To initialize the database server in single-user mode, use the oninit -j option. This is an administrator-only mode you can use to perform maintenance operations including those that require executing SQL or DDL commands. You can use the -j flag with other oninit flags, except the -s flag. When in single-user mode, the system will only accept connection requests from the informix user. The server makes an entry in the online log whenever it enters or exits single-user mode.
On UNIX, you must be logged in as user root or informix to execute oninit. User informix should be the only member of the group informix. On Windows, you must be a member of the Informix-Admin group.
Before you initialize the database server, set the INFORMIXSERVER environment variable to the dbservername that you chose when you set the configuration parameter DBSERVERNAME. INFORMIXSERVER is not required for initialization. However, if INFORMIXSERVER is not set, the database server does not build the sysmaster tables. Also, the DB–Access utility requires INFORMIXSERVER to be set.
For information about what happens during initialization, see the chapter on initializing the database server in the IBM Informix Administrator's Guide.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]