[et_pb_section fb_built=\u00a0\u00bb1″ fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 1″ _builder_version=\u00a0\u00bb4.27.4″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb custom_padding=\u00a0\u00bb||0px||false|false\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\u00bbFRiPRES 2025 \u2013 Appel \u00e0 contributions\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2025\/09\/FRIPRES-2025-INFOTEL-SOFTWARE-2-1.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3″ title_text_color=\u00a0\u00bb#2ea3f2″ content_text_color=\u00a0\u00bb#000000″ 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″ 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 global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n
La seconde \u00e9dition de FRiPRES<\/strong> se tiendra le 4 novembre 2025 \u00e0 Paris<\/strong> (Infotel, 18 avenue L\u00e9on Gaumont).<\/p>\n Cette journ\u00e9e francophone d\u00e9di\u00e9e \u00e0 la pr\u00e9servation num\u00e9rique<\/strong>, organis\u00e9e en parall\u00e8le de la conf\u00e9rence internationale iPRES 2025<\/strong>, offre aux professionnels, chercheurs et \u00e9tudiants<\/strong> un espace pour partager leurs travaux, explorer les derni\u00e8res innovations et contribuer aux discussions internationales, en fran\u00e7ais.<\/p>\n [\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1″ fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbBloc texte \/ Image 2″ _builder_version=\u00a0\u00bb4.27.4″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb custom_padding=\u00a0\u00bb0px||||false|false\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\u00bbPartenaires\u00a0\u00bb text_orientation=\u00a0\u00bbright\u00a0\u00bb header_image_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/wp-content\/uploads\/2025\/09\/Infotel-x-iPRS-2.png\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb title_level=\u00a0\u00bbh3″ title_text_align=\u00a0\u00bbleft\u00a0\u00bb title_text_color=\u00a0\u00bb#2ea3f2″ content_text_color=\u00a0\u00bb#000000″ 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″ 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 global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n FRiPRES<\/strong> est soutenu par Infotel<\/strong> <\/a>et s\u2019inscrit dans une dynamique de collaboration internationale aux c\u00f4t\u00e9s de l\u2019\u00e9quipe organisatrice d\u2019iPRES 2025<\/strong><\/a>. Cette initiative contribue \u00e0 renforcer la place de la francophonie dans le domaine de la pr\u00e9servation num\u00e9rique.<\/p>\n [\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=\u00a0\u00bb1″ fullwidth=\u00a0\u00bbon\u00a0\u00bb admin_label=\u00a0\u00bbTexte centr\u00e9\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb custom_padding=\u00a0\u00bb0px||0px||false|false\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 text_orientation=\u00a0\u00bbcenter\u00a0\u00bb button_one_text=\u00a0\u00bbEn savoir plus\u00a0\u00bb button_one_url=\u00a0\u00bbhttps:\/\/fripres.com\/\u00a0\u00bb button_two_url=\u00a0\u00bbhttps:\/\/fripres.com\/\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb content_font_size=\u00a0\u00bb18px\u00a0\u00bb link_option_url=\u00a0\u00bbhttps:\/\/fripres.com\/\u00a0\u00bb custom_css_free_form=\u00a0\u00bb.et_pb_fullwidth_header .et_pb_fullwidth_header_container.center .header-content {|| width: 100%!important;|| max-width: 1920px!important;||}||||h4 {|| line-height:1.4em;||}\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n [\/et_pb_fullwidth_header][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" La seconde \u00e9dition de FRiPRES se tiendra le 4 novembre 2025 \u00e0 Paris (Infotel, 18 avenue L\u00e9on Gaumont). Cette journ\u00e9e francophone d\u00e9di\u00e9e \u00e0 la pr\u00e9servation num\u00e9rique, organis\u00e9e en parall\u00e8le de la conf\u00e9rence internationale iPRES 2025, offre aux professionnels, chercheurs et \u00e9tudiants un espace pour partager leurs travaux, explorer les derni\u00e8res innovations et contribuer aux discussions […]<\/p>\n","protected":false},"author":34,"featured_media":24580,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":" Assuring the quality and performance of the SQL in Db2\u00ae<\/sup> for z\/OS\u00ae<\/sup> applications is of paramount importance. Indeed, monitoring and improving SQL performance is one of the key duties of Db2 DBAs. Applications with high quality, optimal SQL is essential because it directly impacts the performance, scalability, and cost-effectiveness of database-driven applications. When SQL queries are well-written and efficient, they execute quickly, consume fewer resources, and reduce the load on the database server. This results in faster response times for end-users and ensures that the application remains responsive and efficient, even as data volumes grow.<\/p> In high-transaction environments, such as financial services, healthcare, and e-commerce, optimal SQL can make the difference between meeting critical SLAs and experiencing delays that may impact business operations or customer satisfaction.<\/p> Optimal SQL also plays a key role in cost management, especially in environments where resources are billed based on usage. Poorly optimized SQL can lead to unnecessary table scans, excessive CPU usage, and higher memory consumption, increasing infrastructure costs. Additionally, high-quality SQL contributes to database stability by minimizing contention for resources, reducing the risk of deadlocks, and preventing potential performance bottlenecks. In the long term, this allows the database to scale effectively without significant hardware upgrades or costly performance-tuning efforts.<\/p> Dynamic and Static SQL<\/strong><\/p> In Db2 for z\/OS environments, both dynamic and static SQL are used in applications. Static SQL is pre-compiled at the time of application development, meaning that the access path to the data is determined during the compile and bind phases. This process provides stability and performance predictability since the SQL statements are optimized beforehand. With static SQL, Db2 generates an access path and \"binds\" it into a package, which can be reused without recalculating access paths for each execution. This characteristic makes static SQL especially beneficial for high-volume transactional applications, where predictable response times and minimized CPU usage are crucial.<\/p> On the other hand, dynamic SQL is compiled and optimized at runtime, meaning that access paths are determined only when the SQL statement is executed. This flexibility allows applications to handle unpredictable workloads and dynamic user inputs, as queries can be generated on-the-fly. Dynamic SQL is ideal for applications where query structures change frequently, such as ad-hoc reporting or decision-support systems. Although dynamic SQL generally incurs higher CPU costs due to the need for runtime optimization, it allows for greater flexibility in adapting to varying queries and workloads.<\/p> Most modern applications rely on dynamic SQL more than static SQL however, both dynamic and static SQL are essential to Db2 for z\/OS because they address different performance and functionality requirements. Static SQL is crucial for predictable, high-performance transactions in production environments, helping reduce CPU usage and stabilize application behavior. Meanwhile, dynamic SQL provides the adaptability required for interactive and complex queries where pre-compilation is not feasible. The balance between the two often depends on the nature of the application, workload predictability, and performance considerations, making it essential for Db2 for z\/OS environments to support both types effectively.<\/p> The bottom line though, is that DBAs are required to understand, tune, and optimize both static and dynamic SQL in Db2 applications.<\/p> Optimization Challenges<\/strong><\/p> Monitoring and tuning both static and dynamic SQL in Db2 for z\/OS applications present unique challenges due to the distinct nature of each type of SQL. For static SQL, the primary challenge lies in maintaining optimized performance over time. Since static SQL statements are pre-compiled, the access path chosen at the time of the initial bind remains fixed until the application is recompiled or re-bound. As data volumes grow and database structures evolve, these pre-defined access paths may become suboptimal, resulting in performance degradation. This requires DBAs to periodically re-evaluate and re-bind static SQL, which can be labor-intensive, especially in large applications with numerous packages.<\/p> Another challenge with static SQL is ensuring that any tuning changes do not inadvertently impact performance elsewhere, especially in production environments. Identifying and analyzing poor-performing static SQL statements often requires the use of specialized tools to gather and interpret metrics, such as buffer pool usage, CPU time, and I\/O statistics, to pinpoint issues accurately.<\/p> For dynamic SQL, the primary challenge is the unpredictability and variability of runtime queries. Unlike static SQL, dynamic SQL statements are optimized at runtime, meaning that access paths are determined based on the current environment, data distribution, and query parameters. This flexibility, while powerful, can lead to inconsistent performance. The real-time optimization process for dynamic SQL also can consume additional CPU, adding overhead that can become costly in high-transaction environments.<\/p> Dynamic SQL performance tuning requires constant monitoring of execution patterns and access paths, often using tools that can capture and analyze SQL statements as they are generated. One key challenge here is capturing queries that change with user inputs or application logic. DBAs must monitor the SQL cache, identify high-resource-consuming queries, and determine if any repetitive, resource-intensive patterns emerge. Tuning dynamic SQL often involves working with the application team to modify queries, adjust indexes, or even consider static alternatives if performance demands stability.<\/p> Overall, monitoring and tuning both static and dynamic SQL in Db2 for z\/OS is an ongoing process that requires tools, expertise, and a deep understanding of workload patterns. Addressing the unique challenges of each type helps ensure optimal database performance, supporting both high-throughput transactional systems and flexible, user-driven queries.<\/p>Consultez la page d\u00e9di\u00e9e pour retrouver toutes les informations, les th\u00e9matiques propos\u00e9es et les modalit\u00e9s de soumission.<\/h4>\n