{"id":3825,"date":"2023-04-26T15:11:33","date_gmt":"2023-04-26T13:11:33","guid":{"rendered":"https:\/\/www.skillup.cloud\/?p=3825"},"modified":"2024-01-23T17:46:56","modified_gmt":"2024-01-23T16:46:56","slug":"stack-di-tutti-i-lavori-interattivi","status":"publish","type":"post","link":"https:\/\/www.skillup.cloud\/it\/stack-di-tutti-i-lavori-interattivi\/","title":{"rendered":"Stack di tutti i lavori interattivi"},"content":{"rendered":"\n<p>Per avere una &#8220;trace&#8221; delle esecuzioni di tutti i lavori interattivi &#8220;utente&#8221; attivi sul Sistema:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">  WITH JOBINFO AS(SELECT JOB_NAME, JOB_TYPE\n                    FROM TABLE(QSYS2.JOB_INFO(                     \n                               JOB_STATUS_FILTER =&gt; '*ACTIVE',     \n                               JOB_USER_FILTER =&gt; '*ALL'))A        \n                   WHERE JOB_TYPE = 'INT'\n                     AND SUBSTR(JOB_NAME, 8,                       \n                                POSSTR(SUBSTR(JOB_NAME, 8), '\/')-1)\n                         NOT LIKE 'Q%'                             \n                  ),                                               \n         STACK AS(SELECT *\n                    FROM JOBINFO,                                  \n                         TABLE(QSYS2.STACK_INFO(JOB_NAME, 'ALL')) X\n                   WHERE STATE00001 IS NOT NULL                    \n                  )                                                \nSELECT *\n  FROM STACK<\/pre>\n\n\n\n<p>Result:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">---\nJOB_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JOB_TYPE &nbsp;THREAD_ID &nbsp;THREAD_TYPE &nbsp;ORDINAL_POSITION &nbsp;ENTRY_TYPE &nbsp;PROGRAM_NAME &nbsp;PROGRAM_LIBRARY_NAME &nbsp;STATEMENT_IDENTIFIERS &nbsp;MODULE_NAME &nbsp;MODULE_LIBRARY_NAME &nbsp;PROCEDURE_NAME &nbsp;ACTIVATION_GROUP_NUMBER &nbsp;ACTIVATION_GROUP_NAME &nbsp;MI_INSTRUCTION_NUMBER\n190936\/USR001\/QPADEV0003 &nbsp;INT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 126 &nbsp;USER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 24 &nbsp;ILE &nbsp; &nbsp; &nbsp; &nbsp; QRNXIO &nbsp; &nbsp; &nbsp; &nbsp;QSYS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 63 &nbsp;QRNXWSIO &nbsp; &nbsp; QBUILDSS1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;_QRNX_WS_EXFMT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp;*DFTACTGRP\n190936\/USR001\/QPADEV0003 &nbsp;INT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 126 &nbsp;USER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23 &nbsp;ILE &nbsp; &nbsp; &nbsp; &nbsp; PGM001 &nbsp; &nbsp; &nbsp; &nbsp;LIBPGM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;74400 &nbsp;PGM001 &nbsp; &nbsp; &nbsp; QTEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PGM001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp;*DFTACTGRP\n190936\/USR001\/QPADEV0003 &nbsp;INT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 126 &nbsp;USER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19 &nbsp;OPM &nbsp; &nbsp; &nbsp; &nbsp; PGM000 &nbsp; &nbsp; &nbsp; &nbsp;LIBPGM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15\n---<\/pre>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-3817\" style=\"width: 32px;\" src=\"https:\/\/www.skillup.cloud\/wp-content\/uploads\/2023\/11\/Actions-help-hint-icon.png\" alt=\"\">Casi in cui pu\u00f2 essere utile:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>conoscere quali Programmi vengono utilizzati e quali no<\/li>\n\n\n\n<li>conoscere quali Utenti utilizzano determinati Programmi<\/li>\n\n\n\n<li>conoscere in quali giorni \/ orari vengono utilizzati determinati Programmi.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Per avere una &#8220;trace&#8221; delle esecuzioni di tutti i lavori interattivi &#8220;utente&#8221; attivi sul Sistema: WITH JOBINFO AS(SELECT JOB_NAME, JOB_TYPE FROM TABLE(QSYS2.JOB_INFO( JOB_STATUS_FILTER =&gt; &#8216;*ACTIVE&#8217;, JOB_USER_FILTER =&gt; &#8216;*ALL&#8217;))A WHERE JOB_TYPE = &#8216;INT&#8217; AND SUBSTR(JOB_NAME, 8, POSSTR(SUBSTR(JOB_NAME, 8), &#8216;\/&#8217;)-1) NOT LIKE&#8230;<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[16],"tags":[29,31,40,46,74],"class_list":["post-3825","post","type-post","status-publish","format-standard","hentry","category-iniziamo-con-alcuni-esempi","tag-as400","tag-db2","tag-iseries","tag-sql","tag-job_info"],"_links":{"self":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/comments?post=3825"}],"version-history":[{"count":6,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3825\/revisions"}],"predecessor-version":[{"id":3901,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3825\/revisions\/3901"}],"wp:attachment":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/media?parent=3825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/categories?post=3825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/tags?post=3825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}