No matter what hat you wear, there's a tool for that!
View this email in your browser
Just today I received a question as to whether we had a tool that could be used to move one (or several) spooled files from one output queue to another. There's a tool for that! I was able to point the gentleman to our MOVSPLF tool which is part of the extensive suite of tools we have for manipulating output.
-- David Dykstal, Chief Architect, TAA Tools

A New Refresh!

Our October 15, 2015 refresh has been released for IBM i 6.1, 7.1, and 7.2. It contains many fixes and enhancements and a new security tool PRTPRFUSR. This tool tells you what all the *ALLOBJ profiles are and who has permission to use them. Details on the whole refresh content are on our web site. Order your refresh today! Drop a note to Ellen or Wilson at

Conference Season

Thanks to everyone who was able to attend Fall COMMON and stop by our booth. Sue and Dave were glad to see you all. We always get great feedback from our current customers and our demo CDs disappeared quickly to (hopefully) new customers.

This last week we attended our first RPG & DB2 Summit. Thanks to Jon Paris, Susan Gantner, Paul Tuohy, and the rest of the crew for putting on an stellar event. We were able to meet many current customers and several new ones at our booth, but we also had a chance to attend several of the educational sessions. These were uniformly excellent. We highly recommend this conference for all developers for the IBM i platform.

Featured Tool - CAPSECINF

Manage Security Settings Over Time

The Capture Security Information tool allows you to capture the current information for user profiles, system values, network attributes, and registration information. A comparison may be made at a later time against the same information captured on a different date.

The following commands are provided as part of the tool:
  • CRTSECINF to create a unique library for the information to be stored in and establish the defaults for what will be captured.
  • CAPSECINF to capture the information.
  • CMPSECINF to compare the information.
  • RMVSECINF to remove old information.
  • DLTSECINF to delete the files and library created by CRTSECINF.
  • RFMSECINF to reformat the files for a new version if needed.
The main working commands are the create, capture, and compare commands. Let's look at these more closely.

CRTSECINF - Create Security Information Structures

This command creates the structures needed for subsequent captures. The captured information is stored in a library that is kept safe from prying eyes. The default library name is TAASECINF. Any library name may be specified, but the library must not exist since it has to be created with the correct security settings.

The library will contain all of the files used for capturing information even if the defaults are set to not capture all of the possible information. No members will exist for the files. The files are created with ALWUPD(*NO) and ALWDLT(*NO), and the library will be created with *PUBLIC(*EXCLUDE).

You may specify what information you want to collect when using the defaults for CAPSECINF. You can set up to capture user profile information, system values, network attributes, and registration information.

The information from CRTSECINF is stored in the Application Value CAPSECINF in TAASECURE where it is used for the CAPSECINF command.

CAPSECINF - Capture Security Information

This (and the corresponding compare) are the workhorses of this tool. For each set of information to be captured, a new member is added to the corresponding file in the library you specified (default is TAASECINF). The member will have the date INcyymmdd.

A prompt override program accesses the values that were entered on CRTSECINF and uses them as the parameter values. If the command is entered without any parameters, the defaults (*DFT) will also access the values specified on CRTSECINF for what information you are interested in capturing.

You will probably want to schedule a job to capture the information on a weekly or monthly basis, whereupon you would use the CMPSECINF tool to see if any significant changes have occurred.

CMPSECINF - Compare Security Information

If changes have been made to your system they will show up in the CMPSECINF command. You name the type you want to compare and a From and To member allowing you to see the changes over a period of time.

Assume you have used the default library of TAASECINF and you want to compare the information captured on Oct 1, 2015 to the information captured on Nov 1, 2015. For user profile information, you would specify:


Special values exist for the FROMMBR and TOMBR parameters to allow you to compare to the *FIRST, *LAST, or *PREV member. *PREV means the member prior to the one that was specified. For example, assume we were capturing information on the first of each month and I ran this command on November 2, 2015. I would get the same results as the command above.


The TOMBR would be the member added previously to the specified FROMMBR.

For more details you can check out the full command descriptions at
Copyright © 2015 TAA Tools Inc., All rights reserved.

unsubscribe from this list    update subscription preferences