{"id":3834,"date":"2023-04-21T15:37:07","date_gmt":"2023-04-21T13:37:07","guid":{"rendered":"https:\/\/www.skillup.cloud\/?p=3834"},"modified":"2024-01-23T17:47:03","modified_gmt":"2024-01-23T16:47:03","slug":"last-ipl","status":"publish","type":"post","link":"https:\/\/www.skillup.cloud\/it\/last-ipl\/","title":{"rendered":"Last IPL"},"content":{"rendered":"\n<p class=\"has-large-font-size\">SQL per ricavare data ultimo IPL<\/p>\n\n\n\n<p>Comando SQL per sapere quando \u00e8 stato effettuato l&#8217;ultimo IPL del Sistema:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT MESSAGE_TIMESTAMP\n  FROM TABLE(QSYS2.JOBLOG_INFO('000000\/QSYS\/SCPF'))\n LIMIT 1<\/pre>\n\n\n\n<p>Result:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">---\nMESSAGE_TIMESTAMP 05\/05\/2023 19:59:06:012466\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>sapere da quanto tempo il Sistema non viene riavviato (potrebbe aiutare a capire eventuali rallentamenti, aumento delle aree di log, ecc)<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>sapere se il Sistema \u00e8 stato riavviato dopo qualche installazione (ad esempio PTF)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL per ricavare data ultimo IPL Comando SQL per sapere quando \u00e8 stato effettuato l&#8217;ultimo IPL del Sistema: SELECT MESSAGE_TIMESTAMP FROM TABLE(QSYS2.JOBLOG_INFO(&#8216;000000\/QSYS\/SCPF&#8217;)) LIMIT 1 Result: &#8212; MESSAGE_TIMESTAMP 05\/05\/2023 19:59:06:012466 &#8212;<\/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,75],"class_list":["post-3834","post","type-post","status-publish","format-standard","hentry","category-iniziamo-con-alcuni-esempi","tag-as400","tag-db2","tag-iseries","tag-sql","tag-joblog_info"],"_links":{"self":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3834","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=3834"}],"version-history":[{"count":4,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3834\/revisions"}],"predecessor-version":[{"id":3900,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3834\/revisions\/3900"}],"wp:attachment":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/media?parent=3834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/categories?post=3834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/tags?post=3834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}