tag:blogger.com,1999:blog-85115820046282940922024-03-12T19:47:54.949-05:00System i (iSeries) Management TipsThe System i Management Tips blog brings over 80 useful tips from Vision technicians.
<br>
<b>The blog has been opened to tips from our followers! For each tip you submit that that is posted on the blog, you'll be contacted to select one item from our selection of Vision-logo items. Examples include coffee mugs, t-shirts, golf balls, flash drives and more!
Send your tips to: <a href="mailto:itips@visionsolutions.com?subject=My%20System%20i%20Management%20Tip">itips@visionsolutions.com</a></b>Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.comBlogger80125tag:blogger.com,1999:blog-8511582004628294092.post-30226411638114833352010-03-26T17:14:00.005-05:002010-03-26T17:50:30.246-05:003/26/10 Additional ways to see the contents of a user space (*USRSPC)Note: This tip expands on the tip: How to see the contents of user spaces, published on 4/17/09.If you have RPG programming skills then you can retrieve the content with the QUSRTVUS API as documented here: V5R4 - http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/apis/qusrtvus.htm V6R1 - http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/apis/qusrtvus.htm Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com9tag:blogger.com,1999:blog-8511582004628294092.post-44119619488834230942010-01-29T18:52:00.001-06:002010-01-30T19:04:19.568-06:0001/29/10 How to determine the jobs or objects responsible for generating journal entries in a journal receiver?You may want to determine what jobs or objects are responsible for generating journal entries in a journal's receiver chain, for example, if you notice that many receivers are being created for the journal.To determine what jobs or objects are responsible for generating journal entries in a journal's receiver chain, create an outfile from the DSPJRN command and run an SQL query on the Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-52033913826006030982009-12-17T19:27:00.003-06:002009-12-17T19:38:39.058-06:0012/17/09 How to search for text in a file at the member levelUse the command: FNDSTRPDM. Simply type "FNDSTRPDM" at a command line and press F4 to list all available parameters for this command. Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-8020443618609097672009-11-22T22:07:00.004-06:002009-11-22T22:16:41.490-06:0011/20/09 Simplify replication of devices between two systems by matching hardware resource namesIs CMN01 a V.32 interface on your source and an ethernet port on your target? That can prevent device descriptions from replicating properly.You can change the resource names so that they match, by using system service tools (SST). You may have to juggle a bit and create temporary resource names in order to move things around (because you can’t have duplicates), but with a little work, you can Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com1tag:blogger.com,1999:blog-8511582004628294092.post-76466876734643817252009-10-21T16:03:00.001-05:002009-10-21T16:06:26.538-05:0010/21/09 Know the impact of using the ENDJOBABN commandIf you use the ENDJOBABN command to end an active job that just won’t go away after the ENDJOB is issued, you need to be aware of the longer term impact of using this command. When you use ENDJOBABN, a marker is set in the system that causes the next IPL to be considered an "abnormal" IPL – that is – the system will behave as if it ended abnormally, instead of in a controlled fashion from a Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-13514976091289728272009-10-02T19:38:00.000-05:002009-10-04T13:54:47.427-05:0010/2/09 How to rapidly set up a network printer using IBM Personal Communications.1. Start the configuration of a new 5250 session. The System name should be the name of your system (or IP address) that you want this printer to be available to. 2. Specify a workstation ID as the name of the printer. (This will also be the OUTQ name on the iSeries.) 3. Select the “Type of Emulation,” to be “Printer” 4. Accept remainder of defaults and press “OK”. Your session should Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com1tag:blogger.com,1999:blog-8511582004628294092.post-24586281914743449942009-09-17T14:18:00.006-05:002009-09-17T14:50:01.941-05:009/16/09 How to obtain further message logging for interactive or submitted jobsTo change the message logging level, and thus gather more logging information on any job, you need to access and change the job parameters per one of the following:- To change your own interactive job, enter the CHGJOB command, then press F4.- To change another interactive job: Locate the job using WRKACTJOB SBS(subsystem), use OPTION 2 next to the job, press F4.- To change a submitted job: Put Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-55816833676081728242009-08-27T22:11:00.000-05:002009-08-28T10:14:57.973-05:008/27/09 How to find the primary key of a file created using DDS (rather than SQL)Primary keys are called Unique keys in iSeries DDS. The Unique key can be held to two places, on the physical file itself or on a logical file based over that physical file.To check the physical file, on a command line use the Display File Description command over the physical file; e.g. DSPFD library/file. Page down the displayed information looking for "Access Path Description." If the Access Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-14775508146866561612009-08-10T13:16:00.005-05:002009-08-10T13:39:16.884-05:008/09/09 Using RUNRMTCMD to tell other systems to perform tasks and run scriptsYou can have Linux, UNIX and Windows servers do tasks and runs scripts right from an i5/OS command line or a CL program. If you use CL, your program will even wait until the other sever completes its task before moving to the next instruction.Use the RUNRMTCMD command and enter the foreign system command in the COMMAND parameter, the IP address or host name in the REMOTE LOCATION parameter, and Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-57349923759432054282009-07-20T08:37:00.008-05:002009-08-10T13:39:47.829-05:007/17/09 How to find journaled files that are regularly clearedIf you are using a logical replication or high availability solution and you have certain files that are cleared on a regular basis, the following command can be used to identify those objects. If the file is cleared then it may be a file that does not need to be replicated, which will save you bandwidth in the replication process. DSPJRN JRN(library/journal) RCVRNG(*CURCHAIN) ENTTYP(CR) Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-46964070031288136082009-06-30T21:19:00.002-05:002009-07-20T08:33:33.860-05:006/30/09 There's a backup version of the controlling subsystem (QCTL)If you’ve changed attributes of the QCTL subsystem and lost track of what the defaults should be, or worse yet you’ve changed the controlling subsystem in some way that the system refuses to IPL properly, there’s a little known “backup” version of the controlling subsystem called QSYSSBSD. It’s specially protected so that it cannot be changed, only displayed. It’s always there, in the QSYS Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com8tag:blogger.com,1999:blog-8511582004628294092.post-6931829967516866282009-06-19T19:09:00.001-05:002009-06-21T00:20:13.958-05:006/19/09 How To Generate a Disk Analysis ReportAnother way to see what is taking up your disk space is to view the i5/OS disk analysis report. To build the Disk Analysis file, use the following command:SBMJOB CMD(RTVDSKINF) JOB(RTVDSKINF) JOBQ(QSYSNOMAX)You can monitor the job by issuing the following:WRKACTJOB SBS(QSYSWRK)Job name = RTVDSKINFOnce the job finishes running, create the print report:SBMJOB CMD(PRTDSKINF RPTTYPE(*LIB)) JOB(Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-11234403464301692842009-06-09T10:38:00.004-05:002009-06-09T10:53:53.621-05:006/08/09 Create a Virtual PrinterUse the following steps to create a virtual printer that will print directly from an output queue to a network deskjet or laser printer. Start System i Navigator on your PC (If you do not have System i Navigator on your PC then it is possible to complete this task using CRTDEVPRT from a 5250 session)Select Basic operations, Printers.Right click and select Add Printer.Use the wizard and accept Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com2tag:blogger.com,1999:blog-8511582004628294092.post-55931233408342059012009-05-29T21:46:00.003-05:002009-06-01T08:20:14.925-05:005/29/09 Working with Spool files on System ASPs or iASPsAn output queue can be created in a library on an ASP or iASP. However, when using the WRKSPLF command you may not see the spool files that exist on the ASP/iASP unless you first set the iASP group using the command SETASPGRP (ASP/iASP Name).Note to programmers: If you do programming with some iSeries APIs that retrieve information about spool files, it is not always necessary to specify the ASP/Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-16049164132188921542009-05-19T17:20:00.003-05:002009-05-19T17:27:29.255-05:005/19/09 How to see scheduled jobs in order of submissionWhen doing various system maintenance and management functions it is sometimes necessary to hold jobs on the Job Scheduler. Instead of using the command WRKJOBSCDE, which presents jobs alphabetically by name, use the command WRKJOBSCDE SEQ(*DATETIME). This will present the list of jobs in the order they are to be submitted, allowing you to quickly find those scheduled jobs that will occur duringVision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-83027738839349718192009-05-08T09:43:00.001-05:002009-05-08T09:45:50.912-05:005/8/09 How to execute a command on a remote system using FTPSimply type the command as you normally would, but have it preceded by "QUOTE RCMD"For example:QUOTE RCMD CHKOBJ OBJ(QGPL) OBJTYPE(*LIB)QUOTE RCMD CALL PGM(Yourpgm/Yourlib) PARM(Parms)Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-68760239761299459172009-04-27T11:42:00.004-05:002009-05-08T09:50:50.668-05:004/27/09 - How to delete a specifc relative record if the file is keyedYou can delete a specific relative record number when a file is keyed and the UPDDTA command can’t do it. Simply use normal OS/400 SQL and run the following:delete from LIBRARY/FILENAME A where RRN(A) = 3The above example deletes RRN number 3. Just replace LIBRARY and FILENAME with library and file names the ‘A’ after file name is needed. Then change the 3 at the end to be the actual RRN number Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-52555448365966929672009-04-17T15:53:00.004-05:002010-03-26T17:49:35.980-05:004/17/09 - How to view the contents of user spacesYou can easily display contents of a *USRSPC by using the EDTF command. Here is a sample syntax:EDTF STMF('qsys.lib/yourlib.lib/yourusrspc.usrspc')Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-50718575627632927312009-04-06T12:53:00.003-05:002009-04-06T14:50:15.919-05:004/06/09 - The menu of menusDon't remember what a menu is called?Why not use the "menu of menus?"The WRKMNU command will display menus alphabetically. They can be displayed by library and/or generically. You can even create a new menu, change an existing one or delete it right from the screen.Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-12627263995268213552009-03-25T21:29:00.005-05:002009-03-25T21:53:13.601-05:0003/25/09 Using the Save While Active command within IBM's BRMS backup management softwareThe following example is for an SAP application environment that is using an iSeries high availability software product, which is typically used for disaster recovery purposes. Because of this, the tape backup is performed on the replication target (backup) system.The data library for the SAP environment is being saved with the Save While Active command:Display Backup Control Group Entries Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-29317726462638113802009-03-16T21:08:00.004-05:002009-03-16T21:15:21.248-05:0003/16/09 Two ways to see what is using disk spaceMethod #1Use the commands: RTVDSKINF and PRTDSKINF. The retrieve command will build a file that can then be printed with the print command by *LIB, *FLR, *OWN, *OBJ, *SYSMethod #2Run a query on file QAEZDISK for more granular detail.Still another method can be found at the blog post located at: http://visionsolutionsinc.blogspot.com/2008/04/easy-way-to-figure-out-what-is-eating.htmlDisclaimer: Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-4059049374213626682009-03-06T22:42:00.000-06:002009-03-08T00:19:51.432-06:003/6/09 How to change System Request optionsAlthough what is displayed on the System Request menu screen isn't easy to change, it easy to change what the options shown on that screen actually do.The commands executed by the system request menu are stored in a message called CPX2313, which is located in QSYS/QCPFMSG. Keep in mind that the commands are not exactly in order, so you have to be careful with making changes to this message Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-40223077642403036522009-02-23T11:28:00.004-06:002009-03-08T00:21:27.115-06:0002/23/09 Learn more about any IPL processWant to know more about an IPL than simply the date and time of the last IPL? Sometimes, the information provided by system values is just not sufficient. For instance,- Did your last IPL take longer than usual?- Did you recently apply PTFs and wanted to know how long that IPL step took?- Need to know how long your system spent doing journal recovery?- Need to know how long it actually takes to "Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com2tag:blogger.com,1999:blog-8511582004628294092.post-38976046234759714442009-02-15T22:13:00.002-06:002009-02-15T22:17:16.818-06:002/15/09 Quickly see every physical and logical file on a systemDisplay the file QSYS/QADBXREF Caution: Never change anything in this file!Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2009, Vision Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-78891977453399404402009-02-05T22:23:00.002-06:002009-02-15T22:11:56.325-06:002/05/09 How to quickly delete multiple unsaved journal receiversIf you need to delete several journal receivers that have not been saved there are several ways to go about it.If you use OPTION 4 from PDM or WRKOBJ screens you will receive an *INQUIRY message for each unsaved receiver telling you that is has not been saved and asking you to Ignore or Cancel. Deleting the receiver from within the WRKJRNA display will give you the same messages.There is a Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0