[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" link_color="" link_hover_color="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left="" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" admin_label="Abstract" type="legacy"][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" hover_type="none" border_color="" border_style="solid" border_position="all" border_radius="" box_shadow="no" dimension_box_shadow="" box_shadow_blur="0" box_shadow_spread="0" box_shadow_color="" box_shadow_style="" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" background_type="single" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" background_blend_mode="none" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" filter_type="regular" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" last="true" border_sizes_top="0" border_sizes_bottom="0" border_sizes_left="0" border_sizes_right="0" first="true"][fusion_text columns="" column_min_width="" column_spacing="" rule_style="default" rule_size="" rule_color="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset=""] Abstract [/fusion_text][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] Informix dbspace backups are known as "archives". From version 14.10, these can be made on a Remote Standalone Secondary (RSS) replica system. This article describes the necessary configuration changes which are not well documented. The process is easy, but does require a restart of the RSS instance. [/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" link_color="" link_hover_color="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left="" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" admin_label="Content" type="legacy"][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" hover_type="none" border_color="" border_style="solid" border_position="all" border_radius="" box_shadow="no" dimension_box_shadow="" box_shadow_blur="0" box_shadow_spread="0" box_shadow_color="" box_shadow_style="" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" background_type="single" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" background_blend_mode="none" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" filter_type="regular" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" last="true" border_sizes_top="0" border_sizes_bottom="0" border_sizes_left="0" border_sizes_right="0" first="true"][fusion_text columns="" column_min_width="" column_spacing="" rule_style="default" rule_size="" rule_color="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset=""] Content [/fusion_text][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] Examples in this article were produced using the provided "stores_demo" database in a Docker container from ibmcom/informix-developer-database . In a real case, we manage a multi-terabyte Informix 14.10 system which has both a local "High-availability Data Replication" (HDR) standby server and an RSS in another country for faster querying and to reduce traffic on the WAN link. We needed to be able to clone the RSS to a fourth system under testing without having to copy an archive across the WAN which would be very slow and affect other systems. This article assumes that you already have RSS up and running. If not, refer to " Starting an RS secondary server for the first time ". Before doing that, you must enable " Index page logging " on the primary instance. From the first release of IDS version 14.10, archives on an RSS system are possible if you set the following configuration parameter in the $ONCONFIG file, but the instance must be restarted: BAR_SEC_ALLOW_BACKUP 1 It can also be set to 2, which is undocumented but shown by the following command: [/fusion_text][fusion_syntax_highlighter theme="" language="x-sh" line_numbers="no" line_wrapping="" copy_to_clipboard="no" copy_to_clipboard_text="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" font_size="" border_size="" border_color="" hue="" saturation="" lightness="" alpha="" border_style="" background_color="" line_number_background_color="" line_number_text_color="" margin_top="" margin_right="" margin_bottom="" margin_left=""]JCBvbnN0YXQgLWcgY2ZnIGZ1bGwgQkFSX1NFQ19BTExPV19CQUNLVVAKCklCTSBJbmZvcm1peCBEeW5hbWljIFNlcnZlciBWZXJzaW9uIDE0LjEwLkZDMTBERSAtLSBPbi1MaW5lIC0tIFVwIDAxOjQ2OjIzIC0tIDMyNzgxMiBLYnl0ZXMKCkNvbmZpZ3VyYXRpb24gUGFyYW1ldGVyIEluZm8KCmlkICAgbmFtZSAgICAgICAgICAgICAgICAgICAgICB0eXBlICAgIG1heGxlbiAgIHVuaXRzICAgcnN2ZCAgdHVuYWJsZQozNDEgIEJBUl9TRUNfQUxMT1dfQkFDS1VQICAgICAgSU5UNCAgICAxMiAgICAgICAgICAgICAgICoKCiAgICAgbWluL21heCA6IDAsMQogICAgIGRlZmF1bHQgOiAwCiAgICAgb25jb25maWc6IDAKICAgICBjdXJyZW50IDogMAoKICAgICBEZXNjcmlwdGlvbjoKICAgICBCQVJfU0VDX0FMTE9XX0JBQ0tVUCBlbmFibGVzIHRoZSBvcGVyYXRvciBvZiB0aGlzIHNlY29uZGFyeSBzZXJ2ZXIgdG8KICAgICBwZXJmb3JtIHN0b3JhZ2Utc3BhY2UgYW5kIGxvZ2ljYWwgbG9nIGJhY2t1cHMuCiAgICAgQ3VycmVudGx5LCBvbmx5IFJTUyB0eXBlIHNlY29uZGFyeSBzZXJ2ZXJzIGFsbG93IHRoaXMgZmVhdHVyZS4KCiAgICAgVmFsaWQgdmFsdWVzOgogICAgICAgIDAgPSBEbyBub3QgYWxsb3cgYmFja3VwcyBpbiB0aGlzIHNlY29uZGFyeSBzZXJ2ZXIuCiAgICAgICAgMSA9IEFsbG93IGJhY2t1cHMsIGJ1dCBkbyBub3QgdXBkYXRlIHRoZSBzeXN1dGlscyBkYXRhYmFzZS4KICAgICAgICAyID0gQWxsb3cgYmFja3VwcyBhbmQgdXBkYXRlIHRoZSBzeXN1dGlscyBkYXRhYmFzZS4=[/fusion_syntax_highlighter][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] [br]There are two other essential changes. Firstly, unless you disable logical log backups, the RSS will surprisingly try to do that, which you are unlikely to want. Whether you use " ontape " or " onbar " for archives, that should be avoided by setting the following configuration parameter only on the RSS system and restarting that instance: LTAPEDEV /dev/null Secondly, it is your responsibility to ensure that all database objects are logged. Any unlogged databases, RAW tables, or unlogged smart blobs cannot be replicated. By default, when you attempt an archive on RSS, it will check and refuse to continue if it finds any. Moreover, if you have large smart blob spaces, that process can be very lengthy, and cause a long checkpoint on the primary, of around 15 minutes in our case. This can be avoided with the following parameter available from IDS 14.10.FC8 onwards: ARCHIVE_UNLOGGED_OBJECTS 3 If you click on the link, you will find that the parameter is documented but not the value 3. It is included in the following command output (also from IDS 14.10.FC8 onwards): [/fusion_text][fusion_syntax_highlighter theme="" language="x-sh" line_numbers="no" line_wrapping="" copy_to_clipboard="no" copy_to_clipboard_text="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" font_size="" border_size="" border_color="" hue="" saturation="" lightness="" alpha="" border_style="" background_color="" line_number_background_color="" line_number_text_color="" margin_top="" margin_right="" margin_bottom="" margin_left=""]JCBvbnN0YXQgLWcgY2ZnIGZ1bGwgQVJDSElWRV9VTkxPR0dFRF9PQkpFQ1RTCgpJQk0gSW5mb3JtaXggRHluYW1pYyBTZXJ2ZXIgVmVyc2lvbiAxNC4xMC5GQzEwREUgLS0gUmVhZC1Pbmx5IChSU1MpIC0tIFVwIDEgZGF5cyAwMjoxMTozMiAtLSAyODUyNjQgS2J5dGVzCgpDb25maWd1cmF0aW9uIFBhcmFtZXRlciBJbmZvCgppZCAgIG5hbWUgICAgICAgICAgICAgICAgICAgICAgdHlwZSAgICBtYXhsZW4gICB1bml0cyAgIHJzdmQgIHR1bmFibGUKMTA1ICBBUkNISVZFX1VOTE9HR0VEX09CSkVDVFMgIElOVDQgICAgMTIgICAgICAgICAgICAgICAgICAgICAqCgogICAgIG1pbi9tYXggOiAwLDMKICAgICBkZWZhdWx0IDogMAogICAgIG9uY29uZmlnOiAzCiAgICAgY3VycmVudCA6IDMKCiAgICAgVGhpcyBwYXJhbWV0ZXIgaXMgdW5kb2N1bWVudGVkLgoKICAgICBEZXNjcmlwdGlvbjoKICAgICBVc2UgQVJDSElWRV9VTkxPR0dFRF9PQkpFQ1RTIHdpdGggY2F1dGlvbi4gU2V0dGluZyBpdCBhbGxvd3MgYW4gYXJjaGl2ZQogICAgIHRvIHByb2NlZWQgb24gYSBzZWNvbmRhcnkgbm9kZSBkZXNwaXRlIHRoZSBwcmVzZW5jZSBvZiB1bmxvZ2dlZCBvYmplY3RzCiAgICAgc3VjaCBhcyByYXcgdGFibGVzLCBCTE9Cc3BhY2UgQkxPQnMsIHVubG9nZ2VkIHNtYXJ0YmxvYnMsIGFuZCBub24tbG9nZ2luZwogICAgIGRhdGFiYXNlcy4gIEJlY2F1c2UgdGhlc2Ugb2JqZWN0cyBhcmUgbm90IGZ1bGx5IHJlcGxpY2F0ZWQgdGhleSB3aWxsIG5vdAogICAgIGJlIGNvbXBsZXRlIG9uIGFuIGFyY2hpdmUgdGFrZW4gZnJvbSBhIHNlY29uZGFyeS4gUmVzdG9yaW5nIHRoZSBhcmNoaXZlCiAgICAgd2lsbCByZXN1bHQgaW4gaW5jb25zaXN0ZW5jaWVzIHdpdGhpbiB0aGVzZSBvYmplY3RzIHRoYXQgbWFrZSB0aGVtCiAgICAgdW51c2FibGUuCgogICAgIFBvc3NpYmxlIHZhbHVlczogMCAtLSAgIE9GRiAgIC0tIEFyY2hpdmUgb2YgdW5sb2dnZWQgb2JqZWN0cyBkaXNhbGxvd2VkCiAgICAgICAgICAgICAgICAgICAgICAxIC0tICBRVUlFVCAgLS0gQXJjaGl2ZSBhbGxvd2VkLCBxdWlldCBjaGVjayBtb2RlCiAgICAgICAgICAgICAgICAgICAgICAyIC0tIFZFUkJPU0UgLS0gQXJjaGl2ZSBhbGxvd2VkLCB2ZXJib3NlIGNoZWNrIG1vZGUKICAgICAgICAgICAgICAgICAgICAgIDMgLS0gIEZBU1QgICAtLSBBcmNoaXZlIGFsbG93ZWQsIG5vIGNoZWNrIHBlcmZvcm1lZA==[/fusion_syntax_highlighter][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] [br]The easiest option is to make all of the above changes to the $ONCONFIG file for the RSS instance and restart it just once. To check yourself whether there are unlogged objects: [/fusion_text][fusion_code]W3RhYmxlIGlkPTgzIC9d[/fusion_code][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] Note that the "oncheck" command above took 27 minutes on the real system, which is twice as slow as the built-in check. You are then ready to run archives on the RSS system. There are three archive levels: 0 - all pages 1 - only those changed since the last level 0 2 - only those changed since the last level 1 The following example used "ontape" to create a level 0 archive on the RSS instance: [/fusion_text][fusion_syntax_highlighter theme="" language="x-sh" line_numbers="no" line_wrapping="" copy_to_clipboard="no" copy_to_clipboard_text="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" font_size="" border_size="" border_color="" hue="" saturation="" lightness="" alpha="" border_style="" background_color="" line_number_background_color="" line_number_text_color="" margin_top="" margin_right="" margin_bottom="" margin_left=""]JCBvbnRhcGUgLXMgLUwgMCAtZApVc2luZyB0aGUgYmFja3VwIGFuZCByZXN0b3JlIGZpbHRlciBnemlwLgoxMCBwZXJjZW50IGRvbmUuCjIwIHBlcmNlbnQgZG9uZS4KMTAwIHBlcmNlbnQgZG9uZS4KRmlsZSBjcmVhdGVkOiAvb3B0L2libS9iYWNrdXAvYXJjaC9pZnhfMl9MMAoKUGxlYXNlIGxhYmVsIHRoaXMgdGFwZSBhcyBudW1iZXIgMSBpbiB0aGUgYXJjIHRhcGUgc2VxdWVuY2UuClRoaXMgdGFwZSBjb250YWlucyB0aGUgZm9sbG93aW5nIGxvZ2ljYWwgbG9nczoKCiA0NjQ5CgpQcm9ncmFtIG92ZXIuCgokIG9uc3RhdCAtbSB8IHRhaWwgLTIKMTc6MDY6MDMgIExldmVsIDAgQXJjaGl2ZSBzdGFydGVkIG9uIHJvb3RkYnMsIHBoeXNkYnMsIGxsb2dkYnMsIGRhdGFkYnMsIGhxZGJzLCBjZHJkYnMsIHNic3BhY2UsIGNkcnNicwoxNzowNjowOSAgQXJjaGl2ZSBvbiByb290ZGJzLCBwaHlzZGJzLCBsbG9nZGJzLCBkYXRhZGJzLCBocWRicywgY2RyZGJzLCBzYnNwYWNlLCBjZHJzYnMgQ29tcGxldGVkLg==[/fusion_syntax_highlighter][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] [br]These messages were also recorded on the primary instance: [/fusion_text][fusion_syntax_highlighter theme="" language="x-sh" line_numbers="no" line_wrapping="" copy_to_clipboard="no" copy_to_clipboard_text="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" font_size="" border_size="" border_color="" hue="" saturation="" lightness="" alpha="" border_style="" background_color="" line_number_background_color="" line_number_text_color="" margin_top="" margin_right="" margin_bottom="" margin_left=""]JCBvbnN0YXQgLW0gfCB0YWlsIC0yCjE3OjA2OjAzICBBcmNoaXZlIGhhcyBzdGFydGVkIGluIHNlY29uZGFyeSBzZXJ2ZXIgY2x1c3RlcjIuCjE3OjA2OjA5ICBBcmNoaXZlIGhhcyBjb21wbGV0ZWQgaW4gc2Vjb25kYXJ5IHNlcnZlciBjbHVzdGVyMi4=[/fusion_syntax_highlighter][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" link_color="" link_hover_color="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left="" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" admin_label="Caveats" type="legacy"][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" hover_type="none" border_color="" border_style="solid" border_position="all" border_radius="" box_shadow="no" dimension_box_shadow="" box_shadow_blur="0" box_shadow_spread="0" box_shadow_color="" box_shadow_style="" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" background_type="single" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" background_blend_mode="none" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" filter_type="regular" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" last="true" border_sizes_top="0" border_sizes_bottom="0" border_sizes_left="0" border_sizes_right="0" first="true"][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] Tips & Tricks [/fusion_text][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] HDR and RSS instances require that chunk paths are identical. However, you can create them on the same host for testing by using relative paths, as long as you start them while in the correct directory. Define shell aliases so you don't forget, as in this case: [/fusion_text][fusion_syntax_highlighter theme="" language="x-sh" line_numbers="no" line_wrapping="" copy_to_clipboard="no" copy_to_clipboard_text="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" font_size="" border_size="" border_color="" hue="" saturation="" lightness="" alpha="" border_style="" background_color="" line_number_background_color="" line_number_text_color="" margin_top="" margin_right="" margin_bottom="" margin_left=""]JCBvbnN0YXQgLWMgUk9PVFBBVEgKcm9vdGRicy4wMDAKCiQgYWxpYXMKYWxpYXMgY2x1c3RlcjE9J2V4cG9ydCBJTkZPUk1JWFNFUlZFUj1jbHVzdGVyMSBPTkNPTkZJRz1vbmNvbmZpZy4xIDsgY2QgL29wdC9pYm0vZGF0YS9zcGFjZXMuMScKYWxpYXMgY2x1c3RlcjI9J2V4cG9ydCBJTkZPUk1JWFNFUlZFUj1jbHVzdGVyMiBPTkNPTkZJRz1vbmNvbmZpZy4yIDsgY2QgL29wdC9pYm0vZGF0YS9zcGFjZXMuMic=[/fusion_syntax_highlighter][fusion_text columns="" column_min_width="" column_spacing="" rule_style="default" rule_size="" rule_color="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset=""] Caveats [/fusion_text][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] This is only supported on RSS servers at this time, not HDR. [/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" link_color="" link_hover_color="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left="" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" admin_label="Conclusion" type="legacy"][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" hover_type="none" border_color="" border_style="solid" border_position="all" border_radius="" box_shadow="no" dimension_box_shadow="" box_shadow_blur="0" box_shadow_spread="0" box_shadow_color="" box_shadow_style="" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" background_type="single" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" background_blend_mode="none" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" filter_type="regular" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" last="true" border_sizes_top="0" border_sizes_bottom="0" border_sizes_left="0" border_sizes_right="0" first="true"][fusion_text columns="" column_min_width="" column_spacing="" rule_style="default" rule_size="" rule_color="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset=""] Conclusion [/fusion_text][fusion_text columns="" column_min_width="" column_spacing="" rule_style="" rule_size="" rule_color="" hue="" saturation="" lightness="" alpha="" content_alignment_medium="" content_alignment_small="" content_alignment="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" margin_top="" margin_right="" margin_bottom="" margin_left="" fusion_font_family_text_font="" fusion_font_variant_text_font="" font_size="" line_height="" letter_spacing="" text_transform="" text_color="" animation_type="" animation_direction="left" animation_color="" animation_speed="0.3" animation_delay="0" animation_offset="" logics=""] You only need to set the configuration parameters listed in this article and restart an RSS instance for local archives to be possible. [/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" link_color="" link_hover_color="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left="" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" admin_label="Disclaimer" type="legacy"][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" hover_type="none" border_color="" border_style="solid" border_position="all" border_radius="" box_shadow="no" dimension_box_shadow="" box_shadow_blur="0" box_shadow_spread="0" box_shadow_color="" box_shadow_style="" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" background_type="single" gradient_start_color="" gradient_end_color="" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" background_blend_mode="none" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" filter_type="regular" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" last="true" border_sizes_top="0" border_sizes_bottom="0" border_sizes_left="0" border_sizes_right="0" first="true"][fusion_text columns="" column_min_width="" column_spacing="" rule_style="default" rule_size="" rule_color="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset=""] Disclaimer [/fusion_text][fusion_text columns="" column_min_width="" column_spacing="" rule_style="default" rule_size="" rule_color="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset=""] Suggestions above are provided "as is" without warranty of any kind, either express or implied, including without limitation any implied warranties of condition, uninterrupted use, merchantability, fitness for a particular purpose, or non-infringement. [/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]

FAQs Archive - Oninit Consulting

Foreign key dependencies

Abstract

When recreating a table or its primary key, Informix Dynamic Server (IDS) doesn’t warn you that any foreign key constraints that reference it will be dropped. If you don’t have AGS Server Studio (which can show all types of object dependencies graphically), this article provides a convenient shell script to find this out beforehand.

[Read More…]

Foreign key dependenciesDoug Lawry2024-10-23T11:34:09+01:00

Informix Workgroup cluster relocation

Abstract

We were recently asked to move an Informix Dynamic Server (IDS) Workgroup Edition (WE) version 14.10.FC8 High-availability Data Replication (HDR) server pair to new hardware in another country. The application is a critical 24×7 public service, and only a short break in service would be tolerated. The instance has around 1.5TB used pages, so we needed to have the databases replicated at the new site beforehand. That was a problem because WE only allows 3 replicas to be connected, and there is also a Remote Standalone Secondary (RSS) instance which was not moving. This article explains how it was achieved.

[Read More…]

Informix Workgroup cluster relocationDoug Lawry2024-06-14T11:54:02+01:00

Informix trigger updating same table

Abstract

Informix Dynamic Server (IDS) does allow a table to be updated by a trigger on itself if you know how to work around certain restrictions. The documentation is not very thorough on this subject, which this article rectifies.

[Read More…]

Informix trigger updating same tableDoug Lawry2024-06-14T11:30:18+01:00

Little known IDS commands: ifxcollect

Abstract

In this series of articles, we are exploring some of the lesser known – but still useful – commands hidden away in your Informix bin directory. This article explores the ifxcollect utility. Introduced in version 11.70, ifxcollect is a tool designed to gather diagnostic information from IDS to aid Technical Support should the issue need to be escalated. This article looks at the features of the latest version shipped with 14.10.

[Read More…]

Little known IDS commands: ifxcollectScott O'Rourke2024-06-14T11:31:14+01:00

Recording Informix schema changes

Abstract

Have you ever been asked to refresh a test database instance from production, then been told afterwards that the definitions of some new objects under development have been lost? It’s obviously better to use a tool such as AGS Server Studio Schema Diff beforehand to save SQL to be reapplied. If that hasn’t happened, you need to have a record of the database schema before it was overwritten so you can list differences. You could purchase the AGS Sentinel Change Management Option to record version snapshots at regular intervals, but this article provides a shell script to achieve that, though without any GUI.

[Read More…]

Recording Informix schema changesDoug Lawry2024-05-09T16:02:34+01:00

Informix SPL exception logging

Abstract

Informix Stored Procedure Language (SPL) has a smaller command set than other database products, but is more than adequate when making full use of built-in SQL functions. An SPL routine is called a PROCEDURE if no data is returned, or FUNCTION otherwise, as explained here. User Defined Routines (UDRs) can also be written in C or Java, whereas this article is only concerned with SPL UDRs. There may be multiple levels of SPL routines called by another, and it can be difficult to know which has failed if an error results. This article provides a method of recording and retrieving the details of any failure, with only a tiny code addition at the top of each routine.

[Read More…]

Informix SPL exception loggingDoug Lawry2024-02-20T18:10:12+00:00

Migrating to Genero v4

Abstract

Genero version 4 brings in lots of new features that make it well worth upgrading to. The new version introduces several changes that you’ll need to be aware of if upgrading from an earlier version though. This article covers some of the challenges we faced, and the solutions found to resolve them.

[Read More…]

Migrating to Genero v4Scott O'Rourke2024-02-19T15:49:42+00:00

A Number of Reasons to Upgrade to the Latest Genero Release

Abstract

Originally developed as a GUI replacement to “green-screen” Informix-4GL, Genero has become a powerful and advanced development suite, with a long list of supported platforms, database engines and deployment options. A host of new features are added at every release; Whether you’re running an early version, still on 4gl, or looking for a platform for a new development project, there are some very compelling reasons to start using, the very latest version of Genero.

[Read More…]

A Number of Reasons to Upgrade to the Latest Genero ReleaseScott O'Rourke2024-02-19T15:24:50+00:00

Archives on RSS

Abstract

Informix dbspace backups are known as “archives”. From version 14.10, these can be made on a Remote Standalone Secondary (RSS) replica system. This article describes the necessary configuration changes which are not well documented. The process is easy, but does require a restart of the RSS instance.

[Read More…]

Archives on RSSDoug Lawry2023-07-24T11:18:16+01:00

LOAD and UNLOAD functions

Updated June 2024

June 2024 change log:

sp_load into temp table handled
sp_load no longer specifies EXPRESS (only caused warning in message log)

September 2023 change log:

Work-around for tables containing hidden specialized columns such as VERCOLS
DBDATE external table option removed for better flexibility via environment
CONSTRAINTS also disabled as necessary for EXPRESS with hidden indexes.

We have raised relevant APARs to be fixed in 14.10.xC11. They are:

IT44526 SQL error: -26190 and -236 on inserting external table from a ‘table having VERCOLS’

https://www.ibm.com/docs/en/informix-servers/14.10?topic=statement-specialized-columns

Worked around in “sp_load” by excluding all type of hidden specialized columns.

IT44527 Inaccurate documentation on conditions forcing DELUXE load from external table

https://www.ibm.com/docs/en/informix-servers/14.10?topic=statement-table-options

DELUXE is in fact forced if the table contains BYTE/TEXT columns or the row size exceeds page size minus 32.

Abstract

The Informix statements LOAD and UNLOAD allow data to be transferred between a flat file and a database, but are in fact only implemented in certain clients such as DB-Access, 4GL variants, and AGS Server Studio. You may therefore need functions in Informix Dynamic Server (IDS) that do this, such as when coding in Java with JDBC. Furthermore, external tables are much lighter and quicker for this purpose, so you might in any case prefer the functions described in this article, which use them in Informix Stored Procedure Language (SPL).

[Read More…]

LOAD and UNLOAD functionsDoug Lawry2024-06-14T16:14:18+01:00

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Updated June 2024

Abstract

Related Technical Articles: