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.
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.
Manage message logs in an embedded environment
You can enable the database server to automatically rotate and delete online message log files, and you can specify the maximum number of online, ON-Bar activity, or ON-Bar debug message log files to rotate. The Scheduler tasks that rotate and delete these message log files are useful for embedded applications, because they reduce DBA or system administrator requirements for managing the logs.
Reducing the size of message log files
You can reduce the size of online, ON-Bar activity, or ON-Bar debug message log files by running SQL administration API commands that rotate, truncate, or delete the logs.

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.
  - 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.
    - Optimize storage
      You can optimize storage by compressing data, configuring the server to add more storage space automatically, and defragmenting partitions. Compressing data reduces the amount of disk space needed for your applications.
    - Manage message logs in an embedded environment
      You can enable the database server to automatically rotate and delete online message log files, and you can specify the maximum number of online, ON-Bar activity, or ON-Bar debug message log files to rotate. The Scheduler tasks that rotate and delete these message log files are useful for embedded applications, because they reduce DBA or system administrator requirements for managing the logs.
      - Enabling and disabling the tasks that automatically rotate message log files
        Before the database server can run the built-in Scheduler tasks that automatically rotate message log files, you must enable each task that rotates a message log file. You only need to enable each task once. You can also disable an enabled task.
      - Tasks that automatically rotate message log files
        A Scheduler task automatically rotates each of the common message log files (online.log, bar_act_log, and bar_debug_log). When the server rotates a log file, the server switches to a new log file and increments the ID numbers for the previous log files by one. When the maximum number of log files is reached, the log file with the highest ID is deleted.
      - Configuring the frequency of automatic rotation of message log files
        You can configure the frequency of the built-in Scheduler tasks that automatically rotate online message log files.
      - Configuring the maximum number of message log files to retain
        You can change the maximum number of online, ON-Bar activity, or ON-Bar debug message log files that the database server retains. This information is stored in the MAX_MSGPATH_VERSIONS, MAX_BAR_ACT_LOG_VERSIONS, and MAX_BAR_DEBUG_LOG_VERSIONS parameters of the ph_threshold table.
      - Reducing the size of message log files
        You can reduce the size of online, ON-Bar activity, or ON-Bar debug message log files by running SQL administration API commands that rotate, truncate, or delete the logs.
    - Reserve memory for critical activities in embedded environments
      You can reserve a specific amount of memory for use when critical activities (such as rollback activities) are needed and the database server has limited free memory. When you reserve memory, critical activities, such as rollback activities, can complete even when you receive out-of-memory errors.
    - Maintain a targeted amount of memory in embedded applications
      You can configure the database server to continue processing when memory is critically low, instead of returning an out of memory error.

Reducing the size of message log files

You can reduce the size of online, ON-Bar activity, or ON-Bar debug message log files by running SQL administration API commands that rotate, truncate, or delete the logs.

About this task

To manually rotate a message log file:

Run the admin() or task() function with the message log rotate argument, the name of the message log, and the maximum message log version that the server will rotate, as follows:
```
EXECUTE FUNCTION task("message log rotate",
 "full_path_for_message_log_file",maximum_version);
```
For example, to rotate a maximum of 52 online.logfiles, specify:
```
execute function task("message log rotate",
 "/usr/informix/online.log",52);
```

To manually truncate a message log file (remove the contents of the file):

Run the admin() or task() function with the message log truncate argument and the full path name for the message log file, as follows:
```
EXECUTE FUNCTION task("message log truncate",
 "full_path_for_message_log_file");
```
For example, to remove the contents of the online.log file, specify:
```
EXECUTE FUNCTION task("message log truncate",
 "/usr/informix/online.log");
```

To manually delete a message log file (remove the contents of the file and the file):

Run the admin() or task() function with the message log delete argument and the full path name for the message log file, as follows:
```
EXECUTE FUNCTION task("message log delete",
 "path_for_message_log_file");
```
For example, to delete the entire online.logfile, specify:
```
EXECUTE FUNCTION task("message log delete",
 "/usr/informix/online.log");
```