{"id":22558,"date":"2022-06-24T11:33:40","date_gmt":"2022-06-24T09:33:40","guid":{"rendered":"https:\/\/infotel-software.com\/database-management\/"},"modified":"2025-07-03T10:47:26","modified_gmt":"2025-07-03T08:47:26","slug":"db-iq","status":"publish","type":"page","link":"https:\/\/infotel-software.com\/de\/db-iq\/","title":{"rendered":"DB\/IQ \u2013 Qualit\u00e4t und Leistung Db2"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Banni\u00e8re&#8220; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;on&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_slider _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; header_level=&#8220;h1&#8243; header_font_size=&#8220;60px&#8220; background_enable_color=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_slide heading=&#8220;DB\/IQ&#8220; use_bg_overlay=&#8220;on&#8220; use_text_overlay=&#8220;off&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; header_font=&#8220;Arial|700|||||||&#8220; header_font_size=&#8220;40px&#8220; background_enable_color=&#8220;off&#8220; use_background_color_gradient=&#8220;on&#8220; background_color_gradient_type=&#8220;circular&#8220; background_color_gradient_stops=&#8220;#2ea3f2 30%|#004f91 100%&#8220; background_enable_image=&#8220;off&#8220; header_font_size_tablet=&#8220;40px&#8220; header_font_size_phone=&#8220;24px&#8220; header_font_size_last_edited=&#8220;on|phone&#8220; custom_css_free_form=&#8220;.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;||}&#8220; global_colors_info=&#8220;{}&#8220; sticky_transition=&#8220;on&#8220;][\/et_pb_slide][\/et_pb_fullwidth_slider][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||14px||false|false&#8220; custom_padding=&#8220;0%||0px||false|false&#8220; da_disable_devices=&#8220;off|off|off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_row _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||14px||false|false&#8220; custom_padding=&#8220;||0px|||&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_text _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px|||||&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h3 style=\"text-align: center;\"><strong>Stellen Sie die Qualit\u00e4t und Leistung von SQL Db2-Anwendungen sicher<\/strong><\/h3>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8220;1_4,1_4,1_4,1_4&#8243; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column type=&#8220;1_4&#8243; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_image src=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/check-circle-regular.png&#8220; title_text=&#8220;check-circle-regular&#8220; align=&#8220;center&#8220; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; text_orientation=&#8220;center&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>\u00dcberpr\u00fcfen Sie, ob SQL Db2-Anwendungen Ihre Qualit\u00e4tsregeln einhalten<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;1_4&#8243; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_image src=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/medal-solid.png&#8220; title_text=&#8220;medal-solid&#8220; align=&#8220;center&#8220; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; text_orientation=&#8220;center&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Beurteilen Sie, ob die Datenpfade effizient sind<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;1_4&#8243; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_image src=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/search-solid.png&#8220; title_text=&#8220;search-solid&#8220; align=&#8220;center&#8220; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; text_orientation=&#8220;center&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Ermitteln Sie die besten Indexstrategien<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;1_4&#8243; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_image src=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2022\/06\/check-solid.png&#8220; title_text=&#8220;check-solid&#8220; align=&#8220;center&#8220; _builder_version=&#8220;4.17.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; text_orientation=&#8220;center&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Kontrollieren Sie die Ausf\u00fchrung von Db2-Abfragen<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Texte centr\u00e9&#8220; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_header module_class=&#8220;section-centre-blanc&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; content_font_size=&#8220;18px&#8220; custom_css_free_form=&#8220;h4 {||  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;||}&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h4 style=\"text-align: center;\">DB\/IQ ist eine L\u00f6sung, die die Qualit\u00e4t und Leistung Ihrer SQL-Abfragen, ob statisch oder dynamisch, gew\u00e4hrleisten und gleichzeitig die Belastung Ihrer z\/OS-Umgebung reduzieren.<\/h4>\n<h4 style=\"text-align: center;\">Die DB\/IQ-Suite umfasst die folgenden Module: DB\/IQ QA, QA+, PackMan, IA+, MA+, WL und das Eclipse-Plugin.<\/h4>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Bloc texte \/ Image 1&#8243; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_header title=&#8220;DB\/IQ QA: Qualit\u00e4tssicherung&#8220; text_orientation=&#8220;right&#8220; button_one_text=&#8220;Demo anfordern&#8220; button_one_url=&#8220;https:\/\/infotel-software.com\/de\/demo\/&#8220; header_image_url=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-1.png&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; title_level=&#8220;h3&#8243; title_text_align=&#8220;left&#8220; title_text_color=&#8220;#2ea3f2&#8243; content_text_color=&#8220;#000000&#8243; background_enable_color=&#8220;off&#8220; custom_button_one=&#8220;on&#8220; button_one_text_color=&#8220;#FFFFFF&#8220; button_one_bg_color=&#8220;#2ea3f2&#8243; link_option_url_new_window=&#8220;on&#8220; custom_css_free_form=&#8220;.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;||}&#8220; global_colors_info=&#8220;{}&#8220;]<\/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>Die L\u00f6sung<b>\u00a0DB\/IQ Quality Assurance<\/b>\u00a0analysiert und \u00fcberpr\u00fcft den gesamten\u00a0<b>SQL-Code<\/b>, unabh\u00e4ngig davon, ob es sich um Quellcode,\u00a0<b>DBRM<\/b>\u00a0aus dem<b>\u00a0Db2-Pr\u00e4prozessor, SQL<\/b>\u00a0auf Catalogbasis (Plantables, Packages, Views, Materialized query tables, Trigger usw.) oder dynamisch ausgef\u00fchrte SQL handelt.<\/p>\n<p>DB\/IQ QA bietet eine erweiterte SQL-Code-Kontrolle durch folgende Funktionen:<\/p>\n<ul>\n<li>Erm\u00f6glicht die \u00dcberpr\u00fcfung der Qualit\u00e4t des gesamten SQL-Codes gem\u00e4\u00df den von der Organisation festgelegten Standards<\/li>\n<li>\u00dcber 370 Qualit\u00e4tsregeln sind \u201ein einem Repository\u201c verf\u00fcgbar und k\u00f6nnen an Ihre Anforderungen und Service-Level-Vereinbarungen angepasst werden<\/li>\n<li>Bietet Entwicklern eine interaktive Qualit\u00e4tskontrolle und eine umfassende\u00a0<b>EXPLAIN<\/b>-Funktion (Erkl\u00e4rung) f\u00fcr alle SQL-Anweisungen<\/li>\n<li>Meldet und lehnt m\u00f6glicherweise Programme ab, die gegen die Qualit\u00e4tsregeln versto\u00dfen<\/li>\n<li>Die Pr\u00fcfungen k\u00f6nnen bei Bedarf von Entwicklern direkt in ihren Mainframe- oder Eclipse-Entwicklungsumgebungen und automatisch im Stapelverarbeitungsmodus w\u00e4hrend der Bereitstellungsverfahren ausgel\u00f6st werden.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Bloc texte \/ Image 2&#8243; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_header title=&#8220;DB\/IQ QA+: Optimierung dynamischer SQL-Abfragen&#8220; button_one_text=&#8220;Demo anfordern&#8220; button_one_url=&#8220;https:\/\/infotel-software.com\/de\/demo\/&#8220; header_image_url=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2025\/03\/Page-DBIQ-QA-7.png&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; title_level=&#8220;h3&#8243; title_text_color=&#8220;#2ea3f2&#8243; content_text_color=&#8220;#000000&#8243; background_enable_color=&#8220;off&#8220; custom_button_one=&#8220;on&#8220; button_one_text_color=&#8220;#FFFFFF&#8220; button_one_bg_color=&#8220;#2ea3f2&#8243; link_option_url_new_window=&#8220;on&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Die L\u00f6sung\u00a0<b>DB\/IQ QA+<\/b>\u00a0analysiert dynamische SQL-Abfragen eingehend, indem sie deren Kosten, Verkn\u00fcpfungen, Sortierungen, Zugriffspfade, Ausf\u00fchrungszeit,\u00a0<b>CPU-<\/b>Auslastung und Anzahl der\u00a0<b>GETPAGE-Anweisungen<\/b>\u00a0bewertet. Sie identifiziert die ressourcenintensivsten Abfragen, um Leistungsprobleme zu diagnostizieren, und \u00fcberwacht die SQL-Aktivit\u00e4t kritischer Anwendungen in Echtzeit. Durch die Messung der Entwicklung der Abfragequalit\u00e4t \u00fcber einen bestimmten Zeitraum hinweg k\u00f6nnen die Auswirkungen von\u00a0<b>Db2<\/b>-Aktualisierungen auf Ausf\u00fchrungspfade antizipiert werden. Dank eines automatischen Leistungsvergleichs zwischen verschiedenen Versionen einer Abfrage garantiert\u00a0<b>DB\/IQ QA+<\/b>\u00a0eine kontinuierliche Optimierung und eine h\u00f6here Anwendungsstabilit\u00e4t.<\/p>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Bloc texte \/ Image 3&#8243; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_header title=&#8220;DB\/IQ PM: Verwaltung von Packages&#8220; text_orientation=&#8220;right&#8220; button_one_text=&#8220;Weitere Informationen&#8220; button_one_url=&#8220;https:\/\/infotel-software.com\/de\/db-iq-package-management\/&#8220; header_image_url=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-2.png&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; title_level=&#8220;h3&#8243; title_text_align=&#8220;left&#8220; title_text_color=&#8220;#2ea3f2&#8243; content_text_color=&#8220;#000000&#8243; background_enable_color=&#8220;off&#8220; custom_button_one=&#8220;on&#8220; button_one_text_color=&#8220;#FFFFFF&#8220; button_one_bg_color=&#8220;#2ea3f2&#8243; link_option_url_new_window=&#8220;on&#8220; custom_css_free_form=&#8220;.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;||}&#8220; global_colors_info=&#8220;{}&#8220;]<\/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>Die L\u00f6sung\u00a0<b>DB\/IQ Package Management for Db2<\/b>\u00a0befasst sich mit der st\u00e4ndigen Weiterentwicklung von Db2 und den zahlreichen t\u00e4glichen \u00c4nderungen. Tats\u00e4chlich ist die Verwaltung statischer Verkn\u00fcpfungen immer komplexer geworden. Um diese Einschr\u00e4nkung zu mildern, wurde die Funktion\u00a0<b>BIND PACKAGE<\/b>\u00a0eingef\u00fchrt, um die Versionsverwaltung zu automatisieren. Dieser Ansatz hat jedoch zu einem exponentiellen Wachstum der Db2-Catalog gef\u00fchrt, was ihre Verwaltung erschwert und die BIND-Prozesse aufgrund \u00fcberladener Explain-Tabellen verlangsamt.<\/p>\n<p><b>DB\/IQ PM<\/b>\u00a0vereinfacht diese Verwaltung, indem es nicht verwendete Packages identifiziert und l\u00f6scht und anschlie\u00dfend den Db2-Catalog reorganisiert. Das Ergebnis ist ein schlankerer, strukturierterer und optimierter Katalog, der frei von redundanten Packages ist und effizientere Anwendungen erm\u00f6glicht.<\/p>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Bloc texte \/ Image 4&#8243; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_header title=&#8220;DB\/IQ WL: Erweiterte Simulation von Datenmengen&#8220; button_one_text=&#8220;Demo anfordern&#8220; button_one_url=&#8220;https:\/\/infotel-software.com\/de\/demo\/&#8220; header_image_url=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-4.png&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; title_level=&#8220;h3&#8243; title_text_color=&#8220;#2ea3f2&#8243; content_text_color=&#8220;#000000&#8243; background_enable_color=&#8220;off&#8220; custom_button_one=&#8220;on&#8220; button_one_text_color=&#8220;#FFFFFF&#8220; button_one_bg_color=&#8220;#2ea3f2&#8243; link_option_url_new_window=&#8220;on&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Die L\u00f6sung <b>DB\/IQ WorkLoad Detector<\/b> simuliert das Verhalten von Anwendungen, indem sie Datenmengen mithilfe der <b>RUNSTATS<\/b>-Werte simuliert. Damit lassen sich Produktionsbedingungen in Qualifizierungs- und Entwicklungsumgebungen reproduzieren, die Auswirkungen einer Datenzunahme vorhersagen und f\u00fcr neue Projekte geeignete Statistiken erstellen, um die Leistung von Anfang an zu optimieren.<\/p>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Bloc texte \/ Image 5&#8243; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_header title=&#8220;DB\/IQ IA: Erweiterte Indexoptimierung&#8220; text_orientation=&#8220;right&#8220; button_one_text=&#8220;Unsere L\u00f6sung in Aktion&#8220; button_one_url=&#8220;https:\/\/infotel-software.com\/de\/db-iq-index-administrator\/&#8220; header_image_url=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-5.png&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; title_level=&#8220;h3&#8243; title_text_align=&#8220;left&#8220; title_text_color=&#8220;#2ea3f2&#8243; content_text_color=&#8220;#000000&#8243; background_enable_color=&#8220;off&#8220; custom_button_one=&#8220;on&#8220; button_one_text_color=&#8220;#FFFFFF&#8220; button_one_bg_color=&#8220;#2ea3f2&#8243; link_option_url_new_window=&#8220;on&#8220; custom_css_free_form=&#8220;.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;||}&#8220; global_colors_info=&#8220;{}&#8220;]<\/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>Die L\u00f6sung\u00a0<b>DB\/IQ Index Administrator<\/b>\u00a0analysiert alle SQL-Aktivit\u00e4ten eingehend, um die Relevanz vorhandener Indizes f\u00fcr Db2-Tabellen zu bewerten und Optimierungen zu ermitteln, indem neue Schl\u00fcsselspalten f\u00fcr effizientere Indizes vorgeschlagen werden.<\/p>\n<ul>\n<li><b>Umfassende Analyse von SQL<\/b>: Ber\u00fccksichtigt alle mit einer Tabelle verbundenen SQL-Abfragen, ob statische SQL aus dem Db2-Catalog oder dynamische SQL, die aus Traces oder dem Db2-Cache extrahiert wurden.<\/li>\n<li><b>Anwendungsgewichtung<\/b>: Priorisiert die Wichtigkeit von Anwendungen automatisch nach ihrer Ausf\u00fchrungsh\u00e4ufigkeit oder erm\u00f6glicht eine manuelle Gewichtung auf der Grundlage von vom Benutzer definierten Gesch\u00e4ftskriterien.<\/li>\n<li><b>Bewertung und Empfehlungen<\/b>: Untersucht die Effektivit\u00e4t vorhandener Indizes und identifiziert die optimalen Spalten f\u00fcr neue Indizes, wodurch eine Leistungssteigerung gew\u00e4hrleistet wird.<\/li>\n<\/ul>\n<p>Dank dieser Analysen erm\u00f6glicht\u00a0<b>DB\/IQ IA<\/b>\u00a0eine pr\u00e4zise Bewertung der Auswirkungen der vorgeschlagenen Indizes, indem die Anwendungen und SQL-Abfragen identifiziert werden, die am meisten davon profitieren, w\u00e4hrend Leistungsr\u00fcckg\u00e4nge im Zusammenhang mit den neuen Indizes erkannt werden.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Bloc texte \/ Image 6&#8243; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_header title=&#8220;DB\/IQ QA &#8211; Eclipse-Plug-in: Integrierte Qualit\u00e4tssicherung f\u00fcr die SQL-Entwicklung unter Db2&#8243; button_one_text=&#8220;Demo anfordern&#8220; button_one_url=&#8220;https:\/\/infotel-software.com\/de\/demo\/&#8220; header_image_url=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2024\/11\/Page-DBIQ-QA-3.png&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; title_level=&#8220;h3&#8243; title_text_color=&#8220;#2ea3f2&#8243; content_text_color=&#8220;#000000&#8243; background_enable_color=&#8220;off&#8220; custom_button_one=&#8220;on&#8220; button_one_text_color=&#8220;#FFFFFF&#8220; button_one_bg_color=&#8220;#2ea3f2&#8243; link_option_url_new_window=&#8220;on&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<div class=\"et_pb_header_content_wrapper\">\n<p>Die\u00a0<b>DB\/IQ QA-E<\/b>-L\u00f6sung ist ein Eclipse-Plug-in, das die Qualit\u00e4tskontrolle von\u00a0<b>SQL<\/b>-Entwicklungen in einer\u00a0<b>Db2<\/b>-Umgebung gew\u00e4hrleistet. Es ist vollst\u00e4ndig mit\u00a0<b>RDz\u00ae<\/b>\u00a0kompatibel und erm\u00f6glicht die Standardisierung von Entwicklungsverfahren au\u00dferhalb des Mainframes. Sie bietet eine interaktive Qualit\u00e4tskontrolle dank mehr als\u00a0<b>300 Validierungsregeln<\/b>\u00a0sowie eine detaillierte\u00a0<b>EXPLAIN<\/b>-Funktionalit\u00e4t, einschlie\u00dflich Unterst\u00fctzung f\u00fcr versteckte\u00a0<b>EXPLAIN<\/b>-Tabellen. Entwickler k\u00f6nnen so\u00a0<b>Db2<\/b>-Zugriffspfade in Echtzeit analysieren, die Auswirkungen von Datenvolumen und Scans messen und die\u00a0<b>SQL<\/b>-Leistung einfach vergleichen. Durch die direkte Integration dieser Funktionen in\u00a0<b>Eclipse<\/b>\u00a0st\u00e4rkt\u00a0<b>DB\/IQ QA-E<\/b>\u00a0die Beherrschung der SQL-Best-Practices und verbessert die Qualit\u00e4t der Entwicklungen, ohne die\u00a0<b>IDE<\/b>-Umgebung zu verlassen.<\/p>\n<\/div>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; fullwidth=&#8220;on&#8220; admin_label=&#8220;Bloc texte \/ Image 7&#8243; _builder_version=&#8220;4.27.0&#8243; _module_preset=&#8220;default&#8220; da_disable_devices=&#8220;off|off|off&#8220; locked=&#8220;off&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; da_is_popup=&#8220;off&#8220; da_exit_intent=&#8220;off&#8220; da_has_close=&#8220;on&#8220; da_alt_close=&#8220;off&#8220; da_dark_close=&#8220;off&#8220; da_not_modal=&#8220;on&#8220; da_is_singular=&#8220;off&#8220; da_with_loader=&#8220;off&#8220; da_has_shadow=&#8220;on&#8220;][et_pb_fullwidth_header title=&#8220;Kurz gesagt!&#8220; text_orientation=&#8220;right&#8220; button_one_url=&#8220;https:\/\/infotel-software.com\/demo\/&#8220; header_image_url=&#8220;https:\/\/infotel-software.com\/wp-content\/uploads\/2025\/03\/Page-X-bref.png&#8220; _builder_version=&#8220;4.27.4&#8243; _module_preset=&#8220;default&#8220; title_level=&#8220;h3&#8243; title_text_align=&#8220;left&#8220; title_text_color=&#8220;#2ea3f2&#8243; content_text_color=&#8220;#000000&#8243; background_enable_color=&#8220;off&#8220; custom_button_one=&#8220;on&#8220; button_one_text_color=&#8220;#FFFFFF&#8220; button_one_bg_color=&#8220;#2ea3f2&#8243; link_option_url_new_window=&#8220;on&#8220; custom_css_free_form=&#8220;.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;||}&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<ul>\n<li>Gew\u00e4hrleistet die Anwendung der\u00a0<b>Standards und Richtlinien<\/b>, die f\u00fcr einen Db2-Anwendungspark gelten.<\/li>\n<li>Identifiziert und meldet\u00a0<b>SQL-Abfragen, die problematisch sind<\/b>, um Risiken f\u00fcr\u00a0<b>Leistung<\/b>\u00a0und\u00a0<b>Zuverl\u00e4ssigkeit<\/b>\u00a0zu antizipieren.<\/li>\n<li>Gew\u00e4hrleistet die\u00a0<b>Konformit\u00e4t des<\/b>\u00a0in der\u00a0<b>Produktion<\/b>\u00a0bereitgestellten SQL-Codes, ob statisch oder dynamisch, indem sichergestellt wird, dass Qualit\u00e4tsstandards eingehalten werden.<\/li>\n<li>Unterst\u00fctzt Db2-Entwickler bei der<b>\u00a0Optimierung ihrer<\/b>\u00a0Programme durch anpassbare Hilfemeldungen und detaillierte Leistungsindikatoren.<\/li>\n<li>Verringerung der Arbeitsbelastung von Anwendungsmanagern und\u00a0<b>Datenbankadministratoren<\/b>\u00a0durch Automatisierung der Kontrolle von SQL-Anweisungen w\u00e4hrend des gesamten Lebenszyklus der Anwendung.<\/li>\n<li>Kompatibel mit\u00a0<b>DevOps<\/b>-Praktiken, enth\u00e4lt es Auditing-Tools, die eine regelm\u00e4\u00dfige Bewertung der Anwendungsqualit\u00e4t und eine strenge \u00dcberwachung ihrer Entwicklung erm\u00f6glichen.<\/li>\n<li><b>Profitieren Sie von der Unterst\u00fctzung und dem Fachwissen von Infotel<\/b>, einem f\u00fchrenden Unternehmen im Bereich\u00a0<b>Mainframe<\/b>-Datenmanagement und -optimierung, mit erstklassigem technischem Support.<\/li>\n<\/ul>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Stellen Sie die Qualit\u00e4t und Leistung von SQL Db2-Anwendungen sicher\u00dcberpr\u00fcfen Sie, ob SQL Db2-Anwendungen Ihre Qualit\u00e4tsregeln einhaltenBeurteilen Sie, ob die Datenpfade effizient sindErmitteln Sie die besten IndexstrategienKontrollieren Sie die Ausf\u00fchrung von Db2-AbfragenDB\/IQ ist eine L\u00f6sung, die die Qualit\u00e4t und Leistung Ihrer SQL-Abfragen, ob statisch oder dynamisch, gew\u00e4hrleisten und gleichzeitig die Belastung Ihrer z\/OS-Umgebung reduzieren. Die [&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-22558","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\/de\/db-iq\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/db-iq\/\" \/>\n<meta property=\"og:site_name\" content=\"Infotel Software\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-03T08:47:26+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"6\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/infotel-software.com\/de\/db-iq\/\",\"url\":\"https:\/\/infotel-software.com\/de\/db-iq\/\",\"name\":\"Insoft Infotel | Experts in mainframe performance and optimization\",\"isPartOf\":{\"@id\":\"https:\/\/infotel-software.com\/de\/#website\"},\"datePublished\":\"2022-06-24T09:33:40+00:00\",\"dateModified\":\"2025-07-03T08:47:26+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\/de\/db-iq\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/infotel-software.com\/de\/db-iq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/infotel-software.com\/de\/db-iq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/infotel-software.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB\/IQ \u2013 Qualit\u00e4t und Leistung Db2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/infotel-software.com\/de\/#website\",\"url\":\"https:\/\/infotel-software.com\/de\/\",\"name\":\"Insoft Infotel\",\"description\":\"Maximize Performance, Optimize Costs\",\"publisher\":{\"@id\":\"https:\/\/infotel-software.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/infotel-software.com\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/infotel-software.com\/de\/#organization\",\"name\":\"Insoft Infotel\",\"url\":\"https:\/\/infotel-software.com\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/infotel-software.com\/de\/#\/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\/de\/#\/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\/de\/db-iq\/","og_locale":"de_DE","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\/de\/db-iq\/","og_site_name":"Infotel Software","article_modified_time":"2025-07-03T08:47:26+00:00","twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/infotel-software.com\/de\/db-iq\/","url":"https:\/\/infotel-software.com\/de\/db-iq\/","name":"Insoft Infotel | Experts in mainframe performance and optimization","isPartOf":{"@id":"https:\/\/infotel-software.com\/de\/#website"},"datePublished":"2022-06-24T09:33:40+00:00","dateModified":"2025-07-03T08:47:26+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\/de\/db-iq\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/infotel-software.com\/de\/db-iq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/infotel-software.com\/de\/db-iq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/infotel-software.com\/de\/"},{"@type":"ListItem","position":2,"name":"DB\/IQ \u2013 Qualit\u00e4t und Leistung Db2"}]},{"@type":"WebSite","@id":"https:\/\/infotel-software.com\/de\/#website","url":"https:\/\/infotel-software.com\/de\/","name":"Insoft Infotel","description":"Maximize Performance, Optimize Costs","publisher":{"@id":"https:\/\/infotel-software.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/infotel-software.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/infotel-software.com\/de\/#organization","name":"Insoft Infotel","url":"https:\/\/infotel-software.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/infotel-software.com\/de\/#\/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\/de\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/infotel-software.com\/de\/wp-json\/wp\/v2\/pages\/22558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infotel-software.com\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/infotel-software.com\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/infotel-software.com\/de\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/infotel-software.com\/de\/wp-json\/wp\/v2\/comments?post=22558"}],"version-history":[{"count":15,"href":"https:\/\/infotel-software.com\/de\/wp-json\/wp\/v2\/pages\/22558\/revisions"}],"predecessor-version":[{"id":23728,"href":"https:\/\/infotel-software.com\/de\/wp-json\/wp\/v2\/pages\/22558\/revisions\/23728"}],"wp:attachment":[{"href":"https:\/\/infotel-software.com\/de\/wp-json\/wp\/v2\/media?parent=22558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}