tag:blogger.com,1999:blog-85115820046282940922012-01-02T00:42:11.337-06:00The 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.comBlogger801100tag:blogger.com,1999:blog-8511582004628294092.post-30226411638114833352010-03-26T17:14:00.005-05:002010-03-26T17:50:30.246-05:00

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.com8tag:blogger.com,1999:blog-8511582004628294092.post-44119619488834230942010-01-29T18:52:00.001-06:002010-01-30T19:04:19.568-06:00

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:00

Use 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:00

Is 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:00

If 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:00

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.com0tag:blogger.com,1999:blog-8511582004628294092.post-24586281914743449942009-09-17T14:18:00.006-05:002009-09-17T14:50:01.941-05:00

To 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:00

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:00

You 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:00

If 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:00

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:00

Another 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:00

Use 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.com0tag:blogger.com,1999:blog-8511582004628294092.post-55931233408342059012009-05-29T21:46:00.003-05:002009-06-01T08:20:14.925-05:00

An 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:00

When 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 during

Vision 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:00

Simply 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:00

You 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:00

You 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:00

Don'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:00

The 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:00

Method #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:00

Although 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:00

Want 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:00

Display 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:00

If 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.com0tag:blogger.com,1999:blog-8511582004628294092.post-69111444127125876352009-01-28T12:27:00.000-06:002009-01-29T17:15:40.290-06:00

The CHGOBJOWN command doesn't accept *ALL as an object name, but you can use a "UNIX-like" approach to the problem through the IFS representation of the i5/OS libraries:CHGOWN OBJ('QSYS.LIB/yourlib.LIB/*.*') NEWOWN(newuser)Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-70466401903828365242009-01-22T22:53:00.002-06:002009-01-24T11:05:15.210-06:00

Have you ever wanted to send a message to all users attached to a group profile? Here is a command and a CL program that you can use to do exactly that. Note: Before you can compile the CL program SNDPGMMSG, you need to create a 132 character physical file named SPOOL132. That is done using this command: CRTPF /SPOOL132 RCDLEN(132)SNDGRPMSG commandSNDGRPMSG: CMD PROMPT('Send Group Message')

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-59000772026501847882009-01-07T18:49:00.006-06:002009-01-19T12:13:00.523-06:00

Many times when enrolling an Integrated File Systems (IFS) object into journaling a message appears stating the attempt was unsuccessful. Typically this outcome occurs because of locks. Unfortunately, there is no WRKOBJLCK command for IFS so an API is needed to display all the jobs that have a lock on an IFS object.Call the API program: CALL QP0FPTOS PARM(*LSTOBJREF '/ifspath/ifsfile' *FORMAT2)

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com2tag:blogger.com,1999:blog-8511582004628294092.post-10882254781284867612008-12-22T09:39:00.004-06:002009-01-07T18:54:24.560-06:00

When a command is prompted (F4) and displayed, position the cursor on the command title at the top of the screen and press F1 for Help.To know more information about a command parameter, when the command is prompted, position the cursor on the parameter and press F1 for Help.To know the list of values for a command parameter, when the command is prompted, position the cursor on the parameter and

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com2tag:blogger.com,1999:blog-8511582004628294092.post-73758796659689998242008-12-22T09:34:00.005-06:002009-01-29T12:26:54.947-06:00

How to find commands when you know the action/verb you want such as ‘Save’ or the subject you want such as ‘Tape Device’From a command line, press F4 to get the Major Command Groups menu. From this menu select the type of commands you want to see (i.e., option 2 will show Verb Commands, option 3 will show Subject Commands). From this list scroll through until you find the verb or subject you need

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com3tag:blogger.com,1999:blog-8511582004628294092.post-45941360314259518892008-12-10T22:54:00.002-06:002008-12-12T09:18:42.552-06:00

Have you ever written a program that you did not want someone to be able to run interactively? The following code example can be used to create a CL program that will get submitted to batch even if it is called from a command line.Note: The following is limited to programs with no parameters, but with some modification specific to the program, it can be made to process a program that has

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com2tag:blogger.com,1999:blog-8511582004628294092.post-41048813911998983752008-12-03T19:03:00.003-06:002008-12-03T19:25:40.162-06:00

Using option 12 of the DSPJOB command may not show an abnormal number of locks, (i.e. it might just show a few object-level locks being held by the job), but if you are having locking issues there may be many “space location” locks that you don’t see. A space location lock is a symbolic locking protocol.Unfortunately, there is no way to see space location lock information from a 5250 green screen

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-67984461059609961762008-11-26T19:11:00.000-06:002008-11-30T19:12:27.265-06:00

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-29385628802037432962008-11-19T22:32:00.003-06:002008-11-19T22:38:34.707-06:00

Ever wonder what happened to one an object that is missing on a system? If not too much time has elapsed, you might be able to track what happened to that object (or set of objects) by viewing the Security Audit journal on the local system (provided you have access to the journal and the Audit Journal is running).Enter the following command:DSPAUDJRNE ENTTYP(DO) OUTPUT(*PRINT) JRNRCV(*CURCHAIN)

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-90730322922347565282008-11-12T19:55:00.000-06:002008-11-13T20:03:00.051-06:00

By default, the WRKACTJOB screen shows commands at the top of the screen, but when you press F21, these commands are hidden and you will see six additional jobs on the screen. 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

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-39499335396791750852008-10-29T22:37:00.004-05:002008-11-05T10:19:11.418-06:00

When using the WRKACTJOB command, the JOB parameter can be used to see all jobs (*ALL appears by default) a specific active job by name, or to select and view multiple jobs using a wildcard.As an example of a wildcard, the following would show all jobs that start with "BATCH":WRKACTJOB JOB(BATCH*)Disclaimer: Vision Solutions makes every effort to provide accurate system management information and

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-50172629388970823242008-10-29T10:31:00.001-05:002008-10-29T22:36:56.514-05:00

When using the WRKACTJOB command, the SBS parameter defaults to *ALL, but you can use this parameter to show one, several or many subsystems.For instance, the following command will show jobs associated with three different subsystems:WRKACTJOB SBS(QBATCH QBATCH1 QBATCH2)Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-41633594410896056882008-10-22T11:21:00.001-05:002008-10-22T16:25:18.408-05:00

To show what remote systems you can access from a local system, simply use the WRKLNK/QFileSvr.400/* command. This will show you the remote system names that are accessible as they will appear as directories.What if the remote system you wish to access does not appear in the list of directories? Simply create a directory of the same name as the system you wish to access. The name of the system is

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-29304490183780541522008-10-15T23:10:00.003-05:002008-10-15T23:20:58.166-05:00

To access the IFS on a remote system, type the following on a command line: WRKLNK/qfilesvr.400/(system name). For instance, if you are on system "ABC02" and want to access the IFS on system "ABC01", the command would be: WRKLNK/qfilesvr.400/ABC01.The resulting screen shows the entire IFS file system on system ABC01. From here, you can do anything in the IFS that you can do if you were locally

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-55435076570705553972008-10-08T22:04:00.000-05:002008-10-09T10:07:51.546-05:00

If you happen to forget a command, or need to verify which command to use, start with the WRKCMD command. Specify *ALL and leave the Library as *LIBL. When you press Enter, a list of all commands will appear with a description of what each does.Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-5384924251009580972008-09-30T10:39:00.001-05:002008-09-30T15:38:44.129-05:00

Use SQL (or any other HLL) to compare character and graphic data in two different products where their database CCSIDs are different (e.g. CCSID 65535 and CCSID 13488). This can be done without handling the data type conversion within SQL itself. All you need to do is to ensure the SQL program is running with job attributes that point to a system CCSID. When this is done, i5/OS automatically

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-37090043036086258632008-09-23T22:47:00.005-05:002008-09-23T22:57:05.676-05:00

To quickly see the fields that are available in a physical file without having to run a SQL statement use the DSPFFD command. Type from command line DSPFFD Press F4 Type the File name and the Library where it is located Press EnterYou will see the all the column names in the file along with their descriptions.This simple command is often superior to running a SQL statement because the names of

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-10084493286260927492008-09-17T10:16:00.003-05:002008-09-17T10:37:34.369-05:00

1. Go to My Computer and click Tools, then select Map Network Drive. 2. Select any drive Letter that in not in use. In the folder section you would put \\systemname\directory you would like access to, for example: \\PROD\TESTING. 3. You will be prompted for your user ID, which is your domain user ID (for example, Vision\AS400 Login ID), and your passoword, which is your i5/OS login password.You

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-54346179845072048932008-09-09T18:00:00.002-05:002008-09-11T08:33:32.552-05:00

When you use an i5/OS command that is an IBM command, if you want to see what your command string is going to look like when it is executed, press F14 from the command line. The Display Command String screen will appear and show you all of the parms that you have changed. The screen will look something like this:Display Command String CPYF FROMFILE(HALA0A/EPIC) TOFILE(QTEMP/EPIC) CRTFILE(*YES)

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-81464430356946562632008-09-01T18:15:00.000-05:002008-09-02T12:20:52.322-05:00

To use a different version of Java as the default runtime environment for a specific user, create a new STMF file on the IFS within the home directory for the user as follows:/home/UserPrf/SystemDefault.propertiesNote: Replace underscored values with appropriate values.This file should contain one line (e.g. 1.4, but it can be any version that is installed on the system), i.e.: java.version=

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com1tag:blogger.com,1999:blog-8511582004628294092.post-16150608332634776872008-08-26T12:30:00.000-05:002008-08-27T12:36:16.250-05:00

Using the WRKLNK command, navigate to the folder that is above the folder you want to delete and type option 2. Press Enter. From the display that appears, type option 9 (Recursive delete) next to the folder you want to remove and press Enter. The folder and all sub-folders will be removed.Disclaimer: Vision Solutions makes every effort to provide accurate system management information and

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-75291899139351170252008-08-19T22:00:00.000-05:002008-08-20T13:52:18.962-05:00

To get to the Command Entry screen from any command line, do a Call QCMD. Once you are on the Command Entry screen, to view a full screen of lines for the entry of your command, press F11. Pressing F11 again brings your screen back to a partial display mode. If you select F10 (with the screen on partial display mode) it will include all detailed messages and commands that you have previously

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-62896628557758927912008-08-12T16:01:00.005-05:002009-03-25T21:27:17.384-05:00

This tip is particularly useful if you are using an iSeries high availability product for disaster recovery purposes. The idea is to create one startup program that will work on two or more systems -- one source code for multiple systems.Use a data area to define the system's role in the iSeries replication environment. For example, the production system data area would have a setting of SRC and

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-12350695314009014062008-08-04T23:29:00.004-05:002008-08-04T23:33:50.184-05:00

System managers who work with journals don’t always realize when they create new journals that an authority can be designated for the journal receiver that differs from the object being journaled.For more information on managing authorities for journals and receivers, see the IBM Redbook Technote on the topic at: http://www.redbooks.ibm.com/abstracts/tips0604.html.Disclaimer: Vision Solutions

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-36055395769829959762008-07-23T17:21:00.005-05:002008-08-04T23:27:27.507-05:00

The System Request menu is basically a shortcut screen that allows you to access some commonly used commands without leaving the your current screen. Accessing the System Request menu can be done in a variety of ways depending on your environment and emulation program. Common ways are: pressing the SHIFT and SysRq keys together, or if using PC emulation, right clicking your mouse and selecting ‘

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-14019189036969527512008-07-23T16:56:00.006-05:002008-07-23T17:28:28.904-05:00

Use the command/parms: EDTF FILE(srclib/srcfile) MBR(srcmbr)You will not be able to prompt the CL commands, but you can cut and paste or simply type the syntax that you want.Press F3 twice, then use the CRTCLPGM to recompile the program.Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-45520097976261478642008-07-14T20:40:00.001-05:002008-07-15T17:45:08.116-05:00

If a job that creates a spool file hangs up with the message, "Reached Maximum number of spooled records for file XXXXXX in library YYYYYY", the printer file has tried to generate spool file records that exceeds the number of records the print job specified. A finite limit to the number of records in a spool file is usually specified in order to control a runaway job from filling up disk space.

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-75884383816698448082008-07-08T15:54:00.014-05:002008-07-08T17:53:01.168-05:00

The following describes two CL programs that can automate your save process so that prior to it starting a program is submitted to batch that creates a job to monitor the message queue for the checkpoint message. When the checkpoint message is received other processes can then be initiated.Create a save program (i.e.:pgmlib/savepgm)PGMCLRMSGQ MSGQ(QUSRSYS/SWAMSGQ)MONMSG MSGID(CPF2403) EXEC(

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-31755149150808233122008-06-30T03:19:00.005-05:002008-09-02T12:20:19.181-05:00

To see the JDK that the System i you are working on uses by default, enter the command:JAVA *VERSION.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. ©

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-89721187155972658202008-06-30T03:08:00.004-05:002008-06-30T03:19:24.555-05:00

This function needs to be run in STRQSH. In order to change the owner of all files and directories recursively run the following command:for eachFile in $(find /directoryToChangeOwner -name '*'); do system "CHGOWN OBJ('"$eachFile"') NEWOWN(userProfile)";doneNote: Replace values in parenthesis with appropriate values. Disclaimer: Vision Solutions makes every effort to provide accurate system

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com4tag:blogger.com,1999:blog-8511582004628294092.post-36269217847348831172008-06-17T19:36:00.005-05:002008-06-17T19:53:32.267-05:00

Deleting logical files can be a time consuming task when you need to delete a physical file due to the number of logical files that have no common prefix to the file name to wildcard.This simple CL program could help:PGM PARM(&SYS1OBJ &SYS1LIB)DCL VAR(&SYS1OBJ) TYPE(*CHAR) LEN(10)DCL VAR(&SYS1LIB) TYPE(*CHAR) LEN(10)DCLF FILE(QADSPDBR)OVRDBF FILE(QADSPDBR) TOFILE(QTEMP/DBRRMV)DSPDBR FILE(&SYS1LIB

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-2680356935406447482008-06-09T12:07:00.004-05:002008-06-17T19:53:48.412-05:00

Type the command CALL QEZSNDMG.Fill in the parameters as follows:-Message needs reply (Y or N)-Interrupt user (Y or N) – will send a break message when Y is specified-Message text (up to 512 characters)-Send to – this is a list and can also use special values of *ALL and *ALLACTPress F10 to send the messageThis will send out the message to all of the workstations that the users are signed on to

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-1779287489708670042008-06-01T12:50:00.005-05:002009-10-21T17:27:56.042-05:00

Occasionally jobs can get hung up causing them to not end on their own. When this happens, as a last resort, you can use the ENDJOBABN command to force the job to end.Editor's note: An expanded discussion on this topic can be found here: 10/21/09 Know the impact of using the ENDJOBABN commandDisclaimer: Vision Solutions makes every effort to provide accurate system management information and

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com2tag:blogger.com,1999:blog-8511582004628294092.post-65874884643255160552008-05-28T14:24:00.003-05:002008-05-28T14:36:12.296-05:00

Use the following command for an easy way to see the journal receivers that are taking up a lot of disk space on your system:DSPOBJD *ALL/*ALL *JRNRCVExample:Display Object Description - BasicLibrary 3 of 87Library . . . . . . : AUDRCV Library ASP device . : *SYSBASType options, press Enter.5=Display full attributes 8=Display service attributesOpt Object Type Size Text_ AUDRCV1270 *

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-33805829409466998782008-05-21T15:23:00.006-05:002008-07-21T12:37:15.407-05:00

Anybody familiar with UNIX or Linux operating systems is aware of the usefulness of symbolic links to folders and files. This basically involves creating a link to a file in another location from the original, allowing people to access or edit the original file from another location.On the System i this can be done by prompting the ADDLNK command. Enter the full IFS path of the object you want to

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-40636536151776549512008-05-13T17:42:00.003-05:002008-05-13T17:46:44.897-05:00

Ever held down the ‘Page Down’ or ‘Page Up’ keys down too long and the screen wouldn’t stop advancing? The easy way to stop it is to simply press the ‘Ctrl’ key.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

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-91736230224917326422008-05-05T16:44:00.003-05:002008-05-05T16:52:14.058-05:00

Step 1:Create a flat file that has a record length of 132 (most spool files have a width of 132).CRTPF FILE(FLATFILE) RCDLEN(132)Step 2: Copy the spool file to the newly created flat file.CPYSPLF FILE(QPDSPAJB) TOFILE(FLATFILE) JOB(*) SPLNBR(1)Step 3: Copy the file to the IFS.CPYTOSTMF FROMMBR('/qsys.lib/library.lib/flatfile.file/flatfile.mbr') TOSTMF('/somewhereintheifs/spoolfile.txt')Disclaimer

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com3tag:blogger.com,1999:blog-8511582004628294092.post-88339268150914188042008-05-01T13:08:00.004-05:002008-05-01T14:12:59.051-05:00

Deleting a physical file can be time consuming at times due to the number of logical files that might are associated with it that have no common prefix to the name of the LF (thus cannot be found with a wildcard search).This short program can help:PGM PARM(&SYS1OBJ &SYS1LIB)DCL VAR(&SYS1OBJ) TYPE(*CHAR) LEN(10)DCL VAR(&SYS1LIB) TYPE(*CHAR) LEN(10)DCLF FILE(QADSPDBR)OVRDBF FILE(QADSPDBR) TOFILE(

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-87681709523896365762008-04-28T18:41:00.005-05:002008-05-01T13:08:41.798-05:00

Step 1. Run the following command :DSPOBJD OBJ(*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(QGPL/OBJLIST)CAUTION: Depending on the number of objects on your system this could take a while so you may want to submit it to batch:SBMJOB CMD(DSPOBJD OBJ(*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE)OUTFILE(QGPL/OBJLIST)) JOB(BLDOBJLIST)Step 2. Go to the interactive SQL processor (STRSQL) and run the following

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com1tag:blogger.com,1999:blog-8511582004628294092.post-46463090044991113552008-04-23T09:11:00.003-05:002008-04-23T09:40:17.387-05:00

Use the command:DMPOBJ OBJ(library/object) OBJTYPE(*DTAQ)The contents will be found in the spool file called QPSRVDMPDisclaimer: 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

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com2tag:blogger.com,1999:blog-8511582004628294092.post-17033826401931839212008-04-18T09:31:00.006-05:002008-04-18T09:49:44.732-05:00

To enable the CTL-X, CTL-C, and CTL-V keyboard shortcuts so that you can delete, copy, and/or paste, click on the “Remap Keyboard Functions” icon (it looks like a little keyboard):Select the “Edit Cut” item in the Function pull down list. Set the Ctrl-X key for this function. Click the “File” menu item and save the keyboard map file. Click the “File” menu item on the 5250 window and save the

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com2tag:blogger.com,1999:blog-8511582004628294092.post-34107993143316569762008-04-14T09:54:00.007-05:002008-04-18T09:49:13.132-05:00

Ever have a job that ends abnormally but does not create a job log?The command CHGJOB *SECLVL can be used to change an active job so that it creates a job log, which will allow you to see what has caused it to end.From the WRKACTJOB screen, find the job and type a 2 (Change) next to the job, then press F10 (Additional parameters)The following will appear under Message Logging:Level . . . . . . .

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-74240903675506438982008-04-07T19:31:00.004-05:002008-04-07T19:48:28.720-05:00

Thinking it is time to run the Reclaim Storage command? Not sure how long it might take? Before you run it, you can see how long the operation took the last time it was excecuted.On a command line type: DSPDTAARA QUSRSYS/QRCLSTG. The screen will display the start and end times the last time a full Reclaim Storage command was excuted.Disclaimer: Vision Solutions makes every effort to provide

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-59187567067119576282008-04-04T12:23:00.004-05:002008-04-04T12:35:31.101-05:00

Your software vendors may ask you to confirm your system information in order to create license codes or PTF (Program Temporary Fix) information. Much information can be gained from system values and data areas.Partition ID: Outside of the Hardware Management Console (HMC), you can find the partition ID in the Display Service Registration Information option on the Electronic Service Agent menu.

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com1tag:blogger.com,1999:blog-8511582004628294092.post-56127823858827104022008-03-28T18:41:00.003-05:002008-04-04T12:36:02.794-05:00

First, ensure communications are set correctly by utilizing the SNDNETMSG (Send Network Message) command to send a test message prior to transferring the spooled file.1. On a command line, type: WRKOUTQ LIBNAME/OUTQ2. Type "1" next to the spooled file you wish to send and press Enter.3. Type the User ID. This will be the user you wish to send the spooled file to.4. Type the name of the machine

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-76336020833791846892008-03-25T19:25:00.004-05:002008-03-25T19:34:37.574-05:00

The following code can be used to process an FTP command via a batch program. Assumptions:The source physical file is labeled QFTPSRC with two source membersThe value FTPIN contains valid FTP commandsThe value FTPOUT is an optional empty source member to contain FTP log statementsCLRPFM FILE(LIBRARY/QFTPSRC) MBR(FTPOUT)OVRDBF FILE(INPUT) TOFILE(LIBRARY/QFTPSRC) +MBR(FTPIN)OVRDBF FILE(OUTPUT)

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-77925978163344448742008-03-10T11:14:00.006-05:002008-04-29T17:49:05.106-05:00

Within most 5250 emulator programs there is a little used featured called a macro. This can save you time and reduce errors. Macros can be used for all kinds of things. For instance, common commands (i.e. a basic spool file look up - WRKSPLF) or a pre-defined query (example: RUNQRY *N ‘name of query’)Here is an example of using a macro for a basic AS/400 sign on. (**NOTE: This can pose a

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com1tag:blogger.com,1999:blog-8511582004628294092.post-60657149564971852292008-03-10T11:10:00.007-05:002008-04-15T00:05:10.650-05:00

Use the following command:RMVJOBSCDE *ALLOr wildcard RMVJOBSCDE XXX***CORRECTION**RMVJOBSCHE *ALL is NOT valid. This was an oversight during the verification process. However the generic version (RMVJOBSCDE XXX*) does work, and will work better if the parameter ENTRYNBR(*ALL) is added to the command as follows: -RMVJOBSCHE JOB(A*) ENTRYNBR(*ALL)This command is valid on the following i5/OS

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com5tag:blogger.com,1999:blog-8511582004628294092.post-62273857715588016012008-03-10T11:07:00.003-05:002008-04-07T20:01:12.690-05:00

How would you like to be able to use the SIGNOFF command to perform any of the three following common connections?SIGNOFF – normal signoffENDGRPJOB – end an active secondary job on a single workstationENDPASTHR – end a session to another systemThis can be accomplished with the following command and control language code.Modified SIGNOFF commandSIGNOFF: CMD PROMPT('Sign Off')PARM KWD(LOG) TYPE(*

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-33856848358096876792008-03-10T11:04:00.002-05:002008-04-07T20:01:56.073-05:00

When a system is performing poorly, in terms of response time, here’s something that can help find the culprit: WRKACTJOB From the display, move the cursor to the CPU column heading and use F16 to sort the jobs by that column. From there, it is easy to determine which jobs are consuming system resources (and how much) at that point in time.Disclaimer: Vision Solutions makes every effort to

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com3tag:blogger.com,1999:blog-8511582004628294092.post-45852012058932737372008-03-10T11:03:00.001-05:002008-04-07T20:02:33.031-05:00

The following command displays installed licensed software information including actual license key for OS/400. Key the following on an OS/400 command line: CALL QSFWINV 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

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-24601880011656319562008-03-10T11:01:00.001-05:002008-04-07T20:03:23.152-05:00

(Requires Qshell 5722SS1 Option 30) Assumption: Directory ABC and all subdirectories need to be removed. Key the following on an command line: QSH CMD('rm -r /ABC') 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

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-7012013879405628452008-02-12T16:58:00.003-06:002008-04-07T19:58:52.224-05:00

Generic evoke request (ability to call batch program on remote system) via SNACLP Source$$EVOKETCL: PGMOVRICFF FILE(QICDMF) ACQPGMDEV(QSNADS)OVRICFDEVE PGMDEV(QSNADS) RMTLOCNAME(SNIC03ND)CALL PGM($$EVOKET) PARM('PROGRAM' 'PSWD' +'USER' 'LIBRARY')ENDPGMRPG SourceFQICDMF O F 80 WORKSTNC *ENTRY PLISTC PARM $PGM 8C PARM $PSWD 8C PARM $USER 8C PARM $LIB 8C EXCPTEVOKEC MOVE '1' *INLROQICDMF E EVOKEO K8

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-67395432968152497692008-02-12T16:57:00.006-06:002008-04-07T20:04:35.201-05:00

If you use a high availability solution and you need to do an emergency switchover, the active history log that is contained in system storage (accessed via DSPLOG) can be replicated to a backup system in order for the history log to be reviewed during an unplanned switch. Using the following CL code*, you can actively poll this storage and store it in an OS/400 DB2 table.DMPLOG: PGMDCL VAR(&

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0tag:blogger.com,1999:blog-8511582004628294092.post-31600327345466952142008-02-12T16:54:00.006-06:002008-04-07T20:05:25.531-05:00

Occasionally, OS/400 Printer device (AFP capable) will have an "orphaned" lock left on the printer device by an abnormally ended writer job, which prevents successful start of the associated print writer. Key the following on an OS/400 command line to clear the lock:CALL QSPENDWA PARM('printer device name')Disclaimer: Vision Solutions makes every effort to provide accurate system management

Vision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.com0