IBM GC23-7753-05 manual Demonstration Database Server, The IDS Configuration File, dbload Utility

dbload Utility

For loading data into databases or tables that IBM Informix products created. Use the dbload utility to transfer data from one or more text files into one or more existing tables.

High-Performance Loader (HPL)

For loading or unloading large quantities of data efficiently to or from a database. Use HPL to exchange data with tapes, data files, and programs, and convert data from these sources into a format compatible with IBM Informix databases. Also use HPL to manipulate and filter the data as you perform load and unload operations.

Enterprise Replication

For replicating data between IDS database servers

Administrative Utilities

Additional administrative utility feature sets

Miscellaneous Monitoring Utilities

For displaying the logical log by using the onlog utility or managing the database server with SNMP by using the onsnmp utility.

Auditing Utilities

For administering audit masks, trails, and other auditing information on the database server by using the onaudit and onshowaudit utilities.

Database Import and Export Utilities

For unloading a database into text files, creating and populating a database from those text files, or unloading a database schema into a text file

Demonstration Database Server

The installation application can create and configure a ready-to-use database server, which you can use as a production or testing instance.

The IDS Configuration File

To access the installed database server, a configuration file must exist in INFORMIXDIR and must contain valid settings for your system. Setting up a demonstration database server during installation establishes a basic, valid configuration file, which can help users who are new to IBM Informix Dynamic Server. The installation setup you choose determines how the demonstration database server can be configured:

vTypical Installation: Setup of the demonstration database server is automatic and requires no user input during installation. The installation application scans your system and records necessary information to the configuration file shipped with the installation media. The database server will be initialized after installation is complete.

vCustom Installation: Custom installation lets you decide whether to configure a database server or not, and if you do, gives you more options about the settings. There are two ways in which you can utilize the default configuration file during installation:

1-6IBM Informix Dynamic Server Installation Guide for Windows