{"id":29570,"date":"2026-07-17T10:16:03","date_gmt":"2026-07-17T08:16:03","guid":{"rendered":"https:\/\/infotel-software.com\/?p=29570"},"modified":"2026-07-17T10:16:13","modified_gmt":"2026-07-17T08:16:13","slug":"green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable","status":"publish","type":"post","link":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/","title":{"rendered":"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable"},"content":{"rendered":"<p>[et_pb_section fb_built=\u00a0\u00bb1&Prime; _builder_version=\u00a0\u00bb4.16&Prime; da_disable_devices=\u00a0\u00bboff|off|off\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.16&Prime; background_size=\u00a0\u00bbinitial\u00a0\u00bb background_position=\u00a0\u00bbtop_left\u00a0\u00bb background_repeat=\u00a0\u00bbrepeat\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_column type=\u00a0\u00bb4_4&Prime; _builder_version=\u00a0\u00bb4.16&Prime; custom_padding=\u00a0\u00bb|||\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb custom_padding__hover=\u00a0\u00bb|||\u00a0\u00bb][et_pb_text _builder_version=\u00a0\u00bb4.27.6&Prime; background_size=\u00a0\u00bbinitial\u00a0\u00bb background_position=\u00a0\u00bbtop_left\u00a0\u00bb background_repeat=\u00a0\u00bbrepeat\u00a0\u00bb hover_enabled=\u00a0\u00bb0&Prime; global_colors_info=\u00a0\u00bb{}\u00a0\u00bb sticky_enabled=\u00a0\u00bb0&Prime;]<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"5:1-5:359;136-494\"><strong>Paris<\/strong> \u2013 Face \u00e0 une production de donn\u00e9es mondiale d\u00e9sormais mesur\u00e9e en zettaoctets, Infotel pr\u00e9sente, \u00e0 travers une intervention de son expert Morgan Attias, sa m\u00e9thodologie \u00ab Green Archiving \u00bb : une approche concr\u00e8te pour r\u00e9duire l&#8217;empreinte carbone de l&rsquo;archivage \u00e9lectronique <strong>sans sacrifier ni la conformit\u00e9, ni l&rsquo;accessibilit\u00e9, ni la performance<\/strong>.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"7:1-7:78;496-573\"><strong>Un volume de donn\u00e9es hors normes, un enjeu environnemental incontournable<\/strong><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"9:1-9:372;575-946\">La croissance annuelle des donn\u00e9es produites atteint aujourd&rsquo;hui une \u00e9chelle <strong>zettaoctet<\/strong> (10\u00b2\u00b9 octets), un ordre de grandeur jusqu&rsquo;ici r\u00e9serv\u00e9 \u00e0 l&rsquo;astronomie. Dans ce contexte, et alors que les plans RSE et les engagements environnementaux se multiplient, la ma\u00eetrise de l&rsquo;impact carbone de l&rsquo;archivage \u00e9lectronique devient un enjeu strat\u00e9gique pour les organisations.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"11:1-11:30;948-977\"><strong>Attention au greenwashing<\/strong><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"13:1-13:542;979-1520\">Morgan Attias alerte sur un \u00e9cueil fr\u00e9quent : la compensation carbone (plantation d&rsquo;arbres, etc.) <strong>n&rsquo;est pas une strat\u00e9gie viable sur le long terme<\/strong>. Il invite les organisations \u00e0 privil\u00e9gier des fournisseurs transparents sur leur empreinte r\u00e9elle plut\u00f4t que de se fier \u00e0 des donn\u00e9es g\u00e9n\u00e9riques, comme celles de la <strong>Base Empreinte<\/strong> (0,5 \u00e0 24 g de CO2 par gigaoctet stock\u00e9 dans le cloud) : des ordres de grandeur utiles, mais rarement repr\u00e9sentatifs d&rsquo;un contexte d&rsquo;archivage et de pr\u00e9servation sur 5, 10, 15 ans, voire \u00e0 titre permanent.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"15:1-15:42;1522-1563\"><strong>Des angles morts trop souvent ignor\u00e9s<\/strong><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"17:1-17:182;1565-1746\">L&rsquo;\u00e9tude s&rsquo;appuie notamment sur les travaux du CSC finlandais et sur une analyse du Conseil de l&rsquo;Europe pour mettre en lumi\u00e8re plusieurs sources d&rsquo;impact g\u00e9n\u00e9ralement sous-estim\u00e9es :<\/p>\n<ul class=\"[li_&amp;]:mb-0 [li_&amp;]:mt-1 [li_&amp;]:gap-1 [&amp;:not(:last-child)_ul]:pb-1 [&amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\" data-sourcepos=\"19:1-22:173;1748-2404\">\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"19:1-19:175;1748-1922\"><strong>L&rsquo;archivage physique<\/strong> g\u00e9n\u00e8re lui aussi une empreinte carbone (climatisation, transport, indexation sur serveurs), parfois sup\u00e9rieure \u00e0 celle de l&rsquo;archivage \u00e9lectronique.<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"20:1-20:179;1923-2101\"><strong>La compression et le chiffrement<\/strong> appliqu\u00e9s sans discernement (par exemple sur des fichiers d\u00e9j\u00e0 compress\u00e9s) peuvent multiplier par sept le co\u00fbt \u00e9nerg\u00e9tique d&rsquo;un traitement.<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"21:1-21:130;2102-2231\"><strong>La r\u00e9plication passive<\/strong> et des <strong>politiques de sauvegarde trop fr\u00e9quentes<\/strong> d\u00e9multiplient inutilement le volume de stockage.<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"22:1-22:173;2232-2404\"><strong>Les m\u00e9tadonn\u00e9es superflues<\/strong> : \u00e0 l&rsquo;\u00e9chelle de centaines de milliers d&rsquo;archives, chaque champ de m\u00e9tadonn\u00e9e ajout\u00e9 doit \u00eatre mat\u00e9rialis\u00e9 et p\u00e8se sur l&#8217;empreinte globale.<\/li>\n<\/ul>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"24:1-24:226;2406-2631\">En rationalisant ces pratiques (suppression des copies redondantes, passage \u00e0 une strat\u00e9gie d&rsquo;archivage ti\u00e8de ou froid adapt\u00e9e), l&rsquo;impact environnemental d&rsquo;un m\u00eame volume de donn\u00e9es peut \u00eatre <strong>divis\u00e9 par 10, voire par 100<\/strong>.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"26:1-26:50;2633-2682\"><strong>Une preuve par l&rsquo;exemple : le cas Infotel Lab<\/strong><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"28:1-28:256;2684-2939\">Pour valider cette m\u00e9thodologie, les \u00e9quipes Infotel ont men\u00e9 un projet interne avec un objectif clair : construire un syst\u00e8me d&rsquo;archivage \u00e0 valeur probatoire, compatible avec un environnement de production, tout en minimisant la consommation \u00e9nerg\u00e9tique.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"30:1-30:255;2941-3195\">Le dispositif de test reposait sur plusieurs t\u00e9raoctets de donn\u00e9es (archives de 1 \u00e0 10 Mo), avec une cible de 100 000 op\u00e9rations d&rsquo;archivage et 10 000 consultations par heure. Les r\u00e9sultats obtenus gr\u00e2ce \u00e0 du mat\u00e9riel basse consommation sont sans appel :<\/p>\n<ul class=\"[li_&amp;]:mb-0 [li_&amp;]:mt-1 [li_&amp;]:gap-1 [&amp;:not(:last-child)_ul]:pb-1 [&amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\" data-sourcepos=\"32:1-33:78;3197-3369\">\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"32:1-32:95;3197-3291\"><strong>8 \u00e0 12 W<\/strong> en fonctionnement standard (pics \u00e0 15-20 W) pour le mat\u00e9riel basse consommation<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"33:1-33:78;3292-3369\">contre <strong>25 \u00e0 35 W<\/strong> en standard (pics \u00e0 60-75 W) pour un serveur classique<\/li>\n<\/ul>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"35:1-35:105;3371-3475\">Une r\u00e9duction drastique de la consommation, obtenue <strong>sans compromis sur la performance de production<\/strong>.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"37:1-37:48;3477-3524\"><strong>Les leviers d&rsquo;action identifi\u00e9s par Infotel<\/strong><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"39:1-39:108;3526-3633\">L&rsquo;expertise pr\u00e9sent\u00e9e par Morgan Attias structure la d\u00e9marche Green Archiving autour de plusieurs piliers :<\/p>\n<ul class=\"[li_&amp;]:mb-0 [li_&amp;]:mt-1 [li_&amp;]:gap-1 [&amp;:not(:last-child)_ul]:pb-1 [&amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\" data-sourcepos=\"41:1-46:119;3635-4318\">\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"41:1-41:116;3635-3750\"><strong>Mat\u00e9riel<\/strong> : privil\u00e9gier des serveurs basse consommation et rationaliser les ressources selon les besoins r\u00e9els<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"42:1-42:124;3751-3874\"><strong>Support de stockage<\/strong> : arbitrer entre disque, bande et technologies \u00e9mergentes (stockage ADN, c\u00e9ramique) selon l&rsquo;usage<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"43:1-43:112;3875-3986\"><strong>Logiciel<\/strong> : n&rsquo;activer chiffrement, compression et d\u00e9duplication que lorsqu&rsquo;ils sont r\u00e9ellement n\u00e9cessaires<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"44:1-44:101;3987-4087\"><strong>Gestion des acc\u00e8s<\/strong> : combiner stockage \u00e0 chaud, ti\u00e8de et froid selon la fr\u00e9quence d&rsquo;utilisation<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"45:1-45:112;4088-4199\"><strong>Cycle de vie de la donn\u00e9e<\/strong> : d\u00e9finir d\u00e8s sa cr\u00e9ation la dur\u00e9e de conservation et les r\u00e8gles de suppression<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\" data-sourcepos=\"46:1-46:119;4200-4318\"><strong>M\u00e9tadonn\u00e9es<\/strong> : ne conserver que les m\u00e9tadonn\u00e9es r\u00e9ellement utiles \u00e0 la recherche et \u00e0 l&rsquo;exploitation des archives<\/li>\n<\/ul>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"48:1-48:172;4320-4491\">Infotel recommande par ailleurs le <strong>R\u00e9f\u00e9rentiel G\u00e9n\u00e9ral d&rsquo;\u00c9coconception<\/strong> comme outil d&rsquo;auto-diagnostic pour les organisations souhaitant \u00e9valuer leurs propres pratiques.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"50:1-50:50;4493-4542\"><strong>Une conviction : r\u00e9duire plut\u00f4t que compenser<\/strong><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"52:1-52:327;4544-4870\">\u00ab Il n&rsquo;est en aucun cas n\u00e9cessaire de sacrifier l&rsquo;accessibilit\u00e9 ou d&rsquo;augmenter drastiquement le risque. En planifiant strat\u00e9giquement, en prenant les bonnes d\u00e9cisions et en impliquant les diff\u00e9rents utilisateurs de la donn\u00e9e, on peut arriver \u00e0 une r\u00e9duction impressionnante de l&rsquo;impact environnemental \u00bb, r\u00e9sume Morgan Attias.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"58:1-58:60;4902-4961\">\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"60:1-60:110;4963-5072\"><strong>Vous avez un projet d&rsquo;archivage \u00e9lectronique \u00e9co-responsable ? Nos experts sont l\u00e0 pour vous accompagner.<\/strong><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"62:1-62:66;5074-5139\"><a class=\"underline underline underline-offset-2 decoration-1 decoration-current\/40 hover:decoration-current focus:decoration-current\" href=\"https:\/\/infotel-software.com\/fr\/nous-contacter\/\">Contactez-nous<\/a><\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" data-sourcepos=\"64:1-64:104;5141-5244\"><strong>#GreenArchiving #Archivage\u00c9lectronique #RSE #EmpreinteCarbone #Pr\u00e9servationNum\u00e9rique #\u00c9coconception<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00a0\u00bb1_2,1_2&Prime; _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb module_alignment=\u00a0\u00bbcenter\u00a0\u00bb custom_margin=\u00a0\u00bb2%||||false|false\u00a0\u00bb custom_padding=\u00a0\u00bb|2%||2%|false|false\u00a0\u00bb border_width_all=\u00a0\u00bb2px\u00a0\u00bb border_color_all=\u00a0\u00bb#2EA3F2&Prime; locked=\u00a0\u00bboff\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][et_pb_column type=\u00a0\u00bb1_2&Prime; _builder_version=\u00a0\u00bb4.27.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 global_colors_info=\u00a0\u00bb{}\u00a0\u00bb]<\/p>\n<div class=\"et_pb_module et_pb_text et_pb_text_1 et_pb_text_align_left et_pb_bg_layout_light\">\n<div class=\"et_pb_text_inner\">\n<p style=\"text-align: center;\"><strong>Pour obtenir des informations d\u00e9taill\u00e9es, t\u00e9l\u00e9chargez gratuitement nos documentations techniques.<\/strong><\/p>\n<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_button button_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/documentations\/\u00a0\u00bb button_text=\u00a0\u00bbT\u00e9l\u00e9charger la documentation\u00a0\u00bb button_alignment=\u00a0\u00bbcenter\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_button][\/et_pb_column][et_pb_column type=\u00a0\u00bb1_2&Prime; _builder_version=\u00a0\u00bb4.27.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 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 style=\"text-align: center;\"><strong>Vous avez un projet ? Nos experts sont l\u00e0 pour vous accompagner.\u00a0<\/strong><strong>Cliquez ci-dessous pour nous contacter.<\/strong><\/p>\n<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_button button_url=\u00a0\u00bbhttps:\/\/infotel-software.com\/fr\/nous-contacter\/\u00a0\u00bb button_text=\u00a0\u00bbContactez-nous\u00a0\u00bb button_alignment=\u00a0\u00bbcenter\u00a0\u00bb _builder_version=\u00a0\u00bb4.27.4&Prime; _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Paris \u2013 Face \u00e0 une production de donn\u00e9es mondiale d\u00e9sormais mesur\u00e9e en zettaoctets, Infotel pr\u00e9sente, \u00e0 travers une intervention de son expert Morgan Attias, sa m\u00e9thodologie \u00ab Green Archiving \u00bb : une approche concr\u00e8te pour r\u00e9duire l&#8217;empreinte carbone de l&rsquo;archivage \u00e9lectronique sans sacrifier ni la conformit\u00e9, ni l&rsquo;accessibilit\u00e9, ni la performance. Un volume de donn\u00e9es [&hellip;]<\/p>\n","protected":false},"author":34,"featured_media":29574,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"<p>Assuring the quality and performance of the SQL in Db2<sup>\u00ae<\/sup> for z\/OS<sup>\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><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><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><p><strong>Dynamic and Static SQL<\/strong><\/p><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><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><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><p>The bottom line though, is that DBAs are required to understand, tune, and optimize both static and dynamic SQL in Db2 applications.<\/p><p><strong>Optimization Challenges<\/strong><\/p><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><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><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><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><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><p><strong>Infotel DB\/IQ QA+<\/strong><\/p><p>A particularly useful tool for monitoring and improving the quality of your Db2 for z\/OS SQL is <a href=\"https:\/\/infotel-software.com\/database-management\/\">DB\/IQ QA Plus<\/a> from Infotel Corp.<\/p><p>DB\/IQ QA can be used to ensure data consistency, accuracy, and compliance, particularly in high-stakes environments where data integrity is critical. Traditional data quality methods often rely on manual checks and fragmented tools, which are time-consuming and prone to error. DB\/IQ QA integrates directly with Db2, allowing for streamlined and comprehensive data validation, reducing operational costs and the likelihood of undetected data issues.<\/p><p>The tool enables monitoring and optimization of both static and dynamic SQL by performing quality assurance on SQL, using a set of more than 350 rules, delivered as a standard, but which can be modified and enhanced by DBAs. No expensive Db2 trace is required. For dynamic SQL, DB\/IQ QA+ monitors all activities in the Db2 Statement Cache and reports on vital information, highlighting performance problems and heavy consumers.<\/p><p>By reviewing troublesome SQL and applying optimization rules, the quality and performance of the SQL \u2013 both dynamic and static \u2013 in your Db2 applications can be consistently reviewed and improved.<\/p><p>By automating key quality assurance processes, DB\/IQ QA frees up resources, allowing DBAs and IT teams to focus on strategic initiatives rather than repetitive tasks. The tool is built to monitor and enforce business rules consistently, ensuring regulatory compliance and fostering trust in organizational data. Additionally, DB\/IQ QA offers enhanced reporting and analytics capabilities that allow stakeholders to gain insights into data quality trends, helping them make informed decisions and continuously improve their data governance practices.<\/p><p style=\"text-align: right;\">By Craig S. Mullins<\/p>","_et_gb_content_width":"","footnotes":""},"categories":[105],"tags":[],"class_list":["post-29570","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-communiques-de-presse"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable - Infotel Software<\/title>\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\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable - Infotel Software\" \/>\n<meta property=\"og:description\" content=\"Paris \u2013 Face \u00e0 une production de donn\u00e9es mondiale d\u00e9sormais mesur\u00e9e en zettaoctets, Infotel pr\u00e9sente, \u00e0 travers une intervention de son expert Morgan Attias, sa m\u00e9thodologie \u00ab Green Archiving \u00bb : une approche concr\u00e8te pour r\u00e9duire l&#039;empreinte carbone de l&#039;archivage \u00e9lectronique sans sacrifier ni la conformit\u00e9, ni l&#039;accessibilit\u00e9, ni la performance. Un volume de donn\u00e9es [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/\" \/>\n<meta property=\"og:site_name\" content=\"Infotel Software\" \/>\n<meta property=\"article:published_time\" content=\"2026-07-17T08:16:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-17T08:16:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1620\" \/>\n\t<meta property=\"og:image:height\" content=\"907\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"i.boudalia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"i.boudalia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/\"},\"author\":{\"name\":\"i.boudalia\",\"@id\":\"https:\/\/infotel-software.com\/fr\/#\/schema\/person\/85d69bdf0ba9e61c747b1798d58acd6c\"},\"headline\":\"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable\",\"datePublished\":\"2026-07-17T08:16:03+00:00\",\"dateModified\":\"2026-07-17T08:16:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/\"},\"wordCount\":1091,\"publisher\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png\",\"articleSection\":[\"Communiqu\u00e9s de presse\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/\",\"url\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/\",\"name\":\"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable - Infotel Software\",\"isPartOf\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png\",\"datePublished\":\"2026-07-17T08:16:03+00:00\",\"dateModified\":\"2026-07-17T08:16:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#primaryimage\",\"url\":\"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png\",\"contentUrl\":\"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png\",\"width\":1620,\"height\":907},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/infotel-software.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable\"}]},{\"@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\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/infotel-software.com\/fr\/#\/schema\/person\/85d69bdf0ba9e61c747b1798d58acd6c\",\"name\":\"i.boudalia\",\"url\":\"https:\/\/infotel-software.com\/fr\/author\/i-boudalia\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable - Infotel Software","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\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/","og_locale":"fr_FR","og_type":"article","og_title":"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable - Infotel Software","og_description":"Paris \u2013 Face \u00e0 une production de donn\u00e9es mondiale d\u00e9sormais mesur\u00e9e en zettaoctets, Infotel pr\u00e9sente, \u00e0 travers une intervention de son expert Morgan Attias, sa m\u00e9thodologie \u00ab Green Archiving \u00bb : une approche concr\u00e8te pour r\u00e9duire l'empreinte carbone de l'archivage \u00e9lectronique sans sacrifier ni la conformit\u00e9, ni l'accessibilit\u00e9, ni la performance. Un volume de donn\u00e9es [&hellip;]","og_url":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/","og_site_name":"Infotel Software","article_published_time":"2026-07-17T08:16:03+00:00","article_modified_time":"2026-07-17T08:16:13+00:00","og_image":[{"width":1620,"height":907,"url":"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png","type":"image\/png"}],"author":"i.boudalia","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"i.boudalia","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#article","isPartOf":{"@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/"},"author":{"name":"i.boudalia","@id":"https:\/\/infotel-software.com\/fr\/#\/schema\/person\/85d69bdf0ba9e61c747b1798d58acd6c"},"headline":"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable","datePublished":"2026-07-17T08:16:03+00:00","dateModified":"2026-07-17T08:16:13+00:00","mainEntityOfPage":{"@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/"},"wordCount":1091,"publisher":{"@id":"https:\/\/infotel-software.com\/fr\/#organization"},"image":{"@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#primaryimage"},"thumbnailUrl":"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png","articleSection":["Communiqu\u00e9s de presse"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/","url":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/","name":"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable - Infotel Software","isPartOf":{"@id":"https:\/\/infotel-software.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#primaryimage"},"image":{"@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#primaryimage"},"thumbnailUrl":"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png","datePublished":"2026-07-17T08:16:03+00:00","dateModified":"2026-07-17T08:16:13+00:00","breadcrumb":{"@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#primaryimage","url":"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png","contentUrl":"https:\/\/infotel-software.com\/wp-content\/uploads\/2026\/07\/Morgan-ATTIAS-Green-Archiving.png","width":1620,"height":907},{"@type":"BreadcrumbList","@id":"https:\/\/infotel-software.com\/fr\/communiques-de-presse\/green-archiving-infotel-devoile-sa-methodologie-pour-un-archivage-electronique-eco-responsable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/infotel-software.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Green Archiving : Infotel d\u00e9voile sa m\u00e9thodologie pour un archivage \u00e9lectronique \u00e9co-responsable"}]},{"@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\/"}},{"@type":"Person","@id":"https:\/\/infotel-software.com\/fr\/#\/schema\/person\/85d69bdf0ba9e61c747b1798d58acd6c","name":"i.boudalia","url":"https:\/\/infotel-software.com\/fr\/author\/i-boudalia\/"}]}},"_links":{"self":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/posts\/29570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"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=29570"}],"version-history":[{"count":3,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/posts\/29570\/revisions"}],"predecessor-version":[{"id":29581,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/posts\/29570\/revisions\/29581"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/media\/29574"}],"wp:attachment":[{"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/media?parent=29570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/categories?post=29570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/infotel-software.com\/fr\/wp-json\/wp\/v2\/tags?post=29570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}