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 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 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
11/5/08 WRKACTJOB - the JOB parameter
10/29/08 WRKACTJOB - The SBS parameter
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 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 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
10/22/08 How to view remote systems that can be accessed from a local system.
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 the TCP/IP host name or the SNA name of the remote system. Note: The QSERVER subsystem must be active on the remote system that you wish to connect to in this way.
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 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
10/15/08 How to access IFS objects on a remote system.
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 connected to ABC01 (including creating IFS objects, removing IFS objects, etc.).
Next week’s tip will show you how to quickly see what remote systems you can access from a local system, and even how to access a system that you can’t see.
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 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
10/08/08 Easy way to look up and verify i5/OS commands:
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 liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
9/30/08 Use SQL to have i5/OS automatically handle a data type conversion
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 handles the conversion.
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 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
09/23/08 How to always see correct field names for a physical file
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 Enter
This simple command is often superior to running a SQL statement because the names of fields in a file are not always correctly shown when using SQL. The DSPFFD command will always return the correct naming convention of the column names.
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 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, i5/OS and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
