# IBM i Commands for Infor XA Administrators > Source: https://netray.co/tools/ibm-i-commands-for-infor-xa-admins-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A lookup of common IBM i CL commands for jobs, output, libraries, objects, data and backups, with what each is for. ## Category other-erp ## Erp Infor XA ## Industry Discrete Manufacturing ## Audience - XA administrator - IBM i operator - IT manager ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Command **Key:** command **Type:** text #### Area **Key:** area **Type:** text #### What it does **Key:** purpose **Type:** text **Rows:** **Command:** WRKACTJOB **Area:** Jobs **Purpose:** Work with active jobs, CPU use and status **Command:** WRKSBMJOB **Area:** Jobs **Purpose:** Work with jobs you have submitted **Command:** WRKJOBQ **Area:** Jobs **Purpose:** Work with job queues and the jobs waiting in them **Command:** WRKSBS **Area:** Jobs **Purpose:** Work with subsystems **Command:** ENDJOB **Area:** Jobs **Purpose:** End a job, normally or immediately **Command:** CHGJOB **Area:** Jobs **Purpose:** Change attributes of a job such as priority **Command:** DSPJOBLOG **Area:** Jobs **Purpose:** Display the job log to see messages and errors **Command:** WRKJOB **Area:** Jobs **Purpose:** Work with one specific job and its attributes **Command:** WRKSPLF **Area:** Output **Purpose:** Work with spooled files, such as reports **Command:** WRKOUTQ **Area:** Output **Purpose:** Work with an output queue **Command:** CPYSPLF **Area:** Output **Purpose:** Copy a spooled file to a database file **Command:** DSPMSG **Area:** Messages **Purpose:** Display messages for a user or message queue **Command:** WRKMSGQ **Area:** Messages **Purpose:** Work with message queues **Command:** DSPLOG **Area:** Messages **Purpose:** Display the system history log **Command:** WRKSYSSTS **Area:** System **Purpose:** Show system status, storage and memory pool activity **Command:** WRKDSKSTS **Area:** System **Purpose:** Show disk unit status and percent used **Command:** WRKSYSVAL **Area:** System **Purpose:** Work with system values **Command:** DSPLIB **Area:** Libraries **Purpose:** Display the objects in a library **Command:** WRKLIB **Area:** Libraries **Purpose:** Work with libraries **Command:** CRTLIB **Area:** Libraries **Purpose:** Create a library **Command:** WRKOBJ **Area:** Objects **Purpose:** Work with objects by name and type **Command:** DSPOBJD **Area:** Objects **Purpose:** Display object description including size and dates **Command:** DSPFD **Area:** Files **Purpose:** Display file description, record count and members **Command:** DSPFFD **Area:** Files **Purpose:** Display file field descriptions, to learn column names **Command:** DSPPFM **Area:** Files **Purpose:** Display physical file member contents **Command:** CPYF **Area:** Files **Purpose:** Copy records between files **Command:** CLRPFM **Area:** Files **Purpose:** Clear the records from a physical file member **Command:** CRTDUPOBJ **Area:** Files **Purpose:** Duplicate an object, often used to copy a file before a change **Command:** CPYTOIMPF **Area:** Data exchange **Purpose:** Copy a database file to a delimited stream file such as CSV **Command:** CPYFRMIMPF **Area:** Data exchange **Purpose:** Copy a delimited stream file into a database file **Command:** STRSQL **Area:** Data exchange **Purpose:** Start an interactive SQL session **Command:** RUNSQLSTM **Area:** Data exchange **Purpose:** Run SQL statements held in a source member **Command:** WRKLNK **Area:** Data exchange **Purpose:** Work with objects in the integrated file system **Command:** SAVLIB **Area:** Backup **Purpose:** Save one or more libraries **Command:** RSTLIB **Area:** Backup **Purpose:** Restore a saved library **Command:** SAVOBJ **Area:** Backup **Purpose:** Save specific objects **Command:** RSTOBJ **Area:** Backup **Purpose:** Restore specific objects **Command:** WRKUSRPRF **Area:** Security **Purpose:** Work with user profiles **Command:** CHGUSRPRF **Area:** Security **Purpose:** Change a user profile, for example enable or reset **Command:** DSPAUT **Area:** Security **Purpose:** Display authority to an object **Command:** STRPDM **Area:** Development **Purpose:** Start programming development manager for source and objects **Notes:** Commands are listed by name only to help you recall them. Use F4 to prompt any command and F1 for help. Authority needed varies by command, and some such as ENDJOB, CLRPFM and RSTLIB can cause data loss, so use them with care and with a recent backup. ## Content **Intro:** Infor XA (MAPICS) runs on IBM i, so day to day administration happens in CL commands. This cheat sheet groups the commands that come up most for jobs, output, libraries, files, data exchange and backup, with a one line purpose for each. **Sections:** #### How to use the cheat sheet **Body:** Search for the task, such as spool, backup or csv, or filter by area. On a 5250 session, type the command and press F4 to prompt for parameters. Export the list to Excel or PDF and keep it beside new operators, along with notes about your own library names and job naming standards, which differ from site to site. **Bullets:** - Use F4 to prompt, F1 for help - Add your own library and job names to the export - Take care with commands marked as destructive in your notes #### The commands most used day to day **Body:** For problems, start with WRKACTJOB to find a looping or waiting job and DSPJOBLOG to read its messages. For missing reports, check WRKSPLF and WRKOUTQ. To find a column name, DSPFFD lists the fields of a file, and DSPFD shows record counts. When users report slow response, WRKSYSSTS and WRKDSKSTS show memory and disk pressure. #### Data exchange and safety **Body:** CPYTOIMPF and CPYFRMIMPF move data to and from delimited files in the integrated file system, which is how many sites feed spreadsheets and other systems. Always copy production data to a test library first. Destructive commands such as CLRPFM, ENDJOB and RSTLIB should be used only with a verified save and, where possible, a second person's review. **Bullets:** - Test data loads in a test library - Verify saves before restoring over live data - Record who ran what and when **Cta:** If much of your XA knowledge sits with one operator, we can help capture it and add a read only question layer over your XA data. **Faq:** #### Do I need special authority to run these commands? **Answer:** Many display commands need only normal authority, while system level commands such as work with user profiles, system values and restore need special authorities. Ask your security officer before requesting more authority than needed. #### How do I find the files behind an XA screen? **Answer:** Use the application documentation or file reference for your release, then DSPFD and DSPFFD on the file to see its fields. Job logs and program messages can also reveal which files a program opens. #### Is it safe to query production files with STRSQL? **Answer:** Read only queries are generally safe, but heavy joins can slow the system for users. Run large queries off peak, limit rows while testing, and never run update or delete statements without a backup and approval. #### Does this apply to all IBM i versions? **Answer:** These commands exist across many releases, but parameters and defaults change. Prompt the command with F4 on your own system and check the help text for the version you run. ## Search terms ibm i commands cheat sheet, as400 commands list, wrkactjob wrksbmjob, mapics as400 commands, infor xa ibm i administration, cpytoimpf example, as400 operator commands, iseries cl commands reference --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json