IBM GC23-7753-05 - Manual

Introduction This introduction provides an overview of IBM ® Informix ® products and of this publication as well as the conventions that it uses. IBM Informix Dynamic Server Editions IBM Informix Dynamic Server is available in different editions to fit differentbusiness needs. Some of the functional...

Types of Users This publication is for database administrators (DBAs) who install IBM Informixproducts. This guide assumes that you are familiar with the operating proceduresof your computer and with your operating system. For information about youroperating system, see your Microsoft ® Windows docu...

Table 2. What’s New in Version 11.50.xC5 (continued) Overview Reference Upgrading to IDS v11.50.xC5 in Silent Mode (Windows) You can upgrade from IDS v11.50.xC4 or earlier to IDSv11.50.xC5 in silent mode. You will need to record aresponse file for IDS v11.50.xC5. You cannot use aresponse file that w...

Table 5. What’s New in Version 11.50.xC1 Overview Reference Enhanced Configuration Options During Installation You can use the new Instance Configuration Wizard toautomatically create the database server configuration file(ONCONFIG) during a custom installation in GUI mode. Provide the information f...

Technical Changes Technical changes to the text are indicated by special characters depending on theformat of the documentation. HTML documentation New or changed information is surrounded by blue @ and ! characters. PDF documentation A plus sign (+) is shown to the left of the current changes. A ve...

Additional Documentation Documentation about IBM Informix products is available in various formats. You can view, search, and print all of the product documentation from the IBMInformix Dynamic Server information center on the Web at http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp. F...

Table 6. Syntax Diagram Components (continued) Component represented in PDF Component represented in HTML Meaning --+-----------------+--- '------LOCAL------' Optional item. ---+-----ALL-------+--- +--DISTINCT-----+'---UNIQUE------' Required item with choice.One and only one item mustbe present. ---...

(1) Setting the Run Mode -S server -T target Notes: 1 See page Z-1 This diagram has a segment named “Setting the Run Mode,” which according tothe diagram footnote is on page Z-1. If this was an actual cross-reference, youwould find this segment in on the first page of Appendix Z. Instead, this segme...

When a keyword appears in a syntax diagram, it is shown in uppercase letters.When you use a keyword in a command, you can write it in uppercase orlowercase letters, but you must spell the keyword exactly as it appears in thesyntax diagram. You must also use any punctuation in your statements and com...

xiv IBM Informix Dynamic Server Installation Guide for Windows

Chapter 1. Preparing to Install IDS on Windows Read the following information and complete the tasks appropriate for yourinstallation environment. v “Online Notes” v “Verifying System Requirements” v “Verifying Administrators Group Membership” v “Multiple Copies of IDS on One Computer” on page 1-2 v...

For information on how to create groups and add users to groups, see yourWindows documentation. Multiple Copies of IDS on One Computer Multiple copies of IBM Informix Dynamic Server can run on the same computer.The copies can be the same or different versions of the product. Multiple copies of diffe...

Related tasks “Installing a Copy of IDS on a Computer” on page 2-1 Choosing Your Installation Setup Using the installation application, you can choose a typical or custom setup forloading IBM Informix Dynamic Server and other products to your system. Typicalsetup installs the full IDS product, while...

instance to function with the DRDA protocol after installation by using the instmgr.exe utility (see “Server Instance Manager Command-Line Options” on page 2-14). v Installing database server to run as local system user: To install IDS as a local system account on Windows, you must select a custom i...

dbload Utility For loading data into databases or tables that IBM Informixproducts created. Use the dbload utility to transfer data from oneor more text files into one or more existing tables. High-Performance Loader (HPL) For loading or unloading large quantities of data efficiently to orfrom a dat...

Basic demonstration database server: Select the Initialize Server checkbox in the installation application and ensure that the settings for the server name,service name, port, and server number are accurate. Instance Configuration Wizard: A more customized database server can be created with the Ins...

Instance Configuration Wizard The Instance Configuration Wizard is an installation option that automaticallycreates a database server configuration file customized to your systemenvironment. You can use the Instance Configuration Wizard on a Windows computer when youinstall using a custom setup in G...

Role separation provides increased database security because the database serversplits administrative tasks into mutually exclusive roles. If you do not enable roleseparation, the Informix-Admin group performs all administrative tasks. For detailed information about the role separation feature, see ...

Local Installation If you do not plan to have workstations access a domain controller, install thedatabase server on a local computer. For a local installation, you should haveadministrative privileges. Domain Installation with Domain Administrator Privileges Domain installation is useful if you run...

Chapter 2. Installing IDS on Windows The following topics explain your IBM Informix Dynamic Server and IBM Informixproducts installation choices. Troubleshooting information is also included. v “Installing IBM Informix Products” v “Installing a Copy of IDS on a Computer” v “Installing with the GUI T...

2. Select Install Products from the Launchpad and click Next . 3. Select to install IBM Informix Dynamic Server and click Next . 4. Select the option to install a new instance when the installation application listsexisting IDS instances and click Next . 5. Select the option to install in a differen...

Completing the installation program loads a configured database server with atypical setup. For information on changing the configuration or configuring adatabase server manually, see “Database Server Configuration After Installation”on page 3-4 and “Configuring IDS Manually” on page 3-6. The instal...

window that appears directly afterwards. (See “Instance ConfigurationWizard” on page 1-8 for more information about this option.) c. Optional: Select the Enable DRDA Support checkbox if you want the instance to have a server alias and port for Distributed Relational DatabaseArchitecture (DRDA) conne...

1. Start the installation application by running the following command: setup.exe -r -f1" path\response_filename .ini" path\response_filename is the full path and file name of your response file The f1 argument is optional. If you do not specify the location and name of the response file wit...

Specifying an Installation to Modify If the Dynamic Server version that you want to install matches the version on thetarget computer, the information recorded in your response file determineswhether the silent installation adds a new copy of the database server or modifiesthe existing installation....

Setting Up Cluster Installations Complete the following tasks to cluster two computers. v “Cluster Installations” v “Overview of Implementing a Cluster on Two Nodes” v “Setting Up a Cluster Installation” on page 2-10 v “Preparing to Set Up a Cluster” on page 2-10 v “Implementing a Cluster on the Pri...

3. Click Convert to Cluster . After the ClusterIT utility completes, IDS starts on the secondary node. After implementing a cluster environment on multiple nodes, you can find arecord of the ClusterIT utility activities in the clusterIT.log files, one for clusterIT_a in the primary node directory, a...

While the database server engine is upgraded by this task, the preceding steps donot change your databases. To start the IDS instance, you must initialize the server manually. Multiple Residency You can set up multiple independent database server environments on the samecomputer Complete the followi...

2. Select the Installation Method, and click Create New to create a new instance of the database server. 3. Follow the prompts. After you enter the required information, the Server Instance Manager installsservices, records environment variables, updates the registry, and creates an onconfig file fo...

Table 2-2. instmgr.exe Utility Options (continued) Option Meaning -system Create database server instance that runs as local system userinstead of user informix. (IDS must be installed as local systemuser to use this option.) Troubleshooting Installation Problems This section describes some common i...

Chapter 3. Post-Installation Tasks on Windows Review the following information after installing IBM Informix Dynamic Server. v “Working with the Installation” v “IDS Program Group” on page 3-2 v “Initializing and Starting the Database Server” on page 3-3 v “Database Server Configuration After Instal...

( Custom installations : If you enabled role separation when you installed the database server, you could have changed the name of the Informix-Admin group.) v Automatically assigned the informix user account, under which the database server runs, to the Informix-Admin group and to the Windows Admin...

Table 3-1. IBM Informix Dynamic Server Program Group (continued) Menu Item Description Server Instance Manager Creates and configures new server instances andremoves configured server instances. server-name Opens a Command Prompt window for an initializeddatabase server instance. You can use that wi...

v To initialize and then start the database server, run the command with the -iy option. starts server_name -iy Warning: If you run the -iy switch on a database server that has IDS databases, the data is deleted. Stopping the Database Server To stop the database server from the Control Panel, you mu...

The database server uses configuration parameters, set in the onconfig file, during initialization. For more information about configuration parameters and theonconfig file, see the “Configuration Parameters” chapter of the IBM Informix Dynamic Server Administrator’s Reference . To determine how man...

Default Sbspace Name, Location, Size, and Page Size An sbspace is a logical storage area that the database server uses to store smartlarge objects (CLOB and BLOB data). The default sbspace is the location in which the database server stores a smartlarge object if you do not specify an sbspace name w...

c. Specify the name of the default sbspace. d. Specify the primary and mirror storage location and disk-space size for thedefault sbspace. 3. Specify the computer to use for shared server definition for your databaseserver and administrative tools.The installation program installs services on the co...

Chapter 4. Modifying IDS on Windows The uninstallation application facilitates uninstallation and reinstallation of IBMInformix Dynamic Server, as well as modification of installed features of a databaseserver instance. Review the following information to uninstall or modify IDS v “Altering IDS Feat...

-instnum Specifies the installation number of the copy that requires maintenance. Forexample: setup.exe -instnum installation number -s -f1" X:path\response file " Where: v installation path is the full or relative path to the location of the IDS installation that you want to alter. v instal...

The command records the uninstallation options as you perform them andstores them in a response file. If you do not specify the location of the responsefile, by default the uninstallation sequence is saved in %WINDIR%\setup.iss. 2. To perform the silent uninstallation on another system, or to uninst...

Chapter 5. Deploying IDS with the Deployment Utility Use the command-line deployment utility to deploy a snapshot of IBM InformixDynamic Server and create a new instance as a quick alternative to traditionalinstallation, especially for deployments to many computers. You can configure the snapshot so...

and a single path for all application files including the database server filesduring deployment to avoid waiting for data loading and database serverinitialization. Most deployment utility functionality can be invoked by using eithercommand-line options or setting options in a text-based template c...

v Each chunk file has an ownership and permissions setting that allows you tomodify it. v You know the ROOTPATH (and MIRRORPATH, if applicable) for the deployedinstance, and provide the path information in a configuration parameter settingor by using the -rootpath option. Database Server Configurati...

On Windows, the INFORMIXSQLHOSTS environment variable is used only if you want to capture the connectivity settings stored in the registry of anothercomputer. If the ONCONFIG environment variable is not set, the utility creates one from a combination of whatever parameter settings you provide in the...

v If you are deploying data, the root dbspace is in the same absolute path on thetarget computer as on the template computer. v The target computer has sufficient disk space for the snapshot. Tip: You need the same amount of space as was used on the template computer. The space required depends on w...

-rootpath ″ path ″ (3) -relocate path ; old_path = new_path ; old_path , old_offset = new_path , new_offset (4) -6432 (5) -installdrive ″ drive ″ -verbose -force -l ″ log_file ″ -y Uninstallation Parameters: -uninstall ″ installation_path ″ -delifx (6) -6432 -silent -y -verbose -l ″ log_file ″ -verb...

Table 5-1. ifxdeploy Command Options (continued) Element Purpose Key Considerations -silent Directs the utility to run insilent mode. When you use this option,messages do not display onthe screen but are written ina log file. If you use the -silent option and -verbose option together, you mustalso i...

Examples of Deployment Utility Usage on Windows Deploying a IDS Instance in Silent Mode In this example, the user informix is created on the target server and has the password mypassw0rd . The command will run in silent mode, without prompting for confirmation. The snapshot is decompressed from the ...

ifxdeploy.conf File: The Deployment Utility Configuration File The ifxdeploy.conf file is a text-file template in which you can configure an instance snapshot prior to deploying it with the ifxdeploy command. Purpose The ifxdeploy.conf file is in $INFORMIXDIR/etc/ on Linux and %INFORMIXDIR%\etc on W...

ifxdeploy.conf File Template The following shows the contents of the ifxdeploy.conf file. # Licensed Material - Property Of IBM ## "Restricted Materials of IBM" ## IBM Informix Dynamic Server # Copyright IBM Corporation 2009 All rights reserved. ## Title: ifxdeploy.conf # Description: Config...

#ROOTPATH # WIN6432 - Windows only - Set this to 1 if installing a 32-bit version of IDS# on a 64-bit Windows operating system. # - Range: 0,1 #WIN6432 0 # Onconfig customization# Use the BEGIN ONCONFIG and END ONCONFIG statements to add or override# configuration parameters values in the onconfig f...

Appendix. Accessibility IBM strives to provide products with usable access for everyone, regardless of ageor ability. Accessibility features for IBM Informix Dynamic Server Accessibility features help a user who has a physical disability, such as restrictedmobility or limited vision, to use informat...

Notices This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document inother countries. Consult your local IBM representative for information on theproducts and services currently available in your are...

modify, and distribute these sample programs in any form without payment toIBM, for the purposes of developing, using, marketing or distributing applicationprograms conforming to the application programming interface for the operatingplatform for which the sample programs are written. These examples...