{"id":22557,"date":"2022-06-24T11:33:40","date_gmt":"2022-06-24T09:33:40","guid":{"rendered":"https:\/\/infotel-software.com\/database-management\/"},"modified":"2026-02-17T14:34:38","modified_gmt":"2026-02-17T13:34:38","slug":"db-iq","status":"publish","type":"page","link":"https:\/\/infotel-software.com\/fr\/db-iq\/","title":{"rendered":"DB\/IQ \u2013 Qualit\u00e9 et Performances Db2"},"content":{"rendered":"<p>[et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBanni\u00e8re\u00a0\u00bb _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bbon\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_slider _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb header_level=\u00a0\u00bbh1&Prime; header_font_size=\u00a0\u00bb60px\u00a0\u00bb background_enable_color=\u00a0\u00bboff\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_slide heading=\u00a0\u00bbDB\/IQ\u00a0\u00bb use_bg_overlay=\u00a0\u00bbon\u00a0\u00bb use_text_overlay=\u00a0\u00bboff\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb header_font=\u00a0\u00bbArial|700|||||||\u00a0\u00bb header_font_size=\u00a0\u00bb40px\u00a0\u00bb background_enable_color=\u00a0\u00bboff\u00a0\u00bb use_background_color_gradient=\u00a0\u00bbon\u00a0\u00bb background_color_gradient_type=\u00a0\u00bbcircular\u00a0\u00bb background_color_gradient_stops=\u00a0\u00bb#2ea3f2 30%|#004f91 100%\u00a0\u00bb background_enable_image=\u00a0\u00bboff\u00a0\u00bb header_font_size_tablet=\u00a0\u00bb40px\u00a0\u00bb header_font_size_phone=\u00a0\u00bb24px\u00a0\u00bb header_font_size_last_edited=\u00a0\u00bbon|phone\u00a0\u00bb custom_css_free_form=\u00a0\u00bb.et_pb_bg_layout_dark.et_pb_slider_with_overlay .et_pb_slide_overlay_container, .et_pb_bg_layout_dark.et_pb_slider_with_text_overlay .et_pb_text_overlay_wrapper {||    background-color: rgba(0, 0, 0, 0)!important;||}\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb sticky_transition=\u00a0\u00bbon\u00a0\u00bb][\/et_pb_slide][\/et_pb_fullwidth_slider][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb custom_margin=\u00a0\u00bb||14px||false|false\u00a0\u00bb custom_padding=\u00a0\u00bb0%||0px||false|false\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb collapsed=\u00a0\u00bbon\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_row _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb custom_margin=\u00a0\u00bb||14px||false|false\u00a0\u00bb custom_padding=\u00a0\u00bb||0px|||\u00a0\u00bb collapsed=\u00a0\u00bboff\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_column type=\u00a0\u00bb4_4&Prime; _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_text _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb custom_padding=\u00a0\u00bb0px|||||\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<div class=\"et_pb_row et_pb_row_0\">\n<div class=\"et_pb_column et_pb_column_4_4 et_pb_column_0  et_pb_css_mix_blend_mode_passthrough et-last-child\">\n<div class=\"et_pb_module et_pb_text et_pb_text_0  et_pb_text_align_left et_pb_bg_layout_light\">\n<div class=\"et_pb_text_inner\">\n<h3 style=\"text-align: center;\"><strong>Assurez la qualit\u00e9 et la performance des applications SQL Db2<\/strong><\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00a0\u00bb1_4,1_4,1_4,1_4&Prime; _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb collapsed=\u00a0\u00bboff\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_column type=\u00a0\u00bb1_4&Prime; _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_image src=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/check-circle-regular.png\u00a0\u00bb title_text=\u00a0\u00bbcheck-circle-regular\u00a0\u00bb align=\u00a0\u00bbcenter\u00a0\u00bb _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb text_orientation=\u00a0\u00bbcenter\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<p>V\u00e9rifiez que les applications SQL Db2 respectent vos r\u00e8gles de qualit\u00e9<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=\u00a0\u00bb1_4&Prime; _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_image src=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/medal-solid.png\u00a0\u00bb title_text=\u00a0\u00bbmedal-solid\u00a0\u00bb align=\u00a0\u00bbcenter\u00a0\u00bb _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb text_orientation=\u00a0\u00bbcenter\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<p>\u00c9valuez si les chemins d\u2019acc\u00e8s aux donn\u00e9es sont efficaces<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=\u00a0\u00bb1_4&Prime; _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_image src=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/search-solid.png\u00a0\u00bb title_text=\u00a0\u00bbsearch-solid\u00a0\u00bb align=\u00a0\u00bbcenter\u00a0\u00bb _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb text_orientation=\u00a0\u00bbcenter\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<p>D\u00e9terminez les meilleures strat\u00e9gies indicielles<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=\u00a0\u00bb1_4&Prime; _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_image src=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/check-solid.png\u00a0\u00bb title_text=\u00a0\u00bbcheck-solid\u00a0\u00bb align=\u00a0\u00bbcenter\u00a0\u00bb _builder_version=\u00a0\u00bb4.17.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_image][et_pb_text _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb text_orientation=\u00a0\u00bbcenter\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<p>Contr\u00f4lez l\u2019ex\u00e9cution des requ\u00eates Db2 m\u00eame en dynamique<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbTexte centr\u00e9\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bbon\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_header module_class=\u00a0\u00bbsection-centre-blanc\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb content_font_size=\u00a0\u00bb18px\u00a0\u00bb custom_css_free_form=\u00a0\u00bbh4 {||  line-height:1.4em;||}||||.et_pb_fullwidth_header .et_pb_fullwidth_header_container .header-content a.et_pb_button {||    background-color:  #2ea3f2 !important;||    color: white !important;||}\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<h4 style=\"text-align: center;\">DB\/IQ est un ensemble de solutions pour garantir la qualit\u00e9 et la performance de vos requ\u00eates SQL, qu\u2019elles soient statiques ou dynamiques, tout en r\u00e9duisant la charge sur votre environnement z\/OS.<\/h4>\n<div class=\"et_pb_fullwidth_header_container left\">\n<div class=\"header-content-container center\">\n<div class=\"header-content\">\n<div class=\"et_pb_header_content_wrapper\">\n<h4 style=\"text-align: center;\">La suite DB\/IQ comprend les modules suivants : DB\/IQ QA, QA+, PackMan, IA+, MA+, WL et le plugin Eclipse.<\/h4>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 1&Prime; _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bboff\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_header title=\u00a0\u00bbDB\/IQ QA : le Contr\u00f4le Qualit\u00e9\u00a0\u00bb text_orientation=\u00a0\u00bbright\u00a0\u00bb button_one_text=\u00a0\u00bbDemander une d\u00e9mo\u00a0\u00bb button_one_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/demo\/\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-1.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3&Prime; title_text_align=\u00a0\u00bbleft\u00a0\u00bb title_text_color=\u00a0\u00bb#2ea3f2&Prime; content_text_color=\u00a0\u00bb#000000&Prime; background_enable_color=\u00a0\u00bboff\u00a0\u00bb custom_button_one=\u00a0\u00bbon\u00a0\u00bb button_one_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb button_one_bg_color=\u00a0\u00bb#2ea3f2&Prime; link_option_url_new_window=\u00a0\u00bbon\u00a0\u00bb custom_css_free_form=\u00a0\u00bb.et_pb_bg_layout_dark h3 {||    text-align: left;||}||||.et_pb_fullwidth_header .et_pb_fullwidth_header_container .header-content a.et_pb_button {||    background-color:  #2ea3f2 !important;||    color: white !important;||}||||.et_pb_fullwidth_header .et_pb_fullwidth_header_container.right .header-content {||    text-align: left !important;||}\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<div class=\"et_pb_module et_pb_text et_pb_text_2  et_pb_text_align_left et_pb_bg_layout_light\">\n<div class=\"et_pb_text_inner\">\n<p>La solution<strong>\u00a0DB\/IQ Quality Assurance<\/strong>\u00a0analyse et effectue des contr\u00f4les sur tout le\u00a0<strong>code SQL<\/strong>, que ce dernier soit sous forme de source,\u00a0<strong>DBRM<\/strong>\u00a0r\u00e9sultant du pr\u00e9processeur<strong>\u00a0Db2, SQL<\/strong>\u00a0bas\u00e9 sur le catalogue (plans, packages, vues,\u00a0<strong>MQTs, triggers,<\/strong>\u00a0etc.), ou SQL ex\u00e9cut\u00e9 de mani\u00e8re dynamique.<\/p>\n<p><strong>DB\/IQ QA<\/strong>\u00a0assure un contr\u00f4le avanc\u00e9 du code SQL gr\u00e2ce aux fonctionnalit\u00e9s suivantes :<\/p>\n<ul>\n<li>Permet de v\u00e9rifier la qualit\u00e9 de tout le code SQL selon les normes d\u00e9finies par l\u2019organisation<\/li>\n<li>Plus de 370 r\u00e8gles de qualit\u00e9 sont disponibles \u00ab cl\u00e9 en main \u00bb et peuvent \u00eatre personnalis\u00e9es en fonction de vos exigences et de vos accords de niveau de service<\/li>\n<li>Fournit aux d\u00e9veloppeurs un contr\u00f4le de qualit\u00e9 interactif et une fonctionnalit\u00e9\u00a0<strong>EXPLAIN<\/strong>\u00a0(explication) compl\u00e8te pour toutes les instructions SQL<\/li>\n<li>Signale et rejette \u00e9ventuellement les programmes violant les r\u00e8gles de qualit\u00e9<\/li>\n<li>Les contr\u00f4les peuvent \u00eatre d\u00e9clench\u00e9s \u00e0 la demande par les d\u00e9veloppeurs, directement dans leurs environnements de d\u00e9veloppement mainframe ou Eclipse, et automatiquement en mode batch lors des proc\u00e9dures de livraison.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 2&Prime; _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bboff\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_header title=\u00a0\u00bbDB\/IQ QA+ : Optimisation des requ\u00eates SQL dynamiques\u00a0\u00bb button_one_text=\u00a0\u00bbEn savoir plus\u00a0\u00bb button_one_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/db-iq-quality-assurance\/\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2025\/03\/Page-DBIQ-QA-7.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3&Prime; title_text_color=\u00a0\u00bb#2ea3f2&Prime; content_text_color=\u00a0\u00bb#000000&Prime; background_enable_color=\u00a0\u00bboff\u00a0\u00bb custom_button_one=\u00a0\u00bbon\u00a0\u00bb button_one_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb button_one_bg_color=\u00a0\u00bb#2ea3f2&Prime; link_option_url_new_window=\u00a0\u00bbon\u00a0\u00bb hover_enabled=\u00a0\u00bb0&Prime; global_colors_info=\u00a0\u00bb{}\u00a0\u00bb sticky_enabled=\u00a0\u00bb0&Prime;]<\/p>\n<div class=\"et_pb_header_content_wrapper\">\n<div class=\"et_pb_header_content_wrapper\">\n<p data-start=\"60\" data-end=\"771\" data-is-last-node=\"\">La solution\u00a0<strong>DB\/IQ QA+<\/strong>\u00a0analyse en profondeur les requ\u00eates SQL dynamiques en \u00e9valuant leur co\u00fbt, les jointures, les tris, les chemins d\u2019acc\u00e8s, le temps d\u2019ex\u00e9cution, l\u2019utilisation du\u00a0<strong>CPU<\/strong>\u00a0et le nombre de\u00a0<strong>GETPAGE<\/strong>. Il identifie les requ\u00eates les plus consommatrices afin de diagnostiquer les probl\u00e8mes de performance et surveille en temps r\u00e9el l\u2019activit\u00e9 SQL des applications critiques. En mesurant l\u2019\u00e9volution de la qualit\u00e9 des requ\u00eates sur une p\u00e9riode donn\u00e9e, il permet d\u2019anticiper les impacts des mises \u00e0 jour de\u00a0<strong>Db2<\/strong>\u00a0sur les chemins d\u2019ex\u00e9cution. Gr\u00e2ce \u00e0 une comparaison automatique des performances entre diff\u00e9rentes versions d\u2019une requ\u00eate,\u00a0<strong>DB\/IQ QA+<\/strong>\u00a0garantit une optimisation continue et une stabilit\u00e9 accrue des applications.<\/p>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 3&Prime; _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bbon\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_header title=\u00a0\u00bbDB\/IQ PM : la Gestion des Packages Applicatifs\u00a0\u00bb text_orientation=\u00a0\u00bbright\u00a0\u00bb button_one_text=\u00a0\u00bbEn savoir plus\u00a0\u00bb button_one_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/db-iq-package-management\/\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-2.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3&Prime; title_text_align=\u00a0\u00bbleft\u00a0\u00bb title_text_color=\u00a0\u00bb#2ea3f2&Prime; content_text_color=\u00a0\u00bb#000000&Prime; background_enable_color=\u00a0\u00bboff\u00a0\u00bb custom_button_one=\u00a0\u00bbon\u00a0\u00bb button_one_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb button_one_bg_color=\u00a0\u00bb#2ea3f2&Prime; link_option_url_new_window=\u00a0\u00bbon\u00a0\u00bb custom_css_free_form=\u00a0\u00bb.et_pb_bg_layout_dark h3 {||    text-align: left;||}||||.et_pb_fullwidth_header .et_pb_fullwidth_header_container .header-content a.et_pb_button {||    background-color:  #2ea3f2 !important;||    color: white !important;||}\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<div class=\"et_pb_module et_pb_text et_pb_text_2  et_pb_text_align_left et_pb_bg_layout_light\">\n<div class=\"et_pb_text_inner\">\n<p data-start=\"0\" data-end=\"484\">La solution\u00a0<strong data-start=\"0\" data-end=\"20\">DB\/IQ Package Management for Db2<\/strong>\u00a0permet de r\u00e9pondre \u00e0 la probl\u00e9matique de l\u2019\u00e9volution constante de Db2 et des nombreux changements quotidiens. En effet, la gestion des liaisons statiques est devenue de plus en plus complexe. Pour all\u00e9ger cette contrainte, la fonction\u00a0<strong data-start=\"212\" data-end=\"228\">BIND PACKAGE<\/strong>\u00a0a \u00e9t\u00e9 introduite afin d\u2019automatiser la gestion des versions. Cependant, cette approche a entra\u00een\u00e9 une croissance exponentielle des catalogues Db2, rendant leur gestion difficile et ralentissant les processus BIND en raison de tables Explain surcharg\u00e9es.<\/p>\n<p data-start=\"486\" data-end=\"740\" data-is-last-node=\"\"><strong data-start=\"486\" data-end=\"498\">DB\/IQ PM<\/strong>\u00a0simplifie cette gestion en identifiant et supprimant les paquets inutilis\u00e9s, puis en r\u00e9organisant le catalogue Db2. R\u00e9sultat : un catalogue all\u00e9g\u00e9, structur\u00e9 et optimis\u00e9, lib\u00e9r\u00e9 des paquets redondants pour des applications plus performantes.<\/p>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 4&Prime; _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bbon\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_header title=\u00a0\u00bbDB\/IQ WL : Simulation avanc\u00e9e des volumes de donn\u00e9es\u00a0\u00bb button_one_text=\u00a0\u00bbDemander une d\u00e9mo\u00a0\u00bb button_one_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/demo\/\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-4.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3&Prime; title_text_color=\u00a0\u00bb#2ea3f2&Prime; content_text_color=\u00a0\u00bb#000000&Prime; background_enable_color=\u00a0\u00bboff\u00a0\u00bb custom_button_one=\u00a0\u00bbon\u00a0\u00bb button_one_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb button_one_bg_color=\u00a0\u00bb#2ea3f2&Prime; link_option_url_new_window=\u00a0\u00bbon\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<div class=\"et_pb_header_content_wrapper\">\n<p data-start=\"60\" data-end=\"768\" data-is-last-node=\"\">La solution\u00a0<strong>DB\/IQ WorkLoad Detector<\/strong>\u00a0anticipe le comportement des applications en simulant les volumes de donn\u00e9es via la manipulation des valeurs\u00a0<strong data-start=\"170\" data-end=\"182\">RUNSTATS<\/strong>. Il permet de reproduire les conditions de production dans les environnements de qualification et de d\u00e9veloppement, d\u2019anticiper l\u2019impact d\u2019une augmentation des donn\u00e9es et de g\u00e9n\u00e9rer des statistiques adapt\u00e9es aux nouveaux projets pour optimiser les performances d\u00e8s le d\u00e9part.<\/p>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 5&Prime; _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bboff\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_header title=\u00a0\u00bbDB\/IQ IA : Optimisation avanc\u00e9e des Index\u00a0\u00bb text_orientation=\u00a0\u00bbright\u00a0\u00bb button_one_text=\u00a0\u00bbEn savoir plus\u00a0\u00bb button_one_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-5.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3&Prime; title_text_align=\u00a0\u00bbleft\u00a0\u00bb title_text_color=\u00a0\u00bb#2ea3f2&Prime; content_text_color=\u00a0\u00bb#000000&Prime; background_enable_color=\u00a0\u00bboff\u00a0\u00bb custom_button_one=\u00a0\u00bbon\u00a0\u00bb button_one_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb button_one_bg_color=\u00a0\u00bb#2ea3f2&Prime; link_option_url_new_window=\u00a0\u00bbon\u00a0\u00bb custom_css_free_form=\u00a0\u00bb.et_pb_bg_layout_dark h3 {||    text-align: left;||}||||.et_pb_fullwidth_header .et_pb_fullwidth_header_container .header-content a.et_pb_button {||    background-color:  #2ea3f2 !important;||    color: white !important;||}\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<div class=\"et_pb_module et_pb_text et_pb_text_2  et_pb_text_align_left et_pb_bg_layout_light\">\n<div class=\"et_pb_text_inner\">\n<div class=\"et_pb_module et_pb_text et_pb_text_10  et_pb_text_align_left et_pb_bg_layout_light\">\n<div class=\"et_pb_text_inner\">\n<p data-start=\"70\" data-end=\"316\">La solution\u00a0<strong>DB\/IQ Index Administrator<\/strong>\u00a0analyse en profondeur l\u2019ensemble de l\u2019activit\u00e9 SQL afin d\u2019\u00e9valuer la pertinence des index existants sur les tables Db2 et d\u2019identifier des optimisations en sugg\u00e9rant de nouvelles colonnes cl\u00e9s pour des index plus performants.<\/p>\n<ul data-start=\"318\" data-end=\"946\">\n<li data-start=\"318\" data-end=\"529\"><strong data-start=\"320\" data-end=\"349\">Analyse exhaustive du SQL<\/strong>\u00a0: prend en compte l\u2019ensemble des requ\u00eates SQL associ\u00e9es \u00e0 une table, qu\u2019il s\u2019agisse de SQL statique issu du catalogue Db2 ou de SQL dynamique extrait des traces ou du cache Db2.<\/li>\n<li data-start=\"530\" data-end=\"760\"><strong data-start=\"532\" data-end=\"564\">Pond\u00e9ration des applications<\/strong>\u00a0: hi\u00e9rarchise automatiquement l\u2019importance des applications en fonction de leur fr\u00e9quence d\u2019ex\u00e9cution ou permet une pond\u00e9ration manuelle bas\u00e9e sur des crit\u00e8res m\u00e9tier d\u00e9finis par l\u2019utilisateur.<\/li>\n<li data-start=\"761\" data-end=\"946\"><strong data-start=\"763\" data-end=\"796\">\u00c9valuation et recommandations<\/strong>\u00a0: examine l\u2019efficacit\u00e9 des index existants et identifie les colonnes optimales pour de nouveaux index, garantissant ainsi des performances accrues.<\/li>\n<\/ul>\n<p data-start=\"948\" data-end=\"1198\">Gr\u00e2ce \u00e0 ces analyses,\u00a0<strong>DB\/IQ IA<\/strong>\u00a0permet d\u2019\u00e9valuer pr\u00e9cis\u00e9ment l\u2019impact des index propos\u00e9s en identifiant les applications et requ\u00eates SQL qui en b\u00e9n\u00e9ficient le plus, tout en d\u00e9tectant des r\u00e9gressions de performance li\u00e9es aux nouveaux index.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 6&Prime; _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bbon\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_header title=\u00a0\u00bbDB\/IQ QA &#8211; plug-in Eclipse : Contr\u00f4le Qualit\u00e9 Int\u00e9gr\u00e9 pour le D\u00e9veloppement SQL sous Db2&Prime; button_one_text=\u00a0\u00bbDemander une d\u00e9mo\u00a0\u00bb button_one_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/demo\/\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-3.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3&Prime; title_text_color=\u00a0\u00bb#2ea3f2&Prime; content_text_color=\u00a0\u00bb#000000&Prime; background_enable_color=\u00a0\u00bboff\u00a0\u00bb custom_button_one=\u00a0\u00bbon\u00a0\u00bb button_one_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb button_one_bg_color=\u00a0\u00bb#2ea3f2&Prime; link_option_url_new_window=\u00a0\u00bbon\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<div class=\"et_pb_header_content_wrapper\">\n<p data-start=\"60\" data-end=\"768\" data-is-last-node=\"\">La solution\u00a0<strong>DB\/IQ QA-E<\/strong>\u00a0est un plug-in Eclipse con\u00e7u pour assurer le contr\u00f4le qualit\u00e9 des d\u00e9veloppements\u00a0<strong>SQL<\/strong>\u00a0en environnement\u00a0<strong>Db2<\/strong>. Enti\u00e8rement compatible avec\u00a0<strong>RDz\u00ae<\/strong>, il permet de standardiser les pratiques de d\u00e9veloppement en dehors du mainframe. Il offre un contr\u00f4le qualit\u00e9 interactif gr\u00e2ce \u00e0 plus de\u00a0<strong>300 r\u00e8gles de validation<\/strong>, ainsi qu\u2019une fonctionnalit\u00e9\u00a0<strong>EXPLAIN<\/strong>\u00a0d\u00e9taill\u00e9e, incluant le support des tables\u00a0<strong>EXPLAIN<\/strong>\u00a0cach\u00e9es. Les d\u00e9veloppeurs peuvent ainsi analyser en temps r\u00e9el les chemins d\u2019acc\u00e8s\u00a0<strong>Db2<\/strong>, mesurer l\u2019impact des volumes de donn\u00e9es et des scans, et comparer facilement les performances\u00a0<strong>SQL<\/strong>. En int\u00e9grant ces fonctionnalit\u00e9s directement dans\u00a0<strong>Eclipse<\/strong>,\u00a0<strong>DB\/IQ QA-E<\/strong>\u00a0renforce la ma\u00eetrise des bonnes pratiques SQL et am\u00e9liore la qualit\u00e9 des d\u00e9veloppements sans quitter l\u2019environnement\u00a0<strong>IDE<\/strong>\u200b.<\/p>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1&Prime; fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 7&Prime; _builder_version=\u00a0\u00bb4.27.0&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb da_disable_devices=\u00a0\u00bboff|off|off\u00a0\u00bb locked=\u00a0\u00bboff\u00a0\u00bb collapsed=\u00a0\u00bboff\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb da_is_popup=\u00a0\u00bboff\u00a0\u00bb da_exit_intent=\u00a0\u00bboff\u00a0\u00bb da_has_close=\u00a0\u00bbon\u00a0\u00bb da_alt_close=\u00a0\u00bboff\u00a0\u00bb da_dark_close=\u00a0\u00bboff\u00a0\u00bb da_not_modal=\u00a0\u00bbon\u00a0\u00bb da_is_singular=\u00a0\u00bboff\u00a0\u00bb da_with_loader=\u00a0\u00bboff\u00a0\u00bb da_has_shadow=\u00a0\u00bbon\u00a0\u00bb][et_pb_fullwidth_header title=\u00a0\u00bbEn bref !\u00a0\u00bb text_orientation=\u00a0\u00bbright\u00a0\u00bb button_one_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/demo\/\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2025\/03\/Page-X-bref.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3&Prime; title_text_align=\u00a0\u00bbleft\u00a0\u00bb title_text_color=\u00a0\u00bb#2ea3f2&Prime; content_text_color=\u00a0\u00bb#000000&Prime; background_enable_color=\u00a0\u00bboff\u00a0\u00bb custom_button_one=\u00a0\u00bbon\u00a0\u00bb button_one_text_color=\u00a0\u00bb#FFFFFF\u00a0\u00bb button_one_bg_color=\u00a0\u00bb#2ea3f2&Prime; link_option_url_new_window=\u00a0\u00bbon\u00a0\u00bb custom_css_free_form=\u00a0\u00bb.et_pb_bg_layout_dark h3 {||    text-align: left;||}||||.et_pb_fullwidth_header .et_pb_fullwidth_header_container .header-content a.et_pb_button {||    background-color:  #2ea3f2 !important;||    color: white !important;||}\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<ul>\n<li data-start=\"17\" data-end=\"118\">Assure l\u2019application des\u00a0<strong data-start=\"44\" data-end=\"54\">normes<\/strong>\u00a0et des\u00a0<strong data-start=\"62\" data-end=\"76\">directives<\/strong>\u00a0en vigueur pour un parc applicatif Db2.<\/li>\n<li data-start=\"119\" data-end=\"248\">Identifie et signale les requ\u00eates\u00a0<strong data-start=\"155\" data-end=\"177\">SQL probl\u00e9matiques<\/strong>\u00a0afin d\u2019anticiper les risques de\u00a0<strong data-start=\"210\" data-end=\"225\">performance<\/strong>\u00a0et de\u00a0<strong data-start=\"232\" data-end=\"245\">fiabilit\u00e9<\/strong>.<\/li>\n<li data-start=\"249\" data-end=\"399\">Garantit la\u00a0<strong data-start=\"263\" data-end=\"277\">conformit\u00e9<\/strong>\u00a0du code SQL livr\u00e9 en\u00a0<strong data-start=\"299\" data-end=\"313\">production<\/strong>, qu\u2019il soit statique ou dynamique, en assurant le respect des standards de qualit\u00e9.<\/li>\n<li data-start=\"400\" data-end=\"569\">Accompagne les d\u00e9veloppeurs Db2 dans l\u2019<strong data-start=\"441\" data-end=\"457\">optimisation<\/strong>\u00a0de leurs programmes gr\u00e2ce \u00e0 des messages d\u2019aide personnalisables et des indicateurs de performance d\u00e9taill\u00e9s.<\/li>\n<li data-start=\"570\" data-end=\"719\">R\u00e9duit la charge des responsables applicatifs et des\u00a0<strong data-start=\"625\" data-end=\"633\">DBAs<\/strong>\u00a0en automatisant le contr\u00f4le des ordres SQL tout au long du cycle de vie applicatif.<\/li>\n<li data-start=\"720\" data-end=\"909\">Compatible avec les pratiques\u00a0<strong data-start=\"752\" data-end=\"762\">DevOps<\/strong>, il int\u00e8gre des outils d\u2019audit permettant d\u2019\u00e9valuer r\u00e9guli\u00e8rement la qualit\u00e9 des applications et d\u2019assurer un suivi rigoureux de leur \u00e9volution.<\/li>\n<li data-start=\"910\" data-end=\"1079\" data-is-last-node=\"\"><strong data-start=\"912\" data-end=\"963\">B\u00e9n\u00e9ficiez du support et de l\u2019expertise Infotel<\/strong>, un leader en gestion et optimisation des donn\u00e9es\u00a0<strong data-start=\"1014\" data-end=\"1027\" data-is-only-node=\"\">Mainframe<\/strong>, avec un accompagnement technique de haut niveau.<\/li>\n<\/ul>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Assurez la qualit\u00e9 et la performance des applications SQL Db2 V\u00e9rifiez que les applications SQL Db2 respectent vos r\u00e8gles de qualit\u00e9\u00c9valuez si les chemins d\u2019acc\u00e8s aux donn\u00e9es sont efficacesD\u00e9terminez les meilleures strat\u00e9gies indiciellesContr\u00f4lez l\u2019ex\u00e9cution des requ\u00eates Db2 m\u00eame en dynamiqueDB\/IQ est un ensemble de solutions pour garantir la qualit\u00e9 et la performance de vos requ\u00eates [&hellip;]<\/p>\n","protected":false},"author":34,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"<!-- wp:image {\"sizeSlug\":\"large\"} -->\r\n<figure class=\"wp-block-image size-large\"><img src=\"https:\/\/us-infotel.dev.infotel.com\/wp-content\/uploads\/2022\/05\/joel-filipe-jU9VAZDGMzs-unsplash-scaled.jpg\" alt=\"\"\/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:paragraph -->\r\n<p><\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:heading {\"textAlign\":\"left\"} -->\r\n<h2 class=\"has-text-align-left\"><span style=\"color: #000000;\" class=\"stk-highlight\">Ensure the quality and performance of SQL Db2 applications<\/span><\/h2>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:ugb\/container {\"contentWidth\":100,\"contentVerticalAlign\":\"center\",\"borderRadius\":0,\"shadow\":0,\"columnBackgroundColor\":\"transparent\",\"columnBackgroundTintStrength\":5,\"columnBackgroundGradientDirection\":0,\"columnFixedBackground\":false,\"uniqueClass\":\"ugb-b0b6dee\",\"paddingTop\":0,\"paddingRight\":0,\"paddingBottom\":0,\"paddingLeft\":0,\"className\":\"row-full\"} -->\r\n<div class=\"wp-block-ugb-container ugb-container row-full ugb-b0b6dee ugb-container--v2 ugb-container--design-basic ugb-main-block\"><style>.ugb-b0b6dee-wrapper.ugb-container__wrapper{border-radius:0px !important;background-color:transparent !important}.ugb-b0b6dee-wrapper.ugb-container__wrapper:before{background-color:transparent !important}.ugb-b0b6dee-content-wrapper > h1,.ugb-b0b6dee-content-wrapper > h2,.ugb-b0b6dee-content-wrapper > h3,.ugb-b0b6dee-content-wrapper > h4,.ugb-b0b6dee-content-wrapper > h5,.ugb-b0b6dee-content-wrapper > h6{color:#222222}.ugb-b0b6dee-content-wrapper > p,.ugb-b0b6dee-content-wrapper > ol li,.ugb-b0b6dee-content-wrapper > ul li{color:#222222}@media screen and (min-width:768px){.ugb-b0b6dee-content-wrapper.ugb-container__content-wrapper{width:100% !important}.ugb-b0b6dee.ugb-container{padding-top:0px !important;padding-right:0px !important;padding-bottom:0px !important;padding-left:0px !important}}<\/style><div class=\"ugb-inner-block\"><div class=\"ugb-block-content\"><div class=\"ugb-container__wrapper ugb-b0b6dee-wrapper ugb--shadow-0\"><div class=\"ugb-container__side\"><div class=\"ugb-container__content-wrapper ugb-b0b6dee-content-wrapper\"><!-- wp:stackable\/spacer {\"uniqueId\":\"fcb3dc1\",\"height\":0} -->\r\n<div class=\"wp-block-stackable-spacer stk-block-spacer stk--no-padding stk-block stk-fcb3dc1\" data-block-id=\"fcb3dc1\"><style>.stk-fcb3dc1{height:0px !important}<\/style><\/div>\r\n<!-- \/wp:stackable\/spacer -->\r\n\r\n<!-- wp:table -->\r\n<figure class=\"wp-block-table\"><table><tbody><tr><td>CHECK THAT SQL DB2 APPLICATIONS RESPECT YOUR QUALITY RULES<\/td><td>EVALUATE WHETHER THE DATA ACCESS PATHS ARE EFFICIENT<\/td><td>FIND THE BEST INDEXMONITOR THE EXECUTION OF DB2 QUERIES STRATEGIES<\/td><td>MONITOR THE EXECUTION OF DB2 QUERIES<\/td><\/tr><\/tbody><\/table><\/figure>\r\n<!-- \/wp:table -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>DB\/IQ is a software solution designed to assess and improve the level of quality and maintainability of Db2 for z\/OS applications before they get deployed in your production environment. DB\/IQ automates the quality control process according to performance, maintainability and scalability criteria.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:image {\"sizeSlug\":\"large\"} -->\r\n<figure class=\"wp-block-image size-large\"><img src=\"https:\/\/us-infotel.dev.infotel.com\/wp-content\/uploads\/2022\/05\/christian-perner-fYO1T495QCM-unsplash-scaled.jpg\" alt=\"\"\/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading -->\r\n<h2>Quality checks<\/h2>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>DB\/IQ analyzes and performs checks on all SQL code; whether in source form, in a DBRM resulting from the Db2 pre-processor, in all Catalog-based SQL (plans, packages, views, MQTs, triggers etc.) or as dynamically executed SQL.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><li>Check the quality of any SQL code according to organization-defined standards.<\/li><li>More than 350 quality rules are available \u201cout-of-the-box\u201d and can be customized according to your requirements and SLAs.<\/li><li>Provide developers interactive quality control and full EXPLAIN functionality for all SQL statements.<\/li><li>Alerts and possibly rejects programs that violate quality rules.<\/li><li>Controls can be triggered on demand by developers, directly in their mainframe or Eclipse development environments, and automatically in batch mode during delivery procedures.<\/li><\/ul>\r\n<!-- \/wp:list -->\r\n\r\n<!-- wp:image {\"sizeSlug\":\"large\"} -->\r\n<figure class=\"wp-block-image size-large\"><img src=\"https:\/\/us-infotel.dev.infotel.com\/wp-content\/uploads\/2022\/05\/luca-bravo-SRjZtxsK3Os-unsplash-scaled.jpg\" alt=\"\"\/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading -->\r\n<h2>Package Management<\/h2>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>DB\/IQ Package Management for Db2 (PM) \u2013 Early Db2 installations implemented the BIND strategy for plans and associated DBRMs with static linking of all applications. With so many daily Db2 changes, the static linking created great complexity for the Catalog and auto-versioning was put in place with \u201cBIND PACKAGE\u201d function alleviate the complexity. The auto-versioning however, caused Db2 Catalogs to grow exponentially to an unmanageable state where very large Explain tables slow down BINDs.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>DB\/IQ PM helps reduce this complexity by identifying unlinked packages, removing them then reorganizing the Db2 Catalog. The result is a cleaner Db2 Catalog, free of redundant packages and streamlined for better application performance.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><li>Cleans up the Db2 Catalog by discarding non-required packages \u2013 even in Change Management Systems \u2013 delivering streamlined application performance for better EUX<\/li><li>Reduces mainframe budget churn<\/li><li>Assists DBAs to easily build jobs and keep a cleaner, more efficient Db2 Catalog<\/li><li>Minimizes all general commonly used gigantic Explain tables<\/li><li>Avoids all -805\/-818 (timestamp mismatch) problems by locating inconsistencies between DBRMs packages and corresponding load modules<\/li><\/ul>\r\n<!-- \/wp:list -->\r\n\r\n<!-- wp:image {\"sizeSlug\":\"large\"} -->\r\n<figure class=\"wp-block-image size-large\"><img src=\"https:\/\/us-infotel.dev.infotel.com\/wp-content\/uploads\/2022\/05\/anders-jilden-Sc5RKXLBjGg-unsplash.jpg\" alt=\"\"\/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading -->\r\n<h2>Ensure the quality and performance of SQL Db2 applications<\/h2>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p><strong>Audit Db2 applications<\/strong><\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>DB\/IQ benchmarks all SQL statements, whether they are static or dynamic, according to cost factors, joins, sorts, access patch, elapse time, CPU, number of GETPAGEs and much more.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><li>Diagnoses the cause of performance issues by identifying the most consuming queries<\/li><li>Monitors all or just SQL activities of named applications<\/li><li>Measures the evolution of quality over a period of time<\/li><li>Automatically compares the quality of a SQL query with its previous version<\/li><li>Automatically assesses the impact of Db2 release upgrades on your application paths<\/li><\/ul>\r\n<!-- \/wp:list -->\r\n\r\n<!-- wp:image {\"sizeSlug\":\"large\"} -->\r\n<figure class=\"wp-block-image size-large\"><img src=\"https:\/\/us-infotel.dev.infotel.com\/wp-content\/uploads\/2022\/05\/luca-bravo-alS7ewQ41M8-unsplash-scaled.jpg\" alt=\"\"\/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading -->\r\n<h2>Simulate data volume<\/h2>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>DB\/IQ simulates data volumes present in your database tables by manipulating RUNSTATS values responsible for Db2\u2019s access path selection.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><li>Anticipates the behavior of your applications without having the production data volumes in the tables<\/li><li>Copy the RUNSTATS values from your production environments to your qualification and development environment<\/li><li>Manipulates RUNSTATS values to anticipate an increase in volumes<\/li><\/ul>\r\n<!-- \/wp:list -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>For new projects, generates RUNSTATS values from scratch based on your volume estimates<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:image {\"sizeSlug\":\"large\"} -->\r\n<figure class=\"wp-block-image size-large\"><img src=\"https:\/\/us-infotel.dev.infotel.com\/wp-content\/uploads\/2022\/05\/julien-moreau-688Fna1pwOQ-unsplash-scaled.jpg\" alt=\"\"\/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading -->\r\n<h2>Index optimization<\/h2>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>DB\/IQ analyses the entire SQL activity to evaluate if existing indexes on Db2 tables are relevant and if other columns would make more efficient indexes.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><li>Examines all SQL related to a table, whether it is static SQL found in the Db2 catalog or dynamic SQL extracted from traces or the Db2 cache<\/li><li>Weight the importance of each application either automatically according to its execution frequency or manually according to a Business-Value set by user.<\/li><li>Assesses the relevance of existing indexes<\/li><li>Identifies potential index key column candidates automatically<\/li><\/ul>\r\n<!-- \/wp:list -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Analyzes index impact, showing which index application and SQL profit most and if any deteriorate from the new index<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:columns {\"className\":\"has-4-columns\"} -->\r\n<div class=\"wp-block-columns has-4-columns\"><!-- wp:column -->\r\n<div class=\"wp-block-column\"><\/div>\r\n<!-- \/wp:column -->\r\n\r\n<!-- wp:column -->\r\n<div class=\"wp-block-column\"><\/div>\r\n<!-- \/wp:column --><\/div>\r\n<!-- \/wp:columns --><\/div><\/div><\/div><\/div><\/div><\/div>\r\n<!-- \/wp:ugb\/container -->\r\n\r\n<!-- wp:spacer {\"height\":\"10px\"} -->\r\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n<!-- \/wp:spacer -->","_et_gb_content_width":"","footnotes":""},"class_list":["post-22557","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Insoft Infotel | Experts in mainframe performance and optimization<\/title>\n<meta name=\"description\" content=\"Insoft Infotel helps customers thrive in the digital age with smart software solutions that optimize and improve z\/OS usage and costs.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/infotel-software.com\/fr\/db-iq\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Insoft Infotel | Experts in mainframe performance and optimization\" \/>\n<meta property=\"og:description\" content=\"Insoft Infotel helps customers thrive in the digital age with smart software solutions that optimize and improve z\/OS usage and costs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/infotel-software.com\/fr\/db-iq\/\" \/>\n<meta property=\"og:site_name\" content=\"Infotel Software\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-17T13:34:38+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/infotel-software.com\/fr\/db-iq\/\",\"url\":\"https:\/\/infotel-software.com\/fr\/db-iq\/\",\"name\":\"Insoft Infotel | Experts in mainframe performance and optimization\",\"isPartOf\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/#website\"},\"datePublished\":\"2022-06-24T09:33:40+00:00\",\"dateModified\":\"2026-02-17T13:34:38+00:00\",\"description\":\"Insoft Infotel helps customers thrive in the digital age with smart software solutions that optimize and improve z\/OS usage and costs.\",\"breadcrumb\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/db-iq\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/infotel-software.com\/fr\/db-iq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/infotel-software.com\/fr\/db-iq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/infotel-software.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB\/IQ \u2013 Qualit\u00e9 et Performances Db2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/infotel-software.com\/fr\/#website\",\"url\":\"https:\/\/infotel-software.com\/fr\/\",\"name\":\"Insoft Infotel\",\"description\":\"Maximize Performance, Optimize Costs\",\"publisher\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/infotel-software.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/infotel-software.com\/fr\/#organization\",\"name\":\"Insoft Infotel\",\"url\":\"https:\/\/infotel-software.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/infotel-software.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/06\/logo-insoft-infotel-1.png\",\"contentUrl\":\"https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/06\/logo-insoft-infotel-1.png\",\"width\":1278,\"height\":358,\"caption\":\"Insoft Infotel\"},\"image\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Insoft Infotel | Experts in mainframe performance and optimization","description":"Insoft Infotel helps customers thrive in the digital age with smart software solutions that optimize and improve z\/OS usage and costs.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/infotel-software.com\/fr\/db-iq\/","og_locale":"fr_FR","og_type":"article","og_title":"Insoft Infotel | Experts in mainframe performance and optimization","og_description":"Insoft Infotel helps customers thrive in the digital age with smart software solutions that optimize and improve z\/OS usage and costs.","og_url":"https:\/\/infotel-software.com\/fr\/db-iq\/","og_site_name":"Infotel Software","article_modified_time":"2026-02-17T13:34:38+00:00","twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/infotel-software.com\/fr\/db-iq\/","url":"https:\/\/infotel-software.com\/fr\/db-iq\/","name":"Insoft Infotel | Experts in mainframe performance and optimization","isPartOf":{"@id":"https:\/\/infotel-software.com\/fr\/#website"},"datePublished":"2022-06-24T09:33:40+00:00","dateModified":"2026-02-17T13:34:38+00:00","description":"Insoft Infotel helps customers thrive in the digital age with smart software solutions that optimize and improve z\/OS usage and costs.","breadcrumb":{"@id":"https:\/\/infotel-software.com\/fr\/db-iq\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/infotel-software.com\/fr\/db-iq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/infotel-software.com\/fr\/db-iq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/infotel-software.com\/fr\/"},{"@type":"ListItem","position":2,"name":"DB\/IQ \u2013 Qualit\u00e9 et Performances Db2"}]},{"@type":"WebSite","@id":"https:\/\/infotel-software.com\/fr\/#website","url":"https:\/\/infotel-software.com\/fr\/","name":"Insoft Infotel","description":"Maximize Performance, Optimize Costs","publisher":{"@id":"https:\/\/infotel-software.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/infotel-software.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/infotel-software.com\/fr\/#organization","name":"Insoft Infotel","url":"https:\/\/infotel-software.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/infotel-software.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/06\/logo-insoft-infotel-1.png","contentUrl":"https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/06\/logo-insoft-infotel-1.png","width":1278,"height":358,"caption":"Insoft Infotel"},"image":{"@id":"https:\/\/infotel-software.com\/fr\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/pages\/22557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/comments?post=22557"}],"version-history":[{"count":14,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/pages\/22557\/revisions"}],"predecessor-version":[{"id":26494,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/pages\/22557\/revisions\/26494"}],"wp:attachment":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/media?parent=22557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}