{"id":450,"date":"2026-04-07T10:10:44","date_gmt":"2026-04-07T10:10:44","guid":{"rendered":"https:\/\/fhix.fr\/?page_id=450"},"modified":"2026-04-07T10:10:44","modified_gmt":"2026-04-07T10:10:44","slug":"tips-as400-ibmi-cmd-system","status":"publish","type":"page","link":"https:\/\/fhix.fr\/index.php\/tips-as400-ibmi-cmd-system\/","title":{"rendered":"TIPS AS400 IBMi CMD SYSTEM"},"content":{"rendered":"<ul class=\"wp-block-latest-posts__list wp-block-latest-posts\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/fhix.fr\/index.php\/2026\/02\/12\/afficher-la-version-de-los400\/\">Afficher la version de l&rsquo;OS400<\/a><div class=\"wp-block-latest-posts__post-full-content\"><!-- wp:paragraph -->\n<p>DSPDTAARA QUSRSYS\/QSS1MRI<\/p>\n<!-- \/wp:paragraph --><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/fhix.fr\/index.php\/2025\/10\/06\/copier-un-spoule-dans-lifs\/\">Copier un spoule dans l&rsquo;IFS<\/a><div class=\"wp-block-latest-posts__post-full-content\"><!-- wp:list {\"ordered\":true} -->\n<ol class=\"wp-block-list\"><!-- wp:list-item -->\n<li><code>CRTPF FILE(QTEMP\/SPOULE) RCDLEN(132)<\/code><\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li><code>CPYSPLF FILE(NOM_SPOULE) TOFILE(QTEMP\/SPOULE) <\/code><\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li><code>CPYTOSTMF FROMMBR('\/QSYS.LIB\/QTEMP.LIB\/SPOULE.FILE\/SPOULE.MBR') TOSTMF('\/home\/mon_user\/spoule.txt') STMFCCSID(*PCASCII)<\/code><\/li>\n<!-- \/wp:list-item --><\/ol>\n<!-- \/wp:list --><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/fhix.fr\/index.php\/2025\/09\/29\/utiliser-metabase-pour-surveiller-la-machine\/\">Superviser mon AS400 avec Metabase<\/a><div class=\"wp-block-latest-posts__post-full-content\"><!-- wp:paragraph -->\n<p>Metabase est un outil de visualisation des donn\u00e9es sous forme d&rsquo;un dashboard graphique.<br>Exemple d&rsquo;utilisation :<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:image {\"id\":289,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} -->\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"729\" src=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-9-1024x729.png\" alt=\"\" class=\"wp-image-289\" srcset=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-9-1024x729.png 1024w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-9-300x214.png 300w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-9-768x547.png 768w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-9.png 1070w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<!-- \/wp:image -->\n\n<!-- wp:paragraph -->\n<p>Requ\u00eates utilis\u00e9es pour cette exemple :<br>1) <strong>% occupation disque<\/strong><br><code>SELECT SYSTEM_ASP_USED FROM qsys2.system_status_info<\/code><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>2) <strong>Nombre de travaux int\u00e9ractifs<\/strong><br>SELECT count(*) FROM TABLE(active_job_info()) where job_type=&rsquo;INT&rsquo;<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>3) <strong>Nombre de travaux en message <\/strong><br><code>SELECT count(*) FROM TABLE(active_job_info()) WHERE job_status='MSGW'<\/code><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>4) <strong>Palmar\u00e8s du nombre de spoules par utilisateur<\/strong><br><code>SELECT job_user , count(*) AS nombre FROM TABLE(QSYS2.SPOOLED_FILE_INFO(USER_NAME =&gt;<em>'<\/em>*'))<br>WHERE job_user'QTCP'<br>GROUP BY job_user<br>ORDER BY nombre DESC<br>LIMIT 10<\/code><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>5) <strong>Palmar\u00e8s des plus gros fichiers<\/strong><br><code>SELECT objlib concat '\/' concat objname , objsize<br>FROM TABLE(QSYS2.OBJECT_STATISTICS('*ALLUSR<em>', '<\/em>FILE'))<br>WHERE objowner NOT LIKE 'Q%' AND objattribute='PF'<br>ORDER BY objsize DESC LIMIT 15<\/code><\/p>\n<!-- \/wp:paragraph --><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/fhix.fr\/index.php\/2025\/09\/25\/copier-un-savf-depuis-lifs\/\">Importer un SAVF depuis l&rsquo;IFS<\/a><div class=\"wp-block-latest-posts__post-full-content\"><!-- wp:paragraph -->\n<p> &#8211; Cr\u00e9ation du savf (par exemple dans qtemp) : <br><code>CRTSAVF FILE(QTEMP\/MONSAVF)<\/code><br> &#8211; Importation du savf depuis l&rsquo;IFS :<code><br>CPYFRMSTMF FROMSTMF('\/home\/monprofil\/monsavf') TOMBR('\/qsys.lib\/qtemp.lib\/monsavf.file') MBROPT(*REPLACE)<\/code><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><\/p>\n<!-- \/wp:paragraph --><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/fhix.fr\/index.php\/2025\/09\/02\/agrandir-la-ligne-de-commande\/\">Agrandir la ligne de commande<\/a><div class=\"wp-block-latest-posts__post-full-content\"><!-- wp:paragraph -->\n<p>Sur une ligne de commande : CALL QCMD<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:image {\"id\":159,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} -->\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"129\" src=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-3-1024x129.png\" alt=\"\" class=\"wp-image-159\" srcset=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-3-1024x129.png 1024w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-3-300x38.png 300w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-3-768x97.png 768w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-3.png 1040w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<!-- \/wp:image -->\n\n<!-- wp:paragraph -->\n<p>On obtient 4 lignes :<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:image {\"id\":156,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} -->\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"171\" src=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-1024x171.png\" alt=\"\" class=\"wp-image-156\" srcset=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-1024x171.png 1024w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-300x50.png 300w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-768x128.png 768w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image.png 1045w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<!-- \/wp:image -->\n\n<!-- wp:paragraph -->\n<p>Et pour avoir encore plus grand : F11=Plein \u00e9cran<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:image {\"id\":157,\"sizeSlug\":\"large\",\"linkDestination\":\"none\"} -->\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"469\" src=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-1-1024x469.png\" alt=\"\" class=\"wp-image-157\" srcset=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-1-1024x469.png 1024w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-1-300x137.png 300w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-1-768x352.png 768w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/09\/image-1.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<!-- \/wp:image -->\n\n<!-- wp:paragraph -->\n<p> <\/p>\n<!-- \/wp:paragraph --><\/div><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-450","page","type-page","status-publish"],"_links":{"self":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/pages\/450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/comments?post=450"}],"version-history":[{"count":1,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/pages\/450\/revisions"}],"predecessor-version":[{"id":451,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/pages\/450\/revisions\/451"}],"wp:attachment":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/media?parent=450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}