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

Page 22

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

Image 22
Contents IBM Informix Dynamic Server Installation Guide for Windows Page IBM Informix Dynamic Server Installation Guide for Windows Copyright International Business Machines Corporation 1996 Contents Index IBM Informix Dynamic Server Editions IntroductionAbout This Publication Types of Users Overview ReferenceWhat’s New in Version 11.50.xC4 Documentation Conventions Example Code Conventions Feature, Product, and Platform MarkupTechnical Changes Html documentationCompliance with Industry Standards Syntax DiagramsAdditional Documentation Component represented in Html MeaningHow to Read a Command-Line Syntax Diagram Distinct UniqueSetting the Run Mode Keywords and PunctuationHow to Provide Documentation Feedback Identifiers and NamesPage Verifying Administrators Group Membership Preparing to Install IDS on WindowsOnline Notes Verifying System Requirements Multiple copies of the same version Multiple Copies of IDS on One ComputerMultiple copies of different versions Programs menuInstallation Application Setup Types Choosing Your Installation SetupRelated tasks Features Installable Features of IDSBase Server XML Publishing Backup and RestoreConversion and Reversion Support Global Language SupportIDS Configuration File Demonstration Database ServerDemonstration Database Server on Your System Instance Configuration Wizard Planning Role SeparationIxdbsso Installation DirectoryChoosing between Local and Domain Installations IxaaoUser informix Local InstallationDomain Installation with Domain Administrator Privileges Upgrading the Database ServerInstalling IBM Informix Products Installing IDS on WindowsInstalling a Copy of IDS on a Computer Related concepts Installing with the GUI Typical SetupRelated reference Installing with the GUI Custom Setup GUI feature tree Performing a Silent Installation Using a Response File for Silent Installation Using a Customized server.ini File for Silent InstallationTo perform a silent installation by using a response file Silent Installation on a Host with Multiple Installations %WINDIR%\setup.issSilent Installation Response Codes Code DescriptionCluster Installations Setting Up Cluster InstallationsOverview of Implementing a Cluster on Two Nodes Preparing to Set Up a Cluster Setting Up a Cluster InstallationTo set up a cluster on the primary node Implementing a Cluster on the Primary Node Installing IDS as a Cluster on the Secondary NodeIDS as a Cluster on the Secondary Node Upgrade of IDS by Overwriting an Existing Installation Overwriting an Existing IDS InstallationPlanning for Multiple Residency Multiple ResidencyCreating a New Database Server Instance Server Instance Manager Command-Line Options PurposeTroubleshooting Installation Problems Option System Meaning16IBM Informix Dynamic Server Installation Guide for Windows Working with the Installation Post-Installation Tasks on WindowsInstallation Automatic Actions IDS Program Group Initializing and Starting the Database Server Server-nameStopping the Database Server Database Server Configuration After InstallationChoose Start Control Panel Administrative Tools Database Server NumberDatabase Server Name Service Name and Port NumberDbspace Name, Location, and Size To configure the installed database server Default Sbspace Name, Location, Size, and Page SizeConfiguring IDS Manually Shared Server Definition ComputerPost-Installation Tasks Windows 8IBM Informix Dynamic Server Installation Guide for Windows Modifying IDS on Windows Altering IDS FeaturesAltering Copies of IDS Performing Silent Uninstallations of IDS Uninstalling IDSReinstalling the Database Server InstnumCommand 4IBM Informix Dynamic Server Installation Guide for Windows Deploying IDS with the Deployment Utility Deployment Utility+ Rapid IDS Embeddability with the Deployment Utility Initialized dbspacesDatabase Server Configuration Environment VariablesDeploying a Snapshot with the Deployment Utility Creating a Snapshot for DeploymentDatabase Server Aliases Syntax Ifxdeploy Command The Deployment UtilityIfxdeploy.conf file Element Purpose Key Considerations Command OptionsInformix-Admin group DelifxForce Usage Examples of Deployment Utility Usage on Windows Ifxdeploy.conf file is in $INFORMIXDIR/etc/ on Linux Example of Value SettingParameters INFORMIXDIR%\etc on WindowsNo Onconfig Onconfig.stdIfxdeploy.conf file for InformixServername\rootdbsdat.000 Following shows the contents of the ifxdeploy.conf file + ifxdeploy.conf File Template#SYSTEM Informix and the administrative group + Removing a Snapshot with the Deployment Utility16IBM Informix Dynamic Server Installation Guide for Windows Appendix. Accessibility 2IBM Informix Dynamic Server Installation Guide for Windows Host Host 4IBM Informix Dynamic Server Installation Guide for Windows Copyright IBM Corp Copyright License Trademarks 4IBM Informix Dynamic Server Installation Guide for Windows Index Special characters Dbservername Mirrorpath Sbspacename ServernumINFORMIXDIR% Dbservername TCP/IP Page GC23-7753-05