{"id":23446,"date":"2025-06-13T10:31:22","date_gmt":"2025-06-13T08:31:22","guid":{"rendered":"https:\/\/infotel-software.com\/db-iq-index-administrator\/"},"modified":"2026-02-17T14:28:43","modified_gmt":"2026-02-17T13:28:43","slug":"db-iq-index-administrator","status":"publish","type":"page","link":"https:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/","title":{"rendered":"DB\/IQ Index Administrator"},"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\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_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 Index Administrator\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; 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\u00bbOptimisation intelligente et continue des index Db2\u00ae\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-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; custom_padding_tablet=\u00a0\u00bb\u00a0\u00bb custom_padding_phone=\u00a0\u00bb0px||||false|false\u00a0\u00bb custom_padding_last_edited=\u00a0\u00bbon|phone\u00a0\u00bb 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><strong>DB\/IQ Index Administrator<\/strong>\u00a0est un module de la suite DB\/IQ d\u00e9di\u00e9 \u00e0 l\u2019optimisation automatique des index Db2\u00ae for z\/OS. Il analyse en continu les workloads pour identifier les index sur- ou sous-utilis\u00e9s, redondants ou obsol\u00e8tes, et fournit des recommandations bas\u00e9es sur l\u2019usage r\u00e9el.<\/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 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\u00bbFonctionnalit\u00e9s principales\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\/2025\/06\/Page-DBIQ-IA-1.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<ul>\n<li>Identification automatique des\u00a0<strong>index non pertinents<\/strong><\/li>\n<li><strong>Recommandation et cr\u00e9ation dynamique<\/strong>\u00a0des index les plus adapt\u00e9s<\/li>\n<li><strong>Analyse des acc\u00e8s<\/strong>\u00a0: visualiser quels programmes et requ\u00eates SQL acc\u00e8dent \u00e0 quels objets\/colonnes, et inversement<\/li>\n<li><strong>Suggestion de colonnes candidates<\/strong>\u00a0\u00e0 l\u2019indexation<\/li>\n<li><strong>Simulation d\u2019impact<\/strong>\u00a0: analyser et comparer les effets de nouveaux index<\/li>\n<li><strong>\u00c9valuation personnalis\u00e9e<\/strong>\u00a0des sc\u00e9narios \u00e0 l\u2019aide de\u00a0<strong>facteurs de poids d\u00e9finis par l\u2019utilisateur<\/strong><\/li>\n<li><strong>Nettoyage du catalogue DB2<\/strong>\u00a0: suppression des index inutiles avec\u00a0<strong>simulation via index virtuel<\/strong><\/li>\n<\/ul>\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\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\u00bbB\u00e9n\u00e9fices cl\u00e9s\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\/06\/Page-DBIQ-IA-2.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<ul>\n<li><strong>Meilleures performances<\/strong>\u00a0gr\u00e2ce \u00e0 une indexation optimis\u00e9e<\/li>\n<li><strong>R\u00e9duction des co\u00fbts<\/strong>\u00a0en \u00e9liminant les index inutiles<\/li>\n<li><strong>Gain de temps<\/strong>\u00a0via l\u2019automatisation des recommandations et simulations<\/li>\n<li><strong>Visibilit\u00e9 accrue<\/strong>\u00a0sur l\u2019usage r\u00e9el des donn\u00e9es SQL<\/li>\n<li><strong>D\u00e9cisions \u00e9clair\u00e9es<\/strong>\u00a0gr\u00e2ce aux simulations d\u2019impact<\/li>\n<li><strong>Alignement m\u00e9tier<\/strong>\u00a0avec des crit\u00e8res personnalis\u00e9s<\/li>\n<li><strong>Moins de maintenance<\/strong>\u00a0et plus de stabilit\u00e9 dans le temps<\/li>\n<\/ul>\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.4&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\u00bbQuel probl\u00e8me cela r\u00e9sout ?\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; custom_padding_tablet=\u00a0\u00bb\u00a0\u00bb custom_padding_phone=\u00a0\u00bb0px||||false|false\u00a0\u00bb custom_padding_last_edited=\u00a0\u00bbon|phone\u00a0\u00bb link_option_url_new_window=\u00a0\u00bbon\u00a0\u00bb hover_enabled=\u00a0\u00bb0&Prime; 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 sticky_enabled=\u00a0\u00bb0&Prime;]<\/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><strong>En deux mots :<\/strong> <strong>optimisation d\u2019index.<\/strong><\/p>\n<p>DB\/IQ Index Administrator (IA+) aide les DBA \u00e0 <strong>concevoir les meilleurs index<\/strong> dans des environnements complexes \u2014 une t\u00e2che <strong>tr\u00e8s difficile \u00e0 r\u00e9aliser manuellement<\/strong>. Pour y parvenir, IA+ prend en compte <strong>la fa\u00e7on dont un objet (table) est acc\u00e9d\u00e9 par l\u2019ensemble des programmes<\/strong>, \u00e0 travers l\u2019activit\u00e9 SQL globale, y compris <strong>le SQL dynamique<\/strong> le cas \u00e9ch\u00e9ant.<\/p>\n<p><strong>Concept et fonctionnalit\u00e9s<\/strong><\/p>\n<p>L\u2019analyse d\u2019index est souvent <strong>chronophage et d\u00e9licate<\/strong> : elle impose de passer en revue le SQL d\u2019une application pour comprendre l\u2019utilisation des pr\u00e9dicats, tout en int\u00e9grant les <strong>priorit\u00e9s m\u00e9tier<\/strong>.<\/p>\n<p>Le processus est d\u2019autant plus lourd que <strong>toutes les applications qui r\u00e9f\u00e9rencent la table cible<\/strong> doivent \u00eatre analys\u00e9es et <strong>pond\u00e9r\u00e9es<\/strong> (transactions en ligne critiques, batch, reporting, etc.).<\/p>\n<p>IA+ examine <strong>l\u2019ensemble des SQL li\u00e9s \u00e0 une table<\/strong>, qu\u2019ils proviennent :<\/p>\n<ul>\n<li>d\u2019une analyse de charge avec <strong>SQL captur\u00e9s<\/strong> et <strong>fr\u00e9quences d\u2019ex\u00e9cution r\u00e9elles<\/strong>, ou<\/li>\n<li>de SQL issus d\u2019applications ex\u00e9cut\u00e9es plus rarement (par exemple un traitement hebdomadaire de plusieurs heures), m\u00eame si ces requ\u00eates sont moins fr\u00e9quentes.<\/li>\n<\/ul>\n<p>Dans les grandes organisations, cela peut repr\u00e9senter <strong>des milliers de requ\u00eates SQL<\/strong>. Les \u00e9quipes d\u2019administration et de d\u00e9veloppement ne disposent pas toujours des informations n\u00e9cessaires pour prendre des d\u00e9cisions d\u2019indexation aussi critiques.<\/p>\n<p>En pratique, la conception manuelle d\u2019index \u00e0 grande \u00e9chelle repose donc sur des <strong>DBA tr\u00e8s exp\u00e9riment\u00e9s<\/strong> \u2014 et IA+ apporte la m\u00e9thode et la visibilit\u00e9 n\u00e9cessaires pour rendre ce travail <strong>plus rapide, plus fiable et plus coh\u00e9rent<\/strong>.<\/p>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB\/IQ Index Administrator\u00a0est un module de la suite DB\/IQ d\u00e9di\u00e9 \u00e0 l\u2019optimisation automatique des index Db2\u00ae for z\/OS. Il analyse en continu les workloads pour identifier les index sur- ou sous-utilis\u00e9s, redondants ou obsol\u00e8tes, et fournit des recommandations bas\u00e9es sur l\u2019usage r\u00e9el. Identification automatique des\u00a0index non pertinents Recommandation et cr\u00e9ation dynamique\u00a0des index les plus adapt\u00e9s [&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 {\"id\":11221,\"sizeSlug\":\"full\",\"linkDestination\":\"none\"} -->\r\n<figure class=\"wp-block-image size-full\"><img src=\"https:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/PackMan-Triangle-500-500-420x420-1.png\" alt=\"\" class=\"wp-image-11221\"\/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading -->\r\n<h2>Deep Clean Your Db2 Catalog to Improve Backups and REORGs<\/h2>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>In today\u2019s high-paced mobile landscape where customers expect non-stop availability of applications, DevOps initiatives put pressure on development teams to roll out high-quality software with fast turnarounds and more frequent release cycles. In the sprint to build, test and deploy to tight deadlines and with countless changes being processed by the minute, overwhelmed teams don\u2019t have the bandwidth to consider the enormous build-up of packages inundating the Db2 Catalog \u2013 until that is, the clutter of unlinked modules delays subsystem services such as backups and REORGs.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>DB\/IQ Package Management (PackMan) helps manage the DevOps chaos by identifying redundant packages, removing them and reorganizing the Db2 Catalog. The result is a cleaner Db2 Catalog that is streamlined for more reliable application performance.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:image {\"id\":11222,\"sizeSlug\":\"full\",\"linkDestination\":\"none\"} -->\r\n<figure class=\"wp-block-image size-full\"><img src=\"https:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/einstein-infotel-420x420-1.png\" alt=\"\" class=\"wp-image-11222\"\/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading -->\r\n<h2>With DB\/IQ PackMan, you can:<\/h2>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:list -->\r\n<ul><li>Clean up the Db2 Catalog by discarding non-required packages. An absolute must, when implementing Change Management Systems within the DevOps method<\/li><li>Prompt DBAs to easily build jobs and keep a clean and efficient Db2 Catalog<\/li><li>Avoid all potential -805\/-818 problems by determining inconsistencies between DBRMs, associated packages and load modules<\/li><li>Make migration to production systems secure by determining any inconsistencies, before the BIND process takes place<\/li><li>Maintain EXPLAIN tables down to the required minimum.<\/li><li>Improve BIND times<\/li><li>Recreate DBRM members or libraries from Catalog packages<\/li><li>Prevent unnecessary BIND by comparing a new DBRM with its predecessor version.<\/li><\/ul>\r\n<!-- \/wp:list -->\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":"1080","footnotes":""},"class_list":["post-23446","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-index-administrator\/\" \/>\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-index-administrator\/\" \/>\n<meta property=\"og:site_name\" content=\"Infotel Software\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-17T13:28:43+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=\"3 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-index-administrator\/\",\"url\":\"https:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/\",\"name\":\"Insoft Infotel | Experts in mainframe performance and optimization\",\"isPartOf\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/#website\"},\"datePublished\":\"2025-06-13T08:31:22+00:00\",\"dateModified\":\"2026-02-17T13:28:43+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-index-administrator\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/infotel-software.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB\/IQ Index Administrator\"}]},{\"@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-index-administrator\/","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-index-administrator\/","og_site_name":"Infotel Software","article_modified_time":"2026-02-17T13:28:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/","url":"https:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/","name":"Insoft Infotel | Experts in mainframe performance and optimization","isPartOf":{"@id":"https:\/\/infotel-software.com\/fr\/#website"},"datePublished":"2025-06-13T08:31:22+00:00","dateModified":"2026-02-17T13:28:43+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-index-administrator\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/infotel-software.com\/fr\/db-iq-index-administrator\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/infotel-software.com\/fr\/"},{"@type":"ListItem","position":2,"name":"DB\/IQ Index Administrator"}]},{"@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\/23446","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=23446"}],"version-history":[{"count":2,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/pages\/23446\/revisions"}],"predecessor-version":[{"id":26485,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/pages\/23446\/revisions\/26485"}],"wp:attachment":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/media?parent=23446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}