[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]

[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=""] Informix supports views like other database products, which behave much like tables but are in fact SELECT statements stored for convenience and reuse. If a table or view is dropped and recreated during a schema change, any views in the same database that depended on it will have been lost. This article covers this problem, and includes SQL to list dependencies and definitions of views. [/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=""] Examples in this article were produced using the provided "stores_demo" database in a Docker container from ibmcom/informix-developer-database . Let's say we create a view on "customer" that combines name and address components into single columns: [/fusion_text][fusion_syntax_highlighter theme="" language="sql" line_numbers="" line_wrapping="" copy_to_clipboard="" 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=""]RFJPUCBWSUVXIElGIEVYSVNUUyB2X2N1c3RfYWxsOwoKQ1JFQVRFIFZJRVcgdl9jdXN0X2FsbAogICAgKGN1c3RvbWVyX251bSwgZnVsbF9uYW1lLCBhZGRyZXNzLCBwaG9uZSkKQVMKU0VMRUNUCiAgICBjdXN0b21lcl9udW0sCiAgICBUUklNKGZuYW1lKSB8fCAnICcgfHwgVFJJTShsbmFtZSksCiAgICBUUklNKGFkZHJlc3MxKSB8fCAnLCAnIHx8IE5WTChUUklNKGFkZHJlc3MyKSB8fCAnLCAnLCAnJykKICAgIHx8IFRSSU0oY2l0eSkgfHwgJywgJyB8fCBUUklNKHN0YXRlKSB8fCAnICcgfHwgVFJJTSh6aXBjb2RlKSwKICAgIFRSSU0ocGhvbmUpCkZST00gY3VzdG9tZXI7CgpHUkFOVCBTRUxFQ1QgT04gdl9jdXN0X2FsbCBUTyBQVUJMSUM7CgpTRUxFQ1QgRklSU1QgMTAgKiBGUk9NIHZfY3VzdF9hbGw7IC0tIHRlc3Qgc2FtcGxl[/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=""] [br] [/fusion_text][fusion_code]W3RhYmxlIGlkPTc3IC9d[/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=""] See documentation for CREATE VIEW Because the SELECT statement returns expressions, we must specify view column names. Source columns are of type CHAR, so we need to discard trailing spaces with TRIM . We can handle NULL values in "address" with the built-in function NVL . Unlike tables, views do not have public SELECT privilege by default, so usually need GRANT . Then let's say a requirement comes up to list customers in the above format but only if they are out of state, with the company being in California. A quick solution using another view would be: [/fusion_text][fusion_syntax_highlighter theme="" language="sql" line_numbers="" line_wrapping="" copy_to_clipboard="" 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=""]RFJPUCBWSUVXIElGIEVYSVNUUyB2X2N1c3Rfb29zOwoKQ1JFQVRFIFZJRVcgdl9jdXN0X29vcwpBUwpTRUxFQ1QgKgpGUk9NIHZfY3VzdF9hbGwKV0hFUkUgYWRkcmVzcyBOT1QgTUFUQ0hFUyAnKiwgQ0EgKic7CgpHUkFOVCBTRUxFQ1QgT04gdl9jdXN0X29vcyBUTyBQVUJMSUM7CgpTRUxFQ1QgRklSU1QgMTAgKiBGUk9NIHZfY3VzdF9vb3M7IC0tIHRlc3Qgc2FtcGxl[/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=""] [br] [/fusion_text][fusion_code]W3RhYmxlIGlkPTc4IC9d[/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=""] Because the SELECT statement returns simple columns, we do not need to specify view column names. By using the existing view, we do not need to repeat the complex logic for combined columns. Sometime later, let's say you need to make a small change to the code of "v_cust_all". There is no syntax in Informix such as "alter view" or "replace view". The only option is to drop and recreate the view. You therefore need a way to check for dependent views before dropping and recreating a table or view, and this is in fact quite simple: [/fusion_text][fusion_accordion type="toggles" inactive_icon="" active_icon="" margin_top="" margin_bottom="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" boxed_mode="yes" border_size="1" border_color="#ffc100" hue="" saturation="" lightness="" alpha="" background_color="" hover_color="" divider_line="" divider_color="" divider_hover_color="" padding_top="" padding_right="" padding_bottom="" padding_left="" title_tag="h4" fusion_font_family_title_font="" fusion_font_variant_title_font="" title_font_size="" title_line_height="" title_letter_spacing="" title_text_transform="" title_color="#009dd9" icon_size="" icon_color="" icon_boxed_mode="" icon_box_color="" icon_alignment="" fusion_font_family_content_font="" fusion_font_variant_content_font="" content_font_size="" content_line_height="" content_letter_spacing="" content_text_transform="" content_color="#393c4c" toggle_hover_accent_color="" toggle_active_accent_color=""][fusion_toggle title="sysdepend.sql" open="no" class="" id="" fusion_font_family_title_font="" fusion_font_variant_title_font="" title_font_size="" title_line_height="" title_letter_spacing="" title_text_transform="" title_color="#009dd9" hue="" saturation="" lightness="" alpha="" fusion_font_family_content_font="" fusion_font_variant_content_font="" content_font_size="" content_line_height="" content_letter_spacing="" content_text_transform="" content_color="#393c4c"] [fusion_syntax_highlighter theme="" language="sql" line_numbers="" line_wrapping="" copy_to_clipboard="" 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=""]U0VMRUNUCiAgICB0LnRhYm5hbWUgQVMgb2JqZWN0LAogICAgZC5idHlwZSAgIEFTIHR5cGUsCiAgICB2LnRhYm5hbWUgQVMgdmlldwpGUk9NCiAgICBzeXNkZXBlbmQgQVMgZCwKICAgIHN5c3RhYmxlcyBBUyB0LAogICAgc3lzdGFibGVzIEFTIHYKV0hFUkUKICAgIGQuYnRhYmlkID0gdC50YWJpZApBTkQgZC5kdGFiaWQgPSB2LnRhYmlkCkFORCBkLmR0YWJpZCA+IDk5Ck9SREVSIEJZIDEsIDI7[/fusion_syntax_highlighter] [/fusion_toggle][/fusion_accordion][fusion_code]W3RhYmxlIGlkPTc5IC9d[/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=""] This is a query on system catalog tables in "stores_demo" (not "sysmaster"). View dependency relationships are contained in " sysdepend ". Each table ID is looked up to get the table name from " systables ". Dependent views in other databases are not recorded or dropped. An alternative solution is Server Studio which can show dependencies graphically. Armed with that, we know that we would need to recreate "v_cust_oos" after "v_cust_all". If we have lost the original scripts used to create views, the provided tool is " dbschema ", which the following shell script uses: [/fusion_text][fusion_accordion type="toggles" inactive_icon="" active_icon="" margin_top="" margin_bottom="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" boxed_mode="yes" border_size="1" border_color="#ffc100" hue="" saturation="" lightness="" alpha="" background_color="" hover_color="" divider_line="" divider_color="" divider_hover_color="" padding_top="" padding_right="" padding_bottom="" padding_left="" title_tag="h4" fusion_font_family_title_font="" fusion_font_variant_title_font="" title_font_size="" title_line_height="" title_letter_spacing="" title_text_transform="" title_color="#009dd9" icon_size="" icon_color="" icon_boxed_mode="" icon_box_color="" icon_alignment="" fusion_font_family_content_font="" fusion_font_variant_content_font="" content_font_size="" content_line_height="" content_letter_spacing="" content_text_transform="" content_color="#393c4c" toggle_hover_accent_color="" toggle_active_accent_color=""][fusion_toggle title="schema.sh" open="no" class="" id="" fusion_font_family_title_font="" fusion_font_variant_title_font="" title_font_size="" title_line_height="" title_letter_spacing="" title_text_transform="" title_color="#009dd9" hue="" saturation="" lightness="" alpha="" fusion_font_family_content_font="" fusion_font_variant_content_font="" content_font_size="" content_line_height="" content_letter_spacing="" content_text_transform="" content_color="#393c4c"] [fusion_syntax_highlighter theme="" language="x-sh" line_numbers="" line_wrapping="" copy_to_clipboard="" 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=""]IyBFeHRyYWN0IHRoZSBzY2hlbWEgZm9yIHNwZWNpZmllZCB0YWJsZXMgb3Igdmlld3MKIyBEb3VnIExhd3J5LCBPbmluaXQgQ29uc3VsdGluZywgTm92ZW1iZXIgMjAyMgoKc2V0IC1lICMgYWJvcnQgb24gZXJyb3IKCmlmIFsgJCMgLWx0IDIgXQp0aGVuCiAgICBlY2hvICJVc2FnZTogJDAgZGF0YWJhc2UgdGFibGUtb3ItdmlldyBbLi4uXSIgMj4mMQogICAgZXhpdCAxCmZpCgpEQj0iJDEiIDsgc2hpZnQKCmZvciBpCmRvCiAgICBlY2hvIDsgZGJzY2hlbWEgLWQgIiREQiIgLXQgIiRpIiAtcSAtc3MgfCBncmVwICdbXiBdJwogICAgZWNobyA7IGRic2NoZW1hIC1kICIkREIiIHwgZ3JlcCAiXmdyYW50IC4qJGkiCmRvbmUKCmVjaG8=[/fusion_syntax_highlighter] [/fusion_toggle][/fusion_accordion][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=""] We can regenerate and save SQL to recreate our views as follows: [/fusion_text][fusion_syntax_highlighter theme="" language="x-sh" line_numbers="" line_wrapping="" copy_to_clipboard="" 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=""]aW5mb3JtaXhAaWZ4On4kIHNoIHNjaGVtYS5zaCBzdG9yZXNfZGVtbyB2X2N1c3RfYWxsIHZfY3VzdF9vb3MgPiB2aWV3cy5zcWw=[/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=""] [br] That file contains: [/fusion_text][fusion_syntax_highlighter theme="" language="x-sh" line_numbers="no" line_wrapping="" copy_to_clipboard="" 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=""]Y3JlYXRlIHZpZXcgImluZm9ybWl4Ii52X2N1c3RfYWxsIChjdXN0b21lcl9udW0sZnVsbF9uYW1lLGFkZHJlc3MscGhvbmUpIGFzCiAgc2VsZWN0IHgwLmN1c3RvbWVyX251bSAsKChUUklNICggQk9USCAgJyAnIEZST00geDAuZm5hbWUgKSB8fAogICAgJyAnICkgfHwgVFJJTSAoIEJPVEggICcgJyBGUk9NIHgwLmxuYW1lICkgKSAsKCgoKCgoKFRSSU0gKAogICAgQk9USCAgJyAnIEZST00geDAuYWRkcmVzczEgKSB8fCAnLCAnICkgfHwgTlZMICgoVFJJTSAoIEJPVEgKICAgICAnICcgRlJPTSB4MC5hZGRyZXNzMiApIHx8ICcsICcgKSAsJycgKSkgfHwgVFJJTSAoIEJPVEggICcgJwogICAgRlJPTSB4MC5jaXR5ICkgKSB8fCAnLCAnICkgfHwgVFJJTSAoIEJPVEggICcgJyBGUk9NIHgwLnN0YXRlCiAgICApICkgfHwgJyAnICkgfHwgVFJJTSAoIEJPVEggICcgJyBGUk9NIHgwLnppcGNvZGUgKSApICxUUklNCiAgICAoIEJPVEggICcgJyBGUk9NIHgwLnBob25lICkgZnJvbSAiaW5mb3JtaXgiLmN1c3RvbWVyIHgwIDsKCmdyYW50IHNlbGVjdCBvbiAiaW5mb3JtaXgiLnZfY3VzdF9hbGwgdG8gInB1YmxpYyIgYXMgImluZm9ybWl4IjsKCmNyZWF0ZSB2aWV3ICJpbmZvcm1peCIudl9jdXN0X29vcyAoY3VzdG9tZXJfbnVtLGZ1bGxfbmFtZSxhZGRyZXNzLHBob25lKSBhcwogIHNlbGVjdCB4MC5jdXN0b21lcl9udW0gLHgwLmZ1bGxfbmFtZSAseDAuYWRkcmVzcyAseDAucGhvbmUgZnJvbQogICAgImluZm9ybWl4Ii52X2N1c3RfYWxsIHgwIHdoZXJlICh4MC5hZGRyZXNzIE5PVCBNQVRDSEVTICcqLCBDQSAqJwogICAgICkgOwoKZ3JhbnQgc2VsZWN0IG9uICJpbmZvcm1peCIudl9jdXN0X29vcyB0byAicHVibGljIiBhcyAiaW5mb3JtaXgiOwo=[/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=""] [br] You can see that the original source code formatting has not been retained. Informix stores the SQL of views in the above standard format in " sysviews ". Because of this, it is able to update them if a selected object is renamed, but you must keep your view creation scripts somewhere safe if you want to maintain more readable code. Server Studio can also generate view schemas with the same proviso that formatting is lost, although there is a code beautifier. More importantly, its DB Diff feature can compare and synchronise the schema from another copy of the database, which can both identify missing views and produce the SQL to create them in a single step. Note that " dbschema " and Server Studio are able to extract the original source for stored procedures from " sysprocbody " rows with "datakey" containing "T" for that procedure ID. Conversely, stored procedures are not updated when an object it uses is renamed. The best solution is to keep a single source code file for a hierarchy of views, for example: [/fusion_text][fusion_syntax_highlighter theme="" language="sql" line_numbers="" line_wrapping="" copy_to_clipboard="" 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=""]RFJPUCBWSUVXIElGIEVYSVNUUyB2X2N1c3RfYWxsOwoKQ1JFQVRFIFZJRVcgdl9jdXN0X2FsbAogICAgKGN1c3RvbWVyX251bSwgZnVsbF9uYW1lLCBhZGRyZXNzLCBwaG9uZSkKQVMKU0VMRUNUCiAgICBjdXN0b21lcl9udW0sCiAgICBUUklNKGZuYW1lKSB8fCAnICcgfHwgVFJJTShsbmFtZSksCiAgICBUUklNKGFkZHJlc3MxKSB8fCAnLCAnIHx8IE5WTChUUklNKGFkZHJlc3MyKSB8fCAnLCAnLCAnJykKICAgIHx8IFRSSU0oY2l0eSkgfHwgJywgJyB8fCBUUklNKHN0YXRlKSB8fCAnICcgfHwgVFJJTSh6aXBjb2RlKSwKICAgIFRSSU0ocGhvbmUpCkZST00gY3VzdG9tZXI7CgpDUkVBVEUgVklFVyB2X2N1c3Rfb29zCkFTClNFTEVDVCAqCkZST00gdl9jdXN0X2FsbApXSEVSRSBhZGRyZXNzIE5PVCBNQVRDSEVTICcqLCBDQSAqJzsKCkdSQU5UIFNFTEVDVCBPTiB2X2N1c3RfYWxsIFRPIFBVQkxJQzsKR1JBTlQgU0VMRUNUIE9OIHZfY3VzdF9vb3MgVE8gUFVCTElDOw==[/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="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=""] This article provides scripts to identify dependent views that would need recreating if an object on which it depends is recreated, and to save their definitions. Keeping view source code somewhere safe is important both to retain original readability and if inadvertently dropped. [/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

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

View dependencies

Abstract

Informix supports views like other database products, which behave much like tables but are in fact SELECT statements stored for convenience and reuse. If a table or view is dropped and recreated during a schema change, any views in the same database that depended on it will have been lost. This article covers this problem, and includes SQL to list dependencies and definitions of views.

[Read More…]

View dependenciesDoug Lawry2023-01-25T09:52:30+00: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:

Updated June 2024

Abstract

Related Technical Articles:

Abstract

Related Technical Articles: