Home
Embedding Informix®
When you embed HCL Informix®, you can use enterprise-class high-availability and high performance with embeddability features such as easy programmability, a small disk and memory footprint, and silent deployment.
Embedding HCL Informix®
The Informix® Embeddability Guide describes how to embed HCL Informix in your applications.
Deploying Informix® software
The product supports embeddability tools that enable lightweight, faster deployment of the database server and related client programs.
The syncsqlhosts utility
Use the syncsqlhosts utility to manually convert the connection information between the sqlhosts file format and the Windows™ registry format.

Embedding Informix®
When you embed HCL Informix®, you can use enterprise-class high-availability and high performance with embeddability features such as easy programmability, a small disk and memory footprint, and silent deployment.
- Embedding HCL Informix®
  The Informix® Embeddability Guide describes how to embed HCL Informix in your applications.
  - Overview of embedding Informix® products
    You can embed Informix® products in your applications by taking advantage of customizable deployment options and configurable administration features. You can use the embeddability features in combination with other product features for installation footprint reduction and high-availability clustering to achieve a quicker and easier end-to-end deployment solution.
  - Deploying Informix® software
    The product supports embeddability tools that enable lightweight, faster deployment of the database server and related client programs.
    - The deployment utility
      The Informix® deployment utility can deploy snapshots of pre-configured HCL Informix instances (with or without data) on one or more computers.
    - The syncsqlhosts utility
      Use the syncsqlhosts utility to manually convert the connection information between the sqlhosts file format and the Windows™ registry format.
    - Removing a snapshot with the deployment utility
      Use the deployment utility to remove a snapshot that was originally deployed by the deployment utility. In addition, you can use this utility to remove the user who owns the installation from the operating system.
    - Deploying Informix® and client products with RPM-based installation (Linux™)
      You can create RedHat Package Manager (RPM) images of a customized HCL Informix® product installation to deploy the products with a silent installation. You can use RPM images to deploy the database server and client products in embedded applications. After you install the database server with an RPM image, you must manually initialize the database server.
  - Informix® embeddability deployment tutorial
    The purpose of this tutorial is to provide steps and scripts needed for silent end-to-end deployment of HCL Informix® on Linux™ and Windows™ using the deployment assistant and the deployment utility.
  - Manage memory in embedded environments
    You can manage memory in embedded environments by enabling the database server to automatically rotate and delete online message log files, configuring the actions that the server takes to continue processing when memory is critically low, and enabling the server to reserve a specific amount of memory for use when critical rollback activities are needed and the server has limited free memory.

The syncsqlhosts utility

Use the syncsqlhosts utility to manually convert the connection information between the sqlhosts file format and the Windows™ registry format.

Syntax

Command options

Table 1. Options for the syncsqlhosts command
Option	Purpose	Key considerations
`-source sqlhostvalue`	Specifies the source machine to copy connection information from. `sqlhostvalue` is either a \\machine name or an sqlhosts file.	If you do not specify a -source option, the local registry is used.
`-target sqlhostvalue`	Specifies the target machine to copy connection information to. `sqlhostvalue` is either a \\machine name or an sqlhosts file.	If you do not specify a -target option, the local registry is used.
`-servers serverlist`	Specifies the servers to copy connection information from. `serverlist` is a list of Informix® Server entries that are separated by spaces that are copied from the source to the target machine.	If you do not specify a -servers option, all of the defined connections are copied.

Usage

The following prerequisites must be met to run this command:

The user must have the appropriate authorization to read or write files on the source and target system and registry.
If the specified value for a parameter contains a space, you must enclose that value in double quotation marks (").

Examples of syncsqlhosts utility usage

In the following examples, you are issuing commands from a machine named machine1.

To copy the connection information from the registry on machine2 to the registry on machine1:
```
syncsqlhosts -source \\machine2
```
To copy the connection information from the registry on machine1 to the registry on machine3:
```
syncsqlhosts -source \\machine1 -target \\machine3
```
To copy connection information from the registry on machine2 about servers ol_server1 and ol_server1test to the registry on machine1:
```
syncsqlhosts -source \\machine2 -servers ol_server1 ol_server1test 
```
To copy connection information from the registry on machine2 about servers ol_server1 and ol_server1test to a file on machine1:
```
syncsqlhosts -source \\machine2 -target c:\informix\etc\sqlhosts.ol_machine2
 -servers ol_machine1 ol_machine1test 
```