TAA Tools

New Tools

The TAA Productivity Tools are updated periodically for new tools, enhancements, and fixes. New versions are shipped multiple times per year.

Because customers move to a new version at different times, the following describes new tools by ship date.

New tools as of Apr 15, 2017

RTVQATTD

The Retrieve QATT File Description (RTVQATTD) command returns the values needed to create a QATT source file. These are the name, record length, and descriptive text of the file.

VRYVRTDSP

The Vary Virtual Display command varies a virtual display or displays off or on, whichever is requested.

New tools as of Nov 15, 2016

DMOSUBF7

The Demo Subfile 7 tool provides a demonstration of using a subfile for the display of an API call. Customers can take advantage of the full source provided to create similar subfile based applications.

DMOUIM

The Demo UIM tool provides a demonstration of using UIM for the display of an API call. Customers can take advantage of the full source provided to create their own uses for UIM-based applications.

DSPACTJOB2

The Display Active Jobs 2 command provides a display similar to the system WRKACTJOB command except that the user can only perform the Display action against the jobs, and jobs are sorted by CPU %. System and subsystem jobs are excluded.

ENDJOBWOL

The End Jobs With Object Locks command ends all batch and interactive jobs holding locks on a specified object.

RTVRELMTH

The Retrieve Relative Month command will calculate and return three data values based on the date specified in the DATE parameter, offset by the number of months in the RELMTH parameter.

New tools as of Apr 15, 2016

WRKDBFUNIT

The Work Database File Unit tool allows you to inspect and set the preferred storage unit for files on your system.

New tools as of Oct 15, 2015

PRTPRFUSR

The Print Profile Users command lists profiles with *ALLOBJ authority, along with profiles that have *USR authority or greater to that profile. The report is generated into a spool file, PRTPRFUSR.

New tools as of Apr 15, 2015

CVTTCPJOB

This tool examines a port to see which jobs are using it and reports the current user profile for that job. This allows you to see what users are signed onto the system through Telnet or FTP.

New tools as of Oct 15, 2014

CPYSPLF4

The Copy Spooled File 4 command splits a spooled file into multiple spooled files based on the number of pages specified. For example you may have a report with 100 pages and you want to split into 10 spooled files of 10 pages each, or you may have a 20 page report and you want a separate spooled file for each page.

DSPSYSPTN

The Display System Partitions command displays information about the current system partition and a summary of all system partitions.

DSPUSRAUT4

The Display User Authority 4 command lists all objects in a library that a named user is not authorized properly to. For example, if the user should have *CHANGE authority to all objects in the library, a line would be listed for each object where the user has 1) no authority 2) is specified as *EXCLUDE, or 3) has only *USE authority.

SCNDBF

The Scan Data Base File command scans one or more members of data base files for up to 20 strings. A listing is output with one line for each time one of the strings is found in a record. The relative record number of the record and the position where the string was found is described.

WRKOUTQ3

Work Output Queue 3 command is similar to the system WRKOUTQ command, but supports additional capability such as all output queues in a library or all libraries and a 'Position To' capability.

New tools as of Jan 15, 2014

CHGMAXMBR

The Change Maximum Members command changes the number of maximum members for one or more data base files in a library based on a specified percentage. Only data physical files are processed. The command defaults to 'check' meaning no changes occur unless ACTION(*CHANGE) is specified.

CHGMSGQ2

The Change Message Queue 2 command allows a change to one or more *MSGQ object types. Not all of the CHGMSGQ parameters are supported. CHGMSGQ2 simplifies making mass changes to *MSGQ objects. For a more complete understanding of the parameters, see the CHGMSGQ command help text. A *MSGQ object owned by one of the system profiles may not be changed.

CHGOBJD4

The Change Object Description 4 command provides a general purpose solution when a program wants to prompt for a CHGxxx command. Only typical object types and attributes are supported. Assuming you have provided a proper interface to CHGOBJD4, the command will complete normally whether the change has been made, the command prompt was cancelled, or the command failed. The ESCMSGID parameter will be blank if a successful change was made.

CHGSAVF2

The Change Save File 2 command allows a change to one or more save files. Not all of the CHGSAVF parameters are supported. CHGSAVF2 simplifies making mass changes to save files. For a more complete understanding of the parameters, see the CHGSAVF command help text. A save file owned by one of the system profiles may not be changed.

CHGUSRPWD3

The Change User Password 3 command allows a command change of a user password that ensures the QPWDxxx system value requirements are met. For example, if you have specified that a required digit exist by use of QPWDRQDDGT. This allows a change to be made by other than the interactive user that still follows your password requirements. CHGUSRPRF can change a password, but does not check the system values.

CNFDLTARA

The Confirm Delete Data Area command provides a confirmation display and allows F6 to delete the data area. The attributes of the data area are shown along with the Both *CHAR and *DEC (up to 15 digits) data areas are supported. The QWCRDTAA API is used.

CPYDIRE

The Copy Directory Entry command retrieves information about the From User ID from the Directory Entries (as seen with WRKDIRE) and prompts for a new entry using ADDDIRE. The existing values for the From User ID are used as the defaults for ADDDIRE with the exceptions of the USRID, USER, and SYSNAME parameters.

CPYSHFSPLF

The Copy Shift Spooled File command allows you to shift the data in a spooled file either left or right and re-prints the spooled file. The file must be capable of being copied by CPYSPLF (this excludes files with graphic characters).

CVTALLSPCA

The Convert All Special Authorities command creates an outfile of all special authorities for one or more users. By default, multiple records are written for each user profile: one record for the user, one for his group profile (if any), one for each supplementary group (if any), and a summary record combining all special authority information.

DEBUG

The Debug tool is not code, but rather a technique to assist in debugging. It can also be used for any function where you are repeating several commands on a command entry display. It allows you to quickly execute a command that you had entered earlier in an interactive job. The Debug tool uses the FAVCMD tool to store the commands.

DSPALLDTAT

The Display All Data Types command lists or displays the data types that are to be included or excluded from a file or files. For example, you can display all fields that have a W (variable length) data type for files in a library.

DSPALLSPCA

The Display All Special Authorities command displays the special authorities for an individual user, the special authorities for his group profile, and the special authorities for each of his supplemental profiles. This allows a review of what special authorities the user is allowed to use.

DSPDBFJOIN

The Display Data Base Join Files command displays or lists one or more join files in one or more libraries. The From and To file information is provided along with the name of the keys from each file.

DSPDUPKEY

The Display Duplicate Key command checks a keyed file that has not been specified for Unique keys to see if any duplicate keys exist. The file is read in keyed order per the key fields defined for the file and compared to the previous record. The relative record numbers of any duplicates are described.

DSPMSG2

Display Message 2 allows several selection criteria to minimize the number of messages that would be displayed or listed. For example, you can display by message ID, message type, job, user, start/end date/time, or the sending program. The DSPMSG2 command may be used on any message queue, but would most likely be used with QSYSOPR.

FIXALLSRC

The Fix All Source command provides a method of making mass changes to member data in a source file based on a 'From value' found in the source. Any type of source is valid to be changed. Because ACTION(*CHECK) is the default, no changes will be made allowing a review of what would be made by ACTION(*CHANGE).

FNDUSRATR

The Find User Attribute command finds objects that have a named user attribute or any user attribute. A listing is displayed or output. User attributes allow a further identification of objects.

HLDJOBUNTL

The Hold Job Until command allows you to release a held job at a specific time. You can either use HLDJOB to hold the job or submit the job with HOLD specified. The job being held cannot be an interactive job. You can release the job either in the current day or the next day. HLDJOBUNTL may be helpful when you want to hold a job for a period of time and avoids having to remember to release the job.

LOCKWAIT

The Lock Wait tool provides commands to check for jobs in a LCKW status as seen with WRKACTJOB. RUNLCKWAIT provides job log messages if jobs are waiting for a lock. SBMLCKWAIT submits a never ending batch job that sends messages to a message queue if jobs are locked. The LCKW value can be caused by either a job waiting for a record lock or an object lock.

MTNJRN2

The Maintain Journal 2 command provides the ability to delete old receivers (and add a new receiver) to one or more journals. Both system and user journals may be specified.

RMVMSGD2

The Remove Message Description 2 command removes a range of message IDs or all messages from a message file. The default provides a listing of the message IDs that would be removed if ACTION(*REMOVE) was specified.

RTVJOBCMP

The Retrieve Job Completion tool retrieves the completion status for a job. Two solutions are provided: 1) RTVJOBCMPM (Retrieve Job Completion Message) and 2) RTVJOBCMPA (Retrieve Job Completion Accounting). Both solution provide for a delay time and a number of iterations to allow a program to wait for a reasonable time.

SNDPGMMSG4

The Send Program Message 4 command is a subset front end to SNDPGMMSG which allows a message ID to be sent from a message file to a message queue. The system SNDPGMMSG command may only be used in a CL program. SNDPGMMSG4 allows any environment and can be helpful when testing either how the message text will appear or to place a message with an ID in a message queue.

WRKIFS2

The Work IFS 2 command is designed for a review of IFS entries, but does not allow any changes to be made. Several selection and sequencing options exist. The WRKIFS command is similar, but allows removal of entries and access to WRKLNK.

New tools as of Oct 15, 2013

CHGDBFINC

The Change Data Base Increments command changes the number of size increments for one or more data base files in a library based on the current percentage of records and a specified new percentage. Only data physical files are processed. The command defaults to 'check' meaning no changes occur unless ACTION(*CHANGE) is specified.

CHGJOBQ2

The Change Job Queue 2 command allows a change of one or more *JOBQ object types. CHGJOBQ2 simplifies making mass changes to *JOBQ objects. For a more complete understanding of the parameters, see the CHGJOBQ command help text. A *JOBQ object owned by one of the system profiles may not be changed.

CHGLF2

The Change Logical File 2 command allows a change of one or more logical files. Not all parameters from CHGLF are supported. CHGLF2 simplifies making mass changes to logical files. For a more complete understanding of the parameters, see the help text for CHGLF. A logical file owned by one of the system profiles may not be changed.

CHKMBRSPE

The Check Member Spelling command checks the spelling of the words in the member text for all members in one or more files in a library. Both source and data members are checked. The command defaults to use the dictionary provided by the TAA Productivity Tools. A specific dictionary or multiple dictionaries may be used.

CHKOBJSPE

The Check Object Spelling command checks the spelling of the words in the object text for one or more objects in a library. The command defaults to provide the dictionary provided by the TAA Productivity Tools. A specific dictionary or multiple dictionaries may be used.

CHKSRCTYP3

The Check Source Type 3 command checks a value to see if it is a valid source type as described by the Programmer Menu. TXT and TXT38 are optional.

CHKTAAQSYS

The Check for TAA Commands in QSYS command checks for TAA command names that have a duplicate name in QSYS. This is intended to assist in identifying if a new system command uses the same name of an existing TAA command.

CHKUSRGRP

The Check User for Group command checks if a user profile is a member of a named group either by the GRPPRF or SUPGRP attributes of the profile. TAA9891 is sent as an escape message if the user profile is not a member of the group. No completion message occurs if the user profile is a member.

CMPLIBAUT

The Compare Library Authority command compares the Create Authority for a library to the objects within the library. If the authority of the *PUBLIC user differs from the library Create Authority, the object is listed. Libraries with an Authorization List used for the Create Authority are not supported.

CRTGENOBJ

The Create Generic Objects command allows you to create a number of generic objects with consecutive names like ABC002, ABC003, etc of any object type. The first object must exist in the library where the duplicates will be created.

CVTJOBLOG2

The Convert Job Log 2 command creates an outfile of one record per batch job that was submitted and has completed. Selection on the completion code (defaults to abnormal job end) may be specified. The command is a slow runner, but the outfile can be used to help understand the failures that have occurred. The command is English language dependent.

CVTMONEY

The Convert Money tool allows a CL program to calculate such functions as how much money is owed each month on a typical mortgage calculation. Several commands are provided.

DLTUNULIB

The Delete Unused Library command deletes libraries that have 1) no objects, 2) all objects within the library have never been used, or 3) the object within the library with the most recently last used date has not been used for a specified number of days. The default is ACTION(*CHECK) so that only a listing is output of what would be deleted.

DSPDUPJBQE

The Display Duplicate Job Queue Entries command displays or lists job queue names that are duplicates in different subsystems. DSPDUPJBQE can be used to help identify problems where the same job queue is used

DSPGRPPRFI

The Display Group Profile Indicator command displays whether a profile is a group profile (has members in its group). You must have *ALLOBJ authority to use DSPGRPPRFI. Use the DSPGRPPRF command to list the members of the group.

DSPNONUSE

The Display Non Use command command lists objects that have not never been used along with size information. This can assist in cleanup of the system. Because of the way last used information is handled on multi-member data base files, the information may not be accurate on multi-member files.

DSPOBJEXCP

The Display Object Exceptions command lists one or more objects that are saved with storage freed, locked, damaged, or where the storage requirement has overflowed the ASP. Multiple libraries may be searched.

DSPOWNOBJ

The Display Owned Objects command is similar to the system DSPUSRPRF TYPE(*OBJOWN) function, but provides size, last used date, and text description also. A summary may also be made by either library or object type.

DSPUNQKEY

The Display Unique Key command displays the number of unique values in the access path fields for a data keyed file (non source). The file does not have to have unique keys. The system provides the number of unique values for the first 4 key fields of a file. This means a count of the unique values for key 1, key 1-2, key 1-3, and key 1-4. One line is listed for each member. The information can provide a better understanding of the data.

DSPUNQKEYT

The Display Unique Key Totals command displays or lists members in one or more data files in a library. The number of unique keys for the first 4 keys of each keyed access path are listed. This can provide a better understanding of the data that makes up the keys of the file.

DUPFILFMT2

The Duplicate File Format 2 command duplicates a file from a physical file to a new file with the same format as the original file. The user must have *USE rights to the file being duplicated. This differs from CRTDUPOBJ which requires *OBJMGT authority.

MOVALLOBJ

The Move All Objects command moves one or more objects from one library to another. An option allows a determination of what processing should occur if the object already exists in the To library. The default moves only objects that do not exist in the To library.

RMVTRLNULL

The Remove Trailing Nulls command will remove trailing nulls (X'00') from an input variable and convert them to blanks (X'40') values. The input variable may be up to 5000 bytes in length. The output variable must be 5000 bytes. A start position may be named. No embedded nulls are changed. Trailing blanks are ignored.

RTVGRPPRFI

The Retrieve Group Profile Indicator command retrieves a *YES/*NO for whether the specified user profile is a group profile. You must have *ALLOBJ special authority to use RTVGRPPRFI.

RTVNXTNAM

The Retrieve Next Name command takes a name value such as 'ABC0001', adds 1 to the digit portion, and returns the next name 'ABC0002'. The number portion of the name may contain 1-9 digit positions, but must be in the trailing position of the name. A rollover such as from a name 'ABC9999' causes an escape message. RTVNXTNAM may be used for objects, members, or your own internal naming convention.

SCNCLPTAA

The Scan CLP TAA Commands command scans the outfile created by CVTCLPCMD for TAA commands. CVTCLPCMD converts all commands found in a source file to one record per command in an outfile. SCNCLPTAA lists each command found in the file that exists in TAATOOL along with the source member and sequence number within the source.

SCNDDSSRC

The Scan DDS Source command scans DDS source for various values such as a string of text in the Functions field such as the word 'JOIN'. All selection criteria must be met to print a record. The command can be helpful when searching for some values that have been used previously.

SCNMBRA

The Scan Member Attributes command scans one or more data base members in a library for attribute values. For example, you can scan for the number of members with more than 1000 records or all members that have a keyed access path. This acts as a simple query to determine the value of attributes of members.

SCNSAVFA

The Scan Save File Attributes command scans one or more save files for attribute values. For example, you could scan for all save files that have more than 100 records. This acts as a simple query to determine the value of attributes of save files.

SWPLIBLE2

The Swap Library List Entry 2 command allows a swap of 2 libraries on the user portion of the library list. For example, if both QGPL and QTEMP are in the user portion of the library list and should trade places, the SWPLIBLE2 will make the swap.

New tools as of Jul 15, 2013

CHGOUTQ2

The Change Out Queue 2 command allows a change of one or more *OUTQ object types. Not all keywords used by CHGOUTQ are supported. CHGOUTQ2 simplifies making mass changes to *OUTQ objects. For a more complete understanding of the parameters, see the CHGOUTQ command help text. An *OUTQ object owned by one of the system profiles may not be changed.

CHGPGM2

The Change Program 2 command allows a change to one or more *PGM object types. Not all of the CHGPGM parameters are supported. CHGPGM2 simplifies making mass changes to *PGM objects. For a more complete understanding of the parameters, see the CHGPGM2 command help text. A *PGM object owned by one of the system profiles may not be changed.

CHKTAACHG2

The Check TAA Change 2 command checks the last change date of objects in TAATOOL against the date the TAA version was installed. Any objects changed after the install date are listed. This allows a review of what has changed since the TAA Productivity Tools were installed. An *ALLOBJ user is required.

CMPIFSED

The Compare IFS Entry Description command compares the major attributes of two IFS objects. A listing is produced if any differences exist. An escape message is issued if differences exist and the command is run in batch or OUTPUT(*PRINT) is specified.

CMPSGNUSE

The Compare Signon to Last Used command allows a check to see if a profile is being used after the last signon date. This could occur if the profile name has not signed on since it was used such as in a SBMJOB command or a job schedule job. User profiles that are not permitted to signon will normally appear.

CMPSTMF

The Compare Stream File command compares two stream files and lists the From and To records that differ. The named stream files are copied to 9999 byte files in QTEMP and compared. If differences are found, the data from each record is listed up to 100 positions.

CVTDISTANC

The Convert Distance command allows a conversion from one type of value such as meters to a different type such as miles. The input value may be up to 9 digits with 2 decimals. The output value may be any of 15/0, 15/2, or 15/5. Conversions can be made for millimeters, centimeters, meters, kilometers, inches, feet, yards, miles, cable lengths, fathoms, and furlongs.

CVTOBJAUTD

The Convert Object Authority Description command converts individual authorities to an authority description of *ALL, *USE, *CHANGE, 'USER DEF', or *EXCLUDE. This can be helpful when dealing with an outfile such as that used by DSPUSRPRF TYPE(*OBJAUT).

CVTOUTQDTQ

The Convert Output Queue Data Queue command converts the entries sent by the system to a data queue if the DTAQ parameter is specified on CRT/CHGOUTQ. This allows a determination of spooled files that were output as opposed to the print accounting function which captures only those files that were actually printed.

CVTRCDLCK

The Convert Record Locks command converts the record locks from all jobs holding record locks on a specific file/member. You must have *JOBCTL special authority to use CVTRCDLCK. The outfile is always RCDLCKP with a format name of RCDLCKR. The model file TAADBJMP in TAATOOL is used.

DLTOLDOBJ

The Delete Old Object command deletes old objects in a library based on the create date of the objects and the number of days specified. If your approach is to create temporary objects in a permanent library and cleanup periodically based on the create date, DLTOLDOBJ may be useful.

DSPCMDKWD2

The Display Command Keyword 2 command displays or prints a simple list of the keywords used by a command. QSYS and TAATOOL command information is supplied in TAATOOL. User commands must be converted to a file using CVTCMDKWD.

DSPMSGDAT

The Display Message Queue by Date command provides a simple listing of the messages in a message queue by date and time. This provides a review of how old messages are in a message queue.

EDTDTAQ

The Edit Data Queue command allows editing of character data in a non-keyed data queue with a maximum entry length of up to 5000 bytes. An interactive display is used for editing and updates, deletions and new entries may be made.

RMVENDPER

The Remove Ending Period command removes an ending period ('.') from an input text value if it exists and returns a variable without the ending period. This can be useful when resending escape messages that may have an ending period.

RNMGENOBJ

The Rename Generic Object command allows a rename of generic objects in a named library. The new generic name value must be less than or equal to the length of the existing generic name. Any characters in the name of an object after the generic name are carried over to the new name. A listing is produced including any errors found.

RTVFLROBJ

The Retrieve Folder Object command allows the retrieval of information about a *FLR object when only the system object name that exists in the QDOC library is known. The system object names may appear from a function such as when using the DSPOBJD outfile. These names do not relate to a user recognizable name. RTVFLROBJ provides a translation from the *FLR object name to the information displayed by WRKFLR.

RTVJOBSTSL

The Retrieve Job Status Loop command allows the current job to delay until another job is in a specified status. For example, if you submit a batch job, you may not want to continue in your program until the batch job is active or on an output queue.

SCNEXTDTA

The Scan and Extract Data command scans a string of data for a value and returns the first n bytes prior to a blank after a successful scan. For example, if you are scanning message text, you might want the value after the word 'library '.

SORTSRC

The Sort Source command allows a range of source statements in a source member to be sorted. The output is always to the SORTSRC member of the TAASORTSRC source file in QTEMP. The default is to sort on the entire source data value. From/To positions may be specified. You may then use the SORTSRC member to copy to wherever it is needed.

WRKUSRAUT

The Work User Authorizations command provides a work display for a user profile's specific authorizations. This excludes the user's owned objects. The outfile from DSPUSRPRF TYPE(*OBJAUT) is used internally to provide the basic information. Options exist to display the object description, display the authorizations, and edit the authorizations.

New tools as of Apr 15, 2013

CHGCLS2

The Change Class 2 command allows a change to one or more *CLS object types. CHGCLS2 simplifies making mass changes to *CLS objects. For a more complete understanding of the parameters, see the CHGCLS command help text. A *CLS object owned by one of the system profiles may not be changed.

CHGDSPF2

The Change Display File 2 command allows a change to one or more display files. Not all of the CHGDSPF parameters are supported. CHGDSPF2 simplifies making mass changes to display files. For a more complete understanding of the parameters, see the CHGDSPF command help text. A display file owned by one of the system profiles may not be changed.

CHGDTAQD2

The Change Data Queue Description 2 command allows a change to one or more *DTAQ object types. Not all of the CHGDTAQD parameters are supported. CHGDTAQD2 simplifies making mass changes to *DTAQ objects. For a more complete understanding of the parameters, see the CHGDTAQD command help text. A *DTAQ object owned by one of the system profiles may not be changed.

CHGJOBD2

The Change Job Description 2 command allows a change to one or more *JOBD object types. Not all of the CHGJOBD parameters are supported. CHGJOBD2 simplifies making mass changes to *JOBD objects. For a more complete understanding of the parameters, see the CHGJOBD command help text. A *JOBD object owned by one of the system profiles may not be changed.

CHKDUPSPLF

The Check Duplicate Spooled File command checks an outfile created by CVTOUTQ for duplicate spooled files. The check is made on the qualified job name, the spooled file name, and spooled file number. CHKDUPSPLF is intended for the case where the system may be creating duplicates.

CHKIFSSAV

The Check IFS Save command displays or prints a listing of IFS objects that need to be archived (saved). An outfile is optional. Using WRKLNK and option 8 (Display attributes), you can see the 'Need to archive (System)' information for an IFS object. It is changed to 'Yes' when the object is saved with a SAV command specifying UPDHST(*YES). CHKIFSSAV allows a review of the objects needed to be saved.

CHKMLTMBR

The Check Multiple Members command checks one or more files to determine those that have more than one member and those that allow more than one, but have 0 or 1 members. Exceptions are displayed or listed. Source files are implicitly bypassed. Only data base data files that can have members are checked (DDM is excluded).

CLRMSGQ2

The Clear Message Queue 2 command allows you to clear messages from one or more message queues based on the number of hours a message has been on the queue. CLRMSGQ2 may be used for any system message queue such as QSYSOPR or QSYSMSG or any user message queue. The command defaults to ACTION(*CHECK) to provide an indication of what would happen if ACTION(*REMOVE) had been specified.

CPYDBFDTAQ

The Copy Data Base File to Data Queue command copies a member of a data base file to a data queue. The data queue must be non-keyed and have a length less than or equal to 5000 bytes. The QSNDDTAQ API is used.

CPYDTAQ

The Copy Data Queue command copies the entries from one data queue to another. Both non-keyed and keyed data queues are supported, but must be of the same type, must have the same key length, and the same sender ID attribute. The entries may be added to or replace the entries in the To data queue. The QSNDDTAQ API is used.

CPYNEWSRCM

The Copy New Source Member command copies new members from one source file to another. A specific member, a generic member, or all members may be specified. If the member in the From file does not exist in the To file, it is copied to the To file. If it exists, it is flagged. A listing always occurs.

CPYSPCDBF

The Copy User Space to Data Base File command copies data from a user space to a data base file. The data base file may be up to 9999 bytes in length. An optional parameter allows copying of less than the full space. If the last data in the space is not the full length of a record, blanks will be appended.

DLTLIB3

The Delete Library 3 command provides a simple front end to DLTLIB and cleans up the low level messages. When the system DLTLIB command is used, low level messages are sent for each object that is deleted. DLTLIB3 cleans up the messages if the library is successfully deleted. If an error occurs, all messages will still exist.

DLTOWNOBJ

The Delete Owned Objects command allows an *ALLOBJ user to delete the objects that are owned by another profile. The command defaults to ACTION(*CHECK) to allow a review of the objects that would be deleted.

DSPAPYPTF

The Display Applied PTFs command displays objects that have a PTF number applied. One, generic, or all objects by type may be displayed in one or more libraries.

DSPDUPPRFA

The Display Duplicate Profile Attributes command displays or lists the profiles that have duplicates for such attributes as Initial Program, Job Description, User Class, etc. This provides a review of where changes may be needed.

DSPLSTPWDC

The Display Last Password Change command lists all or generic profiles by the date the password was last changed. Profiles that are set to PASSWORD(*NONE) are bypassed. The default is for ascending sequence.

DSPMSGCNT

The Display Message Count command displays a list of message queues and the number of messages in each. By default, message queues without any messages are bypassed.

MOVCRTDAT

The Move by Create Date command moves objects from one library to another based on a range of object creation dates specified. Because ACTION(*CHECK) is the default, no objects are moved and a listing describes those that would be moved. If ACTION(*MOVE) is specified, the objects are moved.

MOVMSGD

The Move Message Description command moves one, a range, or all message descriptions from one message file to another. Any message IDs that are moved are removed from the From message file. A listing is displayed or output of all messages moved and any errors that have occurred.

New tools as of Jan 15, 2013

ACTDLTRCD

The Activate Deleted Record command writes an initialized record to a physical file relative record number. The record must be in a deleted status. This makes an active record in the file that can then be updated by other functions. The companion command is DLTACTRCD which deletes an active record.

ADDGRPPRF

The Add Group Profile command adds a Group Profile to one or more user profiles. The Group Profile is added either as the GRPPRF parameter or as a supplemental group (SUPGRPPRF parameter). A listing is output of the changes and any error conditions such as the profile is already specified as belonging to the group.

ADDINZRCD

The Add Initialized Record command adds one or more initialized records to an existing member of a physical file. Initialized records will have valid values in decimal fields, date fields, etc.

CHGPRFPUB

The Change User Profile to *PUBLIC command is designed for the situation where the objects in a library for the *PUBLIC user have different forms of authority and you want to authorize a new user profile to have the same authority as the *PUBLIC user. This would allow you to make the new user profile a group profile for designated profiles and then set the *PUBLIC user to *EXCLUDE to prevent access by non-authorized users. This allows members of the group to have the same authority as they had before.

CHGPRFPUB2

The Change User Profile to *PUBLIC 2 command is designed for the situation where IFS objects in a directory for the *PUBLIC user have different forms of authority and you want to authorize a new user profile to have the same authority as the *PUBLIC user. This would allow you to make the new user profile a group profile for designated profiles and then set the *PUBLIC user to *EXCLUDE to prevent access by non-authorized users. This allows members of the group to have the same authority as they had before.

CLCLRGVAR

The Calculate Large Variable command allows CL to work with character variables that exceed 15 bytes in length and contain up to 30 digits. Simple operations of Add, Sub, Multiply, and Divide are supported. Any values placed in the Factors are right aligned. The return result must be specified as *CHAR LEN(30) and will be right adjusted by default with leading blanks. A return value exists for a minus sign.

CMPDAT2

The Compare Date 2 command provides a simple comparison of a specified date to the current date plus or minus a number of days. A return variable that will contain GE or LT must be specified. The command is very efficient if the dates to be compared are in the current year. CMPDAT2 provides a simple method of determining whether a date is in a range of days from the current date.

CRTALLPRX

The Create All Proxy command checks for or re-creates commands as a proxy type that have the same name as a command in either QSYS or TAATOOL. Normal user commands are bypassed. Using proxy commands is safer for growth and should be used rather than duplicating a command object.

CRTINZRCD

The Create Initialized Record command creates one initialized record from an existing file into a new file. When using the DFT DDS keyword on many physical file fields, you may want to ensure the defaults are set correctly. CRTINZRCD creates an all default record to allow a review. The PRTDB2 command can be helpful in reviewing the values in the new file.

CVTIFSDAUT

The Convert IFS Data Authority command converts the output of the RTVIFSEAUT or CVTIFSEAUT commands individual fields to the description for data authorities that is seen using WRKLNK (option 9 for Work with Authorities). For example, if Read and Execute are the only individual data authorities that are specified, *RX would be returned.

CVTOBJAUT

The Convert Object Authority command creates an outfile of authorities for one or more objects in a library. The model file is QAOBJAUT (same as used by DSPOBJAUT). The outfile is always OBJAUTP with a format name of QSYDSAUT. The system command DSPOBJAUT allows output for a single object.

DSPFMTSEQ

The Display Format Sequence command displays the fields in a physical or single format logical file in various sequences such as by field name or type and length. When a file has a large number of fields, DSPFMTSEQ may be helpful in reviewing the fields in the format.

DSPOBJDMG

The Display Object Damage command displays object damage as reported by the object list API (QGYOLOBJ). This may not be the only damage to an object. If damage is reported, you should re-create any such objects.

DSPTRGSTS

The Display Trigger Status command displays the trigger status of the programs for one or more files in one or more libraries. An 'escape' parameter exists to allow you to send an escape message if one or more programs are disabled or inoperative.

EXPFIL

The Expire File tool is a series of commands that allow you to set an expiration date for a file of any type. The system supports an expiration date for members, but not for files. You must have *ALLOBJ authority to use any of the commands in the EXPFIL tool.

RTVMSGD3

The Retrieve Message Description 3 command retrieves the format of the replacement data descriptions for a specific message ID. A large variable is returned made up of 20 byte elements for up to 49 replacement descriptions. Each element contains the type, the length, and the number of decimal positions if any. The QMHRTVM API is used.

SCNDBFFLD2

The Scan Data Base Field 2 command is intended for name and address data base files when some pieces of a name and address are known but not all. SCNDBFFLD2 scans up to 5 character fields for up to 5 15 byte strings each. For example, if you know a string of letters from a name and a few from the address, SCNDBFFLD2 can help find the record.

TRGSAMPLE

The Trigger Sample tool provides some sample objects for learning how to write a trigger program. Starting with a sample that uses standard field names for basic trigger fields and your own field names for your data base file makes it simple to write a trigger program. You must copy the code from the TAA Archive to be able to work with it.

UPDPFILE2

The Update PFILE 2 command updates one or more LF source type (not LF38) members to change the PFILE keyword to a library qualified value. This allows the source to be changed to indicate that the LF should be built over a PF in a specific library. If the existing physical file is on the library list, attempting to create the new logical file over a copy of the physical can often result in the logical being built over the wrong physical file.

WRKOWNOBJ

The Work Owned Objects command provides a work display for a user profile's owned objects. The outfile from DSPUSRPRF TYPE(*OBJOWN) is used internally to provide the basic information. Various options exist to work with the objects such as change, delete, display, duplicate, etc.

New tools as of Oct 15, 2012

CLRJOBQ2

The Clear Job Queue 2 command clears selected jobs from a job queue. Jobs may be cleared based on a combination of selection criteria such as job, user, status, and priority. At least one selection type must be made. A job must satisfy all selection types specified to be ended. A 'check option' exists to allow a determination of which jobs would be ended.

CLROUTQ3

The Clear Output Queue 3 command clears selected spooled files from an output queue. Spooled files may be deleted based on a combination of selection criteria such as job, user, form type, status, and priority. At least one selection type must be made. A spooled file must satisfy all selection types specified to be deleted. A 'check option' exists to allow a determination of which spooled files would be deleted.

CPYMSG

The Copy Message command copies one or more messages with a specific message ID from one external message queue to another. The message is copied to the To queue by the use of SNDPGMMSG. A selection by job, user, and job number may also be made.

CPYPGMQM

The Copy Program Message Queue Message command copies one or more messages from the current job's program message queue to an external message queue. You must use RTVMSGKEY to mark the boundary of where messages should begin to be sent from. CPYPGMQM may be used in special debugging situations or on a normal basis to capture problem determination information instead of the entire job log.

CVTJRNRCVD

The Convert Journal Receiver Directory command creates an outfile with one record per journal receiver for a specific journal. The API QjoRetrieveJournalInformation is used. The outfile is always JRNFILP with a format name of JRNRCVR. This is the same outfile as was used by CVTJRNA.

CVTOBJD6

The Convert Object Description 6 command creates the OBJDSCQ outfile of objects similar to DSPOBJD. However, the output records contain only the object, library, object type, object attribute, user attribute, and text description. The advantage of this approach is that the system does not have to determine the size of the objects. If a file has many members, the basic information can be retrieved quickly.

DSPEMTAUTL

The Display Empty Authorization List command displays Authorization Lists (not owned by QSYS) that do not control any objects. This includes library objects, IFS objects, and DLS objects. An option exists to include all Authorization Lists (not owned by QSYS).

DSPEMTMSGF

The Display Empty Message File command displays one or more message files that have no message IDs. A flag may be set if the message file has not been used in the last n days. An option exists to list all message files. DSPEMTMSGF can be helpful in cleaning up unused message files.

DSPEMTSAVF

The Display Empty Save File command displays or lists one or more save files that have no objects. The default is to bypass save file names beginning with Q as there may be many PTF save files in existence.

DSPEMTSPC

The Display Empty User Space command displays or lists one or more User Space objects where the User Space contains only the initial value described when CRTUSRSPC was used. An option exists to list all User Space objects. DSPEMTSPC can be helpful in cleaning up unused User Space objects.

DSPIPLHST

The Display IPL History command displays or lists the dates and times that an IPL has occurred within a range of dates. The inclusion of the normal power down entries is optional as well as IPL completion. You must be using the CVTQHST2 tool command to first convert the QHST information.

DSPOBJ2

The Display Object 2 command provides a subfile display of one or more objects. The display format is similar to WRKOBJ, but supports only a single option 5=Display. This invokes the TAA DSPOBJD2 command which provides other display options such as DSPOBJAUT and the F8 option which changes based on the object type to allow a display of additional details.

DSPPTFSAVF

The Display PTF Save File Summary command provides a summary of save files for each release and product ID combination. This allows a review of how much space is being taken by PTF save files in QGPL.

DSPWTR

The Display Writer command is similar to the system WRKWTR command, but allows only display options plus describing the number of files in the associated output queue. The command is intended for end users who need to display information about one or more writers, but should not be able to make any changes. An optional method of displaying the output queue associated with the printer is provided.

DSPWTRSTS

The Display Writer Status command displays the status of a writer. The printer device name must be entered. No change options are supported. This allows typical end users to determine the writer status without providing options to change.

DUPCHAR

The Duplicate Characters command duplicates a string of 1 to 50 characters to a return variable. An output length must be described. The return variable must be 32,000 bytes. DUPCHAR can be used as a testing aid or for other unique situations.

EDTLRGVAR

The Edit Large Variable command provides editing for a large character variable that contains numeric data. Some system functions return large character variables that exceed 15 digits and place them in *CHAR variables. A *CHAR input value of up to 30 bytes is supported. The return CHROUT value must be declared as *CHAR LEN(43).

SCNQHST

The Scan QHST command scans QHST information for a string of characters. You must first convert the QHST information using the CVTQHST2 command of the DSPQHST2 tool. Selection of which messages to scan may be made on a date range, Job, User, Job number, and Message ID. The scan occurs on the first level text and the message data of the each message.

WRKJOBQ2

The Work Job Queue 2 command is similar to the system WRKJOBQ command, but allows all or a generic named job queue in a named or generic library. Similar options exist as with WRKJOBQ to work with, hold, release, etc. If you have multiple job queues in the same library, WRKJOBQ2 can be helpful in reviewing the jobs.

WRKROMNUM

The Work Roman Numeral tool provides 3 commands. CVTFRMROM converts from a Roman Numeral such as LX to a decimal value. CVTTOROM converts from a decimal value to a Roman Numeral value. WRKROMNUM provides a work display with both functions.

New tools as of Jul 15, 2012

ADDHEX

The Add Hexadecimal command adds or subtracts two hexadecimal or decimal values and returns either or both a hexadecimal or decimal value. Either unsigned or signed hex values may be entered. ADDHEX can be helpful when viewing dumps or user spaces.

CHGDTAQD

The Change Data Queue Description command changes one or more attributes for a data queue. Only standard data queues are supported (not DDM data queues). The API QMHQCDQ is used. Not all attributes are supported by the API.

CHGFUNCNAM

The Change Function Name command allows you to change the description of the Function field on WRKACTJOB to provide a better indication of what a job is doing. The command must be used in a CL program and not from a command entry line. The value on WRKACTJOB would appear as USR-xxxx where xxxx is the 10 bytes specified on CHGFUNCNAM.

CHKCCSID

The Check CCSID command checks one, generic, or all objects in a library for a specified CCSID. An escape message (TAA9891) is sent if any exceptions exist and a listing is displayed. Only the object types that support a CCSID are checked.

CHKDEC

The Check Decimal command checks a string of up to 512 bytes for whether only digits 0-9 exist. Embedded blanks are considered invalid. A check for a leading and trailing minus sign is optional.

CHKJOBSTS

The Check Job Status command provides a simple test to determine if a job exists and what the status is (such as *JOBQ, *ACTIVE, or *OUTQ). A job type such as INT or BCH may also be specified. An exception message is optional if more than one job meets the criteria.

CHK1STMBR

The Check 1st Member command checks one or more files to determine if the first member has the same name as the file. Exceptions are displayed or listed. Source files are implicitly bypassed. Only data base data files that can have members are checked (DDM is excluded).

CLRGENSRC

The Clear Generic Source command clears generic members in one or more source files in a specified library. Special values such as *STD may be used for the source file name to clear generic members from source files such as QCLSRC and QCMDSRC. The default is ACTION(*CHECK) which describes in messages the members that would be cleared.

CVTJRNOBJ

The Convert Journal Objects command converts the objects that are being journaled from a specified journal to an outfile. Different object types are handled including IFS objects. The outfile is always CVTJRNP which uses the model file TAAJROTP and a format name of JRNOBJR.

DLTGENPRF

The Delete Generic Profile command deletes profiles using a generic user profile name. User profiles starting with the letter 'Q' or owned by the system cannot be deleted. The default is ACTION(*CHECK) which does not delete any profiles.

DLTLSTUSE

The Delete Last Used command deletes objects in a library based on the last used date and the number of days specified. If an object has never been used, the create date is used instead. DLTLSTUSE provides a cleanup when objects are no longer being used.

DSPEMTLIB

The Display Empty Libraries command displays or lists one or more libraries that have no objects. The command performs quickly as the simplest form of the API to retrieve object information is used.

DSPJRNOBJC

The Display Journal Object Counts command displays or lists counts of object types that are being journaled to a named journal. This includes data base files, members, access paths, data areas, data queues, IFS objects, command definitions, libraries, and journal receivers.

DSPNETSVRA

The Display NetServer Attributes command displays or lists the attributes associated with the i5/OS NetServer. This includes both the current and pending attributes.

DSPNETSVRS

The Display Net Server Statistics command displays the current i5/OS NetServer statistics. The RTVNETSVRS command is used internally which runs the QZLSOLST API.

RTVCCSIDPF

The Retrieve CCSID From PF command retrieves the CCSID from a physical file. If the file has multiple CCSIDs, TAA9896 is sent as an escape message.

RTVJRNOBJC

The Retrieve Journal Object Counts command retrieves summary information for different object types that are being journaled to a named journal. The API QjoRetrieveJournalInformation is used. The counts are kept by the system (the individual object information is not read).

RTVNETSVRA

The Retrieve NetServer Attributes command retrieves attributes about the NetServer. Both current and pending attributes may be retrieved.

RTVNETSVRS

The Retrieve NetServer Statistics command retrieves the current statistics about the NetServer such as the number of file opens and the average response time. The QZLSOLST API is used.

WRKADDHEX

The Work Add Hexadecimal command provides a work display for adding a hex or a decimal value to a hex or decimal value. The hexadecimal values may be entered as either unsigned or signed values. The result is returned as both hex and decimal values. Help text is provided for the display.

New tools as of Apr 15, 2012

ADJTIM

The Adjust Time command adjusts the time of day clock. The adjustment is specified either plus or minus in microseconds. The adjustment period occurs over a period of time such as it may take several minutes for a few seconds to be adjusted. The time for the adjustment to take place is also dependent on hardware speed. The QWCADJTM API is used.

ANZCLPCMD

The Analyze CLP Commands command analyzes the CLP commands in the CLPCMDP file created by the CVTCLPCMD TAA tool. A summary by command name is listed. Selection can occur by such things as a source file name and library.

CHKLVLMSG

The Check Low Level Message command allows you to monitor for a message ID sent by a command that does not send an escape message. The message being sent must be from a message file (it cannot be an 'impromptu' type). See the example in the tool documentation for how to use CHKLVLMSG.

CMPDBF3

The Compare Data Base File 3 command compares a member from two data physical files. The files are copied to temporary files in QTEMP and a logical file is built over each file with the key as the entire record. The From file is then read and an attempt is made to to randomly access the same key in the To file. Exceptions are noted. The process then repeats for the To file.

CPYFRMSTM2

The Copy From Stream File 2 command is a front end to the system CPYFRMSTMF command. CPYFRMSTM2 uses a normal object prompt for a file and member to allow a simple copy from an IFS stream file to a data base member or save file. Only a member of a program described physical file, a member of a source physical file, or a save file may be copied to.

CPYSPLF3

The Copy Spooled File 3 command splits a spooled file into multiple spooled files based on a change in value of the data at a specific line and position of each page. Assume you have a report by salesman for all salesmen and want to split the report so there is separate spooled file for each salesman. The salesman number must be listed at the same location on each page, but does not have to be on the first line.

CPYTOFLAT

The Copy to Flat File command copies an externally described file to a flat file (a single field file). Decimal and binary fields are converted to character and an extra position is added for the sign value for all decimal fields. The flat file must not exist and is created by the command with a length large enough to hold the data. CPYTOFLAT can make a human readable data base file.

CPYTOSTMF2

The Copy To Stream File 2 command is a front end to the system CPYTOSTMF command. CPYTOSTMF2 uses a normal object prompt for a file and member. The TOSTMF name defaults to allow a simple copy from a data base member to an IFS stream file in the user's home directory. Only a member of a program described physical file, a member of a source physical file, or a save file may be copied.

CVTAUTLOBJ

The Convert Authorization List Objects command converts information about library objects, IFS objects, and or *DLS objects for one or more Authorization Lists to an outfile. Each object is represented by one record which includes the full path name. Library objects are also described with their library names.

CVTCLPCMD

The Convert CLP Command command converts CL commands from CL type source to an outfile. One record would be written for each command with the identifying information such as member name, sequence number, and last change date. Some commands such as SBMJOB or IF which contain a sub command will also cause a record to be written which is identified as a sub command.

CVTOBJDAT

The Convert Object Description Date command is intended for converting the MMDDYY format used in the date fields of the DSPOBJD outfile. The date is returned in the CYYMMDD format. The CPP may be called directly.

DSPAUTLOB2

The Display Auth List Objects 2 command differs from the system DSPAUTLOBJ command by 1) providing *IFS and *DLS objects in addition to library objects and 2) allowing a generic name or all Authorization Lists. The full path name (up to 5000 bytes) is displayed or listed.

DSPCLPCMD

The Display CLP Command command displays commands from the CLPCMDP file created by CVTCLPCMD. Various search criteria such as the source file library may be named. DSPCLPCMD provides a fast access for where a specific command name has been used.

DSPDBFFLD

The Display Data Base Field command displays the attribute information for a field in a physical file or a single format logical file. The attributes include such things as the length, decimal positions, buffer position in the record, text, and column headings.

DSPLIBAUT

The Display Library Authority command provides a listing of one, generic, or all objects in a library with the individual authorizations to objects. One line is output for each authorized user. Selections can be made by different parameters such as object type.

DSPTIMADJ

The Display Time Adjustment command displays the information regarding a time adjustment. See the TAA command ADJTIM for a method of changing the time of day clock forward or backward n seconds. DSPTIMADJ displays the information of whether an adjustment is being made and if so how much time is needed to complete the adjustment. The RTVTIMADJ command is also included which uses the QWCRTVTM API.

RMVEQLSRC

The Remove Equal Source command removes members from a test type of source file that are a 100% match to a corresponding member in a production type of source file. The default is ACTION(*CHECK) to allow you to see what would be removed by ACTION(*REMOVE). RMVEQLSRC can purge the members that are no longer needed in a test type of source file.

SBMFTPCMD

The Submit FTP Command command submits a single command to run on another System i that is connected via FTP. It could be another LPAR partition on the same physical hardware. Like SBMNETJOB or SBMRMTCMD, SBMFTPCMD provides a simple method of submitting a job to another system, but uses the more popular FTP protocol.

SNDOBJMAIL

The Save and Mail Object command simplifies sending objects as an attachment to an Email. The command uses the sub tools SAVOBJIFS and SNDIFSMAIL to create a save file in QTEMP, save the object(s), copy the save file to an IFS stream file, and attach the stream file to an Email which is sent using the SNDDST system command. The TAA Tool RSTOBJIFS may be used to restore the object(s).

SNDSPLPDF

The Send Spooled File as a PDF command sends a normal spooled file as a PDF to one or more users. This allows the end user to view the information with a technique that he may be more familiar with.

New tools as of Jan 15, 2012

ANZOUTQ

The Analyze Output Queue command provides summary information for various attributes of spooled files in an output queue such as by form type, by user, by schedule, by open date, etc. For each category, a count is also supplied. ANZOUTQ provides a good summary of what exists.

CHG128PWD

The Change 128 Password command is intended for those environments using 128 byte passwords where a change to a user password should be replicated on one or more systems.

CHKAUDLOGP

The Check AUDLOGP command checks audit entries for valid changes to the AUDLOG TAA Tool AUDLOGP file. CHKAUDLOGP helps ensure that the AUDLOGP file is a true representation of the QAUDJRN journal. You must be using the QAUDJRN journal and the AUDLOG tool.

CHKJOBACGP

The Check JOBACGP command checks audit entries for valid changes to the JOBACG TAA Tool JOBACGP file. CHKJOBACGP helps ensure that the JOBACGP file is a true representation of the QACGJRN journal. You must be using the QACGJRN journal and have set auditing for the JOBACGP file.

CHKMSGID

The Check Message ID command checks if a message ID exists in a message file. The command completes normally if the message ID exists and sends TAA9891 as an escape message if it does not.

CHKTAACRT

The Check TAA Create System command provides a check of all objects in TAATOOL to determine if they have been created on a TAASYSnn system. A listing is produced of any exceptions. It is not an error to create your own version of some TAA function, but CHKTAACRT provides an auditor with a tool to review if changes from the shipped version have occurred.

CMPJOBA

The Compare Job Attributes command compares the attributes of two jobs. A display or listing is output of any differences found. When two jobs differ in how they operate, CMPJOBA may be helpful in identifying why they differ. This tool was introduced in 7.1.

CMPSPLFA

The Compare Spooled File Attributes command compares many of the spooled file attributes between two spooled files. A display or listing is output of any differences found. When two spooled files differ in how the output occurs, CMPSPLFA may be helpful in identifying the differences.

CVTTIMSTM

The Convert Time Stamp command converts a time stamp of 26 bytes to a return data structure. Individual fields in the data structure contain the the date and time in various formats such as CYMD, HHMMSS, the edited date, and the edited time. The CPP (TAATINYC) can also be called from a HLL program.

DLTPNDJLG

The Delete Pending Job Log command deletes job log information (not QPJOBLOG spooled files) where the job log information is in a 'PENDING' status. A 'number of days' pending may be specified to delete only the job log information that has been pending for n days. Specific, generic, or all jobs/users may be named. The QWTRMVJL API is used.

DSPJOBTYPD

The Display Job Type Description command displays the codes and descriptions of different job types. Both the three character codes used on WRKACTJOB and the one character codes used in APIs are displayed with the corresponding descriptions.

DSPSPLFINF

The Display Spooled File Information command displays the number of spooled files for one or all users. DSPSPLFINF uses the RTVSPLFINF command to retrieve the information which uses the QSPSPLI API.

FNDSPLF

The Find Spooled File command can assist when you are trying to find a spooled file, but you are not sure of the name, the job, the form type, etc. FNDSPLF allows you to identify one, generic, or all output queues that should be searched for whatever information you have such as the form type or some string of characters within the form type. Most of the selection options supported by FNDSPLF allow this type of searching.

LUVSEU

The Love SEU command blanks out the text of the EDT0630 message of QEDTMSG in QPDA that is used to describe the 'modern alternative to SEU'. If you love SEU, you can blank out the message and prevent having to see the words over and over again. The message ID changed is EDT0630.

RNMGENSRC

The Rename Generic Source command allows a rename of generic members in one or more source files in a library. A single source file, all source files, or special values for source file names such as *STD may be used.

RTVOBJD4

The Retrieve Object Description 4 command allows you to retrieve the basic information about the first or only object of a specific name. The library and object type default to *ALL. A total number of objects that match the name is returned. If more than one object has the same name, messages are sent describing the first 30.

RTVUTC

The Retrieve Universal Time command retrieves the coordinated universal date and time (UTC). UTC is based on an atomic clock with leap seconds added at irregular intervals to synchronize with the earth's rotation. It may be used interchangeably with Greenwich Mean Time if sub second precision is not required. UTC may be useful when dealing with data from around the world.

SECLOG

The Security Log tool is designed to assist in auditing *ALLOBJ users. The SNDSECLOG command is intended to be used as the first command of an initial program for such a user. The command displays a screen and requires the user to enter a 'purpose' of why he is signing on. The command then sends a journal entry to the QAUDJRN journal with the 'purpose'. Other SECLOG commands are used to convert and display the information to assist in auditing *ALLOBJ users.

STRWTR

The Start Writer command is intended to be used to start either a local or remote output queue. Based on the named output queue, a command prompt appears for either STRPRTWTR or STRRMTWTR.

WHOIS

The 'Who Is' command provides basic information about a user profile including the last signon date and whether the user has an active job. The information is displayed or listed. You must be authorized to the TAARTVUSR2 authorization list.

New tools as of Oct 15, 2011

CALC

The Calculator tool is a series of commands that allow you to use the system as a simple add/sub calculator and provides an optional listing. The CLCFILP file must be created first. Many members may exist in the file thus allowing both temporary and permanent lists to be created and changed. Each amount entered may have an optional text description. The last date changed exists for each record.

CHGSGNERRT

The Change Signon Error Text tool allows changing of the error message text for the two invalid signon messages. CHGSGNERRT changes the text to a common value. The default text is 'Invalid signon.' The RSTSGNERRT command restores the message text to the original values if needed.

CHKOBJALL

The Check Object All command provides a simple check to see if an object name exists on the system. The library qualifier and the object type default to *ALL. The TAA9893 escape message is sent if the object does not exist.

CHKSPLCTL

The Check Spool Control Authority command checks for the special authority *SPLCTL in the current user profile or as an adopted function. If the user does not have the function in his job, the CPF9898 escape message is issued. Standard text describing the error is the default.

CMPMSGQ

The Compare Message Queue command compares the message text of messages in two different message queues. The first 256 bytes of each message is compared and any differences are flagged. If you are using message queues for an application where the messages are data rather than text, CMPMSGQ may be helpful when a duplicate message queue is required.

CPYCVTOUTQ

The Copy CVTOUTQ command provides a copy with selection of the outfile (OUTQP) created by the CVTOUTQ command. CVTOUTQ creates one record per spooled file with the attributes of each spooled file for all spooled files in an output queue. If an output queue contains a large number of spooled files, CPYCVTOUTQ can be used to create a subset to allow simpler processing.

CRTTAAPRX

The Create TAA Proxy Command command should be used when a TAA command needs to be duplicated to a user library. A proxy command uses the command version in TAATOOL. This allows one set of authorizations to exist and prevents errors caused by typical changes to a TAA command in a future TAA version.

CVTIMGCLG2

The Convert Image Catalog 2 command converts the image catalog entries for an Optical image catalog to a data base file. The output file is always IMGCLGDP with a model file named TAACLGDP and a format name IMGCLGE2.

CVTPRXCMD

The Convert Proxy Command command converts from a command object one record for each command in a proxy command chain. One record will always exist for the actual command in the chain with a type of *CMD. The QCDRCMDI API is used. The outfile is always PRXCMDP which uses the model file TAACMFOP with a format name of PRXCMDR.

DSPALLPRX

The Display All Proxy Commands command displays or lists all proxy commands for an actual command. An actual command may have several proxy commands either on the same chain or as separate chains. DSPALLPRX will help you if you are trying to identify all the proxy commands created for an actual command.

DSPDAT

The Display Date command provides a convenient method of displaying information about the current date or any date in a range of Jan 1, 1941 to Dec 31, 2040. The fully spelled out date, the day of the week, the week of the year, and other values are shown.

DSPJOBSCDC

The Display Job Schedule Calendar command displays the jobs that are scheduled to run from the system job scheduler for the next 7 days (beginning tomorrow). The listing describes the jobs to be submitted by date and time. DSPJOBSCDC provides a good review of the jobs that will be submitted by the system job schedule function.

DSPOBJSRCC

The Display Object Source Change command lists objects in a named library where the change date of the source member that was used to create the object is more current than the object create date. If the member does not exist, it is flagged. If a program was created from modules, the source for the module with the most current source change date is used for the comparison.

DSPTXTCNT

The Display Text Count command is designed for an analysis of TXT type members in a source file, but may be used on any source type. One, generic, or all members in a source file may be analyzed. Total records and blank records are always counted. Up to 5 comparison groups (such as all the ABC values in a From/To location within a source record) may also be compared for an equal value or scanned for a value.

LOOKUP3

The Lookup 3 command provides a simple lookup capability to check whether an argument exists in an array. The array can be a large CL variable of up to 5,000 bytes. A generic search argument is supported.

MOVJOB

The Move Job command moves one, generic, or all jobs from one job queue to another. Selection may be made on a specific or generic job or user name. MOVJOB simplifies moving jobs.

RTVIMGCLGA

The Retrieve Image Catalog Attributes command retrieves the general attributes about an image catalog. This includes the type, the status, the number of directories, etc. The QVOIRCLD API is used.

RTVSPLFINF

The Retrieve Spooled File Information command provides a fast method of determining the number of spooled files for one or all users. The QSPSPLI API is used.

SCNCMDESC

The Scan Command Escape Messages command scans for a string of text in escape messages that are sent by a specific system command. Both the first and second level text are scanned. If the scan value is found in the second level text, the first level text is also listed. SCNCMDESC can be helpful when the text of an escape message is known, but not the message ID for a specific system command.

WRKSPLF3

The Work Spooled File 3 command works in conjunction with the CVTOUTQ or the CPYCVTOUTQ out file. WRKSPLF3 provides a display similar to WRKSPLF of the spooled file records in the outfile. The use of CVTOUTQ/CPYCVTOUTQ provides better selection capability than the system WRKSPLF command. For example, WRKSPLF does not support an OUTQ parameter.

New tools as of Jul 15, 2011

CHKACTUSR2

The Check Active User 2 command is designed for the situation where you periodically want to check for a list of users to see if they are active. On the first use or when RESET(*YES) is specified, a file is built in QTEMP of the active users. The file is then checked to see if the specified user is active and if not, an escape message is issued. On subsequent uses with RESET(*NO), only the file is checked.

CHKHEX

The Check Hex command checks a string of hex characters such as 'C1C2C3' to ensure valid hex characters exist. A string of up to 512 characters may be checked. You must use the RTNLOC value to determine if an error exists. CHKHEX can be helpful when a user is entering hex characters which must be validated.

CMPMBRD

The Compare Member Description command compares attributes of one, generic, or all members (either data or source) in two different files. Only the member text, number of records, number of deleted records, and 'share' attribute are compared. Unmatched member names in the To file are flagged. Unmatched member names in the From file may be optionally flagged. CMPMBRD may be helpful when ensuring member attributes are identical in two files.

CVTDAYS

The Convert Days command converts a range of dates to an outfile. The BUSCAL tool must first be used to a build a Business Calendar (a *USRSPC object) with the years that you want to consider. Days such as Sunday, New Years, Christmas, and specific dates may be excluded. CVTDAYS is then used to build an outfile of dates that have not been excluded.

DSPEMTIFS

The Display Empty IFS command is a front-end to DSPIFS to provide a listing of the empty IFS stream files. Stream files that have an object size of 0 are displayed. Note that this is not the allocated size of the stream file. The DSPIFS command is used internally and the output appears with the title of 'Display IFS'.

DSPOUTFMT

The Display Outfile Format command displays the fields in a format of the model file for commands that create outfiles. Many DSP commands and CVT commands support an outfile. Both system and TAA commands are supported. If multiple outfiles exist for the command (eg DSPFD), the DSPOUTFILE command is used to allow a selection. DSPOUTFMT may only be used interactively.

DSPPRFAUT

The Display Profile Authorizations command displays one, generic, or all profiles and flags those where the *PUBLIC or an authorized user has at least *USE rights to the user profile. The owner, *ALLOBJ users, and certain system profiles are bypassed. The user profiles that are flagged represent a security exposure as the *PUBLIC or authorized user can submit a job as the user profile or swap to the user profile.

DSPQHSTSIZ

The Display QHST Size command provides a simple listing with one line per QHSTxx file in QSYS and the total size. The date/time of the first and last message of each QHST version is also included along with the save date. This allows a review of QHST versions.

EDTUSRSPC

The Edit User Space command allows data to be written or changed in a user space. An option on the command allows editing in character or hex mode. EDTUSRSPC provides a convenient method of storing and maintaining data in a user space object or making changes when data is written to a user space by another function.

FIXVAR

The Fix Variable command allows an input variable to be changed by replacing a character with one or more characters (up to 10) or deleting a character. The new value is returned in a 5000 byte variable. The input variable may be up to 5000 bytes, but a length should be specified to improve performance.

OUTFFLD

The Outfile Fields tool is a series of commands that allow you to display a field name that exists in either a system and/or TAA model file. This can assist in understanding the attributes of the field and the command which outputs the file. After the required files are created and the field information is converted, the DSPOUTFFLD command can be used.

PRTPAGOF

The Print Page Of command allows you to re-print a spooled file where you have printed 'Page n' and change the value to 'Page n of n'. You must identify where the units position of the page number is and the line it is to print on. After re-printing, the original spooled file is deleted.

RTVMTHNAM

The Retrieve Month Name command retrieves the name of the month based on a plus or minus number of months from the current month. Different formats of the month name are provided. The system date is used to determine the current month (not the job date).

RTVOBJLCK

The Retrieve Object Lock command is designed to assist when an object is locked and you suspect there may be a single job holding one or more locks on the object. If only a single job holds one or more locks, return variables will describe the job and the strongest lock to allow a message to be sent. If locks exist from multiple jobs, the TAA9891 escape message is issued.

RTVSBMCMD

The Retrieve Submitted Command command retrieves the command that was submitted by a SBMJOB. The job may be on a job queue, be active, or have completed as long as DSPJOBLOG can be used. The command for the first 'Request' type message is returned. Several restrictions exist.

SAVRSTJOBQ

The Save and Restore Job Queue tool supports two commands to provide for a save and restore of a job queue. CVTJOBQ2 creates an outfile of information about the jobs on a job queue. The file can be saved and restored to the same or a different system. The SBMJOBQ2 command may then be used to read the outfile and perform a SBMJOB for each job found in the outfile. Some restrictions exist.

SCNALLJLG

The Scan All Job Logs command will scan all or selected job logs for various criteria such as message IDs, message types, and a string of text. If a match is found, an abbreviated spooled file is written named JOBLOG. SCNALLJLG assists in finding information when the specified job log is not known. Selection criteria is an important consideration as significant performance considerations exist if many job logs are scanned (see the discussion on performance).

SCNMSGQ

The Scan Message Queue command scans, one, generic, or all message queues in one or more libraries for up to 20 different arguments against the message text of the messages. A listing is output of the messages that match at least one of the arguments.

SCNVARRGT2

The Scan Variable Right 2 command scans a variable (up to 5000 bytes) for either the length of the data or for a string. SCNVARRGT2 can help determine the length of the data in a large variable or where a string of characters begins.

SIGNOFF2

The Signoff 2 command operates as a normal signoff command except that ENDCNN(*YES) is the default instead of the system default of *NO. SIGNOFF2 is intended to be used when TELNET is used to start a job on another system. SIGNOFF2 may only be used during an interactive job. The command is specified as LMTUSR(*YES).

SNDPGMMSG3

The Send Program Message 3 command allows a *DIAG, *COMP, or *INFO message to be sent to the caller from a sub or sub-sub program. This can provide better feedback when the sub program needs to communicate to the caller of a program. The QMHSNDPM API is used to allow the message to be sent up the stack.

New tools as of Apr 15, 2011

CHGCNLKEY

The Change Cancel Key command works in conjunction with the RTVCNLKEY tool command. CHGCNLKEY allows the setting of the Cancel and Exit key information which may be of value when mixing system and user functions. The QWCCCJOB API is used.

CHGDBFDAT

The Change Data Base File Date command changes date fields in a file from an MMDDYY, DDMMYY, or YYMMDD format to a different format. This allows rearranging date fields to allow for normal processing based on your typical date format.

CHGDSPOBJO

The Change DSPOBJD Outfile Dates command changes all date formats in the outfile created by DSPOBJD that are in an MMDDYY format to either DDMMYY or YYMMDD. The DSPOBJD outfile has several date fields that use the MMDDYY format regardless of the job date format. CHGDSPOBJO makes it easier to work with the dates if you want a format other than MMDDYY.

CHKARASPE

The Check Data Area Spelling command checks for misspelled words in a *CHAR type data area (*DTAARA). The data in the data area would be considered as a string with blanks separating the words. The dictionary supplied by TAA is used by default. Special dictionaries may be named. See the discussion with the TAADCT tool.

CHKSPCSPE

The Check User Space Spelling command checks for misspelled words in the first 32,000 bytes of a user space. The data in the user space would be considered as a string with blanks separating the words. The dictionary supplied by TAA is used by default. Special dictionaries may be named. See the discussion with the TAADCT tool.

CLCBOOLVAL

The Calculate Boolean Value command provides input of 2 arguments of 4 byte fields and returns the result in either or both a 4 byte character value or an 8 byte hexadecimal value. The operation performed can be *OR, *AND, XOR, *NOR, *NAND, or *NOT. The arguments must be 1-4 byte *CHAR type fields. They may be variables, literals, or hex values.

CLRGENMBR

The Clear Generic Members command clears one or more generic members in a data base file (either source or data). The system supports a generic capability on RMVM, but not on CLRPFM. CLRGENMBR provides the missing function to allow cleanup of certain files.

CVTAUTL

The Convert Authorization List to Outfile command converts individual authorities for one, generic, or all authorization lists to an outfile. This allows various processing or queries against the information. The outfile is always AUTLP which uses a model file named TAASEIUP and a format name of QSYDSAUT.

DSPAUDCMD

The Display Audit Command command displays or lists audit records for a specific user for the AUDLVL(*CMD) function. The AUDLOGP file (AUDLOG tool) is used. The user must be specified as CHGUSRAUD AUDLVL(*CMD) which causes an audit entry for each command executed (including commands run in CL programs or REXX procedures). DSPAUDCMD provides a tailored solution for the 'T CD C' journal entries.

DSPQHSTINQ

The Display QHST Inquiries command displays or lists inquiry messages and their replies from the QHST log. The formatting allows a better review than the DSPLOG command. A detail option for additional information is available.

DSPUSRAUT3

The Display User Authority 3 command displays or lists the authorities that have been granted to a specific user for one, generic, or all objects. A specific object type may be named. Inclusion of the user's owned objects is an option. DSPUSRAUT3 provides a better review than DSPUSRPRF.

DSPUSRSGN

The Display User Signon command displays the hours and minutes that one or more users were signed on. The JOBACG tool is required and the latest job information must be converted from the QACGJRN journal. The default option lists each signon by a user (from any device) with day and user totals for the days requested. You may request a day total or just a user total.

EXTLST3

The Extract List 3 command accepts input from a simple list parameter passed from a command and returns a value that is suitable to be moved to a variable for listing or displaying in a message. One space would exist between each value returned. The command would typically be part of a CPP that needs to make the list displayable and not as it is passed to the program.

RCVMSGKEY

The Receive Message Key command receives a message from the job log (intended for a low level message). You must first run the RTVMSGKEY command (part of the RMVMSGKEY tool) to set a mark in the job log prior to running the function that produces low level messages. Then RCVMSGKEY may be used to receive either a specific message ID or a loop may be written to receive more than one message.

RMVMSGKEY

The Remove Message Key tool provides two commands (RTVMSGKEY and RMVMSGKEY) which should be bracketed around commands that produce messages (including low level messages) that need to be cleaned up. When developing CL programs, it is desirable to cleanup messages produced by functions within the program. Many system commands send messages to low level programs that cannot be removed by RMVMSG CLEAR(*ALL).

RNMIFSXLT

The Rename IFS with Translation command renames directories and files described in a CVTIFS outfile (*TYPE2). Renaming is done character by character for up to 10 different characters that may be replaced. Unmatched characters are not changed. RNMIFSXLT can be helpful when transferring IFS objects to different system types which have different naming conventions.

RSNMSGKEY

The Resend Message Key command resends messages from the job log (intended for low level messages). You must first run the RTVMSGKEY command (part of the RMVMSGKEY tool) to set a mark in the job log prior to running a function that produces low level messages. RSNMSGKEY may then be used to resend either a specific message ID or all messages from the RTVMSGKEY mark.

RTVCNLKEY

The Retrieve Cancel Key command retrieves the action of the last system display function (including the command prompter) and returns the setting of the Cancel and/or Exit key. This allows a program using the display to determine whether the display was ended with the Enter key versus the Cancel or Exit key. The QUSRJOBI API is used to retrieve the information.

RTVSYSVAL4

The Retrieve System Value 4 command is an alternative method of accessing a single system value. It differs from RTVSYSVAL2 in that the return variable allows for 5000 bytes instead of the 900 supported by RTVSYSVAL2. The command interface is not of particular value, but the CPP can be called directly as an API which allows a simple access to any system value from a HLL.

SCNSRCSEU

The Scan Source SEU command scans one or more members in a source file for up 20 different arguments. If an argument is found, STRSEU is used on the member in either *CHANGE or *BROWSE mode. SCNSRCSEU simplifies making changes or reviewing source when several members have used the same string of characters.

SORTRPGARR

The Sort RPG Array command sorts compile time array data into ascending sequence for a named array in an RPG type source member. This simplifies making source changes to compile time array data when it is required to be in ascending sequence.

SYSLIBL

The System Library List tool is a documentation member only to help understand the basics of how to control and audit the changes to libraries on the system library list. TAA Tools that can assist are also mentioned.

New tools as of Jan 15, 2011

CHGAUT2

The Change Authority 2 command is a simple front end to the system CHGAUT command that operates only on objects in a library. Multiple users may be specified, but not all CHGAUT functions are supported. Unlike GRT/RVKOBJAUT, there are no low level messages that clutter the job log and cannot be removed.

CHGBIT

The Change Bit command allows one or more bits to be changed in a byte to either *ON ('1') or *OFF ('0'). The bits are numbered 1 - 8 with 1 being the high order bit. A variable must be specified for the &RTNBYTE parameter and all BITn parameters cannot be specified as *SAME.

CHKBIT

The Check Bit command checks one or more bits in a byte for an on or off value ('1' or '0'). The bit positions are labeled 1-8 with 1 being the high order bit. TAA9892 is sent if the bits do not match the requested values.

CHKFMT

The Check Format command checks for a format and/or level ID in a file. File types that support formats may be specified. A specific format may be named or the special value *FIRST. Different escape messages are sent if the format does not exist or the level ID does not match. No completion message is sent if the command completes normally.

CHKIFSSPE

The Check IFS Spelling command checks the spelling of the data in a stream file. The data is converted to the TAA240 source file in QTEMP and the TAA CHKSPELL2 command is used to check the spelling. Error indications appear with sequence numbers as if the data was in a source file. The data is limited to 240 bytes wide for the stream file.

CHKTAALIC

The Check TAA License command provides a simple check to see if a valid TAA Productivity Tools license exists. The completion message describes whether a full or demonstration license exists. If a demonstration license exists, the date the license expires is described.

CRTRTVDCL

The Create Retrieve DCLs command creates DCL commands in a CLP source member for a named RTV command. Rather than keying the DCLs manually, CRTRTVDCL may be used to generate all the DCLs for a retrieve command that allows return variables. The source member must exist.

CVTMBRLST2

The Convert Member List 2 command converts the member description information for one, generic, or all members of a file. The output file is the same as that used by DSPFD *MBRLIST. The DSPFD command does not allow a single or generic member name. CVTMBRLST2 makes it simple to create a function that processes one, generic, or all members from a file.

DLTENDLIC

The Delete End TAA License command provides a method of resetting the TAA license if ENDTAALIC had been used previously. This is intended for a situation where a mistake has been made or a change of plans has occurred after ending the TAA license. DLTENDLIC requires a special software code that may be requested from the TAA Productivity Tools owner.

DLTGRCKEY

The Delete Grace Key command is a companion command to CRTGRCKEY. CRTGRCKEY is used to allow the use of the TAA Tools for a grace period on a system that does not have a valid license. CRTGRCKEY may only be used once on a system unless a reset occurs. DLTGRCKEY provides a reset function, but requires a special software code that may be requested from the TAA Productivity Tools owner.

DSPDBFDMG

The Display Data Base Damage command checks for damage in the data base file descriptive information. Each file processed is used by CHKOBJ, RTVOBJD, various forms of DSPFD, and DSPFFD. An outfile of the damaged files is optional. The data itself is not checked. DSPDBFDMG is intended for the case when an abnormal system termination has occurred and you suspect data base damage.

DSPDSTQ

The Display Distribution Queue command is a simple front end to the system WRKDSTQ command. Only a display is provided so no changes are allowed. WRKDSTQ is set as *PUBLIC(*EXCLUDE). DSPDSTQ adopts the authority of QSECOFR so that any user may review the contents of a distribution queue or all distribution queues.

DSPMSGQINQ

The Display Message Queue Inquiries command displays or lists inquiry messages and their replies from a message queue such as QSYSOPR. The formatting allows a better review than the DSPMSG command. A detail option for additional information is available.

DSPPMTCMD

The Display Prompted Command function prompts for a command and uses the returned string to 1) run the command via user specified QCMDEXC program, 2) parse the returned string into 68 byte blocks to be displayed, printed, sent to the job log, or written to a source member. Variables may be specified for the parameters of the command to be prompted for and will be filled at execution time. The variables must be declared in the program.

DSPSPCAUT2

The Display Special Authority 2 command displays the combination of special authorities for a user, the group profile, and any supplemental group profiles. Selection can be made on the combined special authorities. DSPSPCAUT2 helps provide a better view of what an individual user can do.

DSPUIMCNT

The Display UIM Count command counts the number of lines in one or more members containing UIM type source. Source types in addition to PNLGRP may be specified. Comment lines and blank lines are also counted. A percentage of comments is provided. DSPUIMCNT provides a better understanding of the amount of actual source versus a count of the number of statements in a source member.

FMTQLFCMD

The Format Qualified Command command allows CL source to be formatted so any qualified commands begin in position 14 of the source with the command name. The / is placed in position 13 and the library name to the left. This aligns the command names for easier reading of the source. The command prompter formats a qualified name so the library name begins in position 14.

FNDOBJMBR

The Find Object Member command attempts to match the source member name used to create an object with a source member in one or more source files. This is designed for the case where the source has been moved or duplicates exist for the same member name. One or more objects may be specified with one or more libraries checked for where the source may exist.

RTVPMTCMD

The Retrieve Prompted Command command allows an input of a command string (such as just a command name), prompts for the command, and then returns the full command string including keywords without executing the command. Different formats are available such as for a command line or in a CLP source format. RTVPMTCMD is useful to applications that want to allow command input with prompting so the return command string can be run at a later time.

WRKFATHOM

The Work Fathom command provides an interactive display to convert from fathoms, feet, cable lengths, nautical miles, and miles to different values. By entering a non-zero value on the left of the display and pressing Enter, the screen is refreshed with the converted value.

New tools as of Oct 15, 2010

CHGOBJAUT2

The Change Object Authority 2 command changes the *PUBLIC user of an object to the CRTAUT value of the library where the object exists. If the library value is *SYSVAL, the QCRTAUT system value is accessed and used. CHGOBJAUT2 allows existing objects to have their authority changed to adhere to the library default.

CRTTGTRLS

The Create Target Release command assists in creating or changing objects to be saved for a named release. A specific or generic object is named or all objects in a library. Either a new library must be named and must not exist (it is created by CRTTGTRLS) or the objects in the same library will be created for the named release. The TAA Tool RPLOBJ is used to recreate program and module objects and produces a listing of the results.

CVTJOB

The Convert Job to Outfile command converts the information for one or more jobs to an outfile. Selection may occur on the job or user name as well as the status (*ALL, *ACTIVE, *JOBQ, *OUTQ). The outfile name is JOBP which uses the model file TAAJOFKP and a format name of JOBRCD.

DSPCOMPCDE

The Display Completion Codes command displays the job completion codes described in the CPF1164 message. This provides a quick review.

DSPEMTARA

The Display Empty Data Area command displays one or more data areas that have no value or a zero value (*DEC type *DTAARA). A flag may be set if the data area has not been changed (such as by CHGDTAARA) in the last n days. An option exists to list all data areas. DSPEMTARA can be helpful in cleaning up unused data areas.

DSPEMTDBF

The Display Empty Data Base File command displays data base files that have no members. A flag may be set if the data base file has not been used in the last n days. An option exists to list all data base files. DSPEMTDBF can be helpful in cleaning up unused data base files.

DSPEMTDTAQ

The Display Empty Data Queue command displays one or more data queues that have no entries. A flag may be set if the data queue has not been changed (such as not having received an entry) in the last n days. An option exists to list all data queues. DSPEMTDTAQ can be helpful in cleaning up unused data queues.

DSPEMTJOBQ

The Display Empty Job Queue command displays one or more job queues that have no jobs. A flag may be set if the job queue has not been used (such as not having any jobs added) in the last n days. An option exists to list all job queues. DSPEMTJOBQ can be helpful in cleaning up unused job queues.

DSPEMTMSGQ

The Display Empty Message Queue command displays one or more message queues that have no messages. A flag may be set if the message queue has not been changed (such as not having received a message) in the last n days. An option exists to display all message queues. DSPEMTMSGQ can be helpful in cleaning up unused message queues.

DSPEMTOUTQ

The Display Empty Output Queue command displays one or more output queues that have no entries. A flag may be set if the output queue has not been used (such as not having any spooled files) in the last n days. An option exists to list all output queues. DSPEMTOUTQ can be helpful in cleaning up unused output queues.

DSPJOBSCDR

The Display Job Schedule Results command displays the results of Job Scheduled jobs (how they completed) for the last submission. The JOBACG tool must be in use and the job accounting entries must be current for the completed Job Scheduled jobs to obtain meaningful results. DSPJOBSCDR assists in understanding what is happening to Job Scheduled jobs.

DSPRPGCPY

The Display RPG /COPY tool provides two commands. DSPRPGCPY provides a display or list of the /COPY and/or /INCLUDE statements from one or more RPG type source members (including RPGLE, RPGMOD etc.) in one or more source files. An outfile is optional which will allow further analysis by the DSPRPGCPY2 command which prints or lists the use of a specific member named on /COPY or /INCLUDE statements. A query may also be written.

FNDCMDTXT

The Find Command Text command displays or prints a list of commands that match a string somewhere in the text description of command objects such as 'printer'. A file of commands is created by the TAA install process (using the FNDCMD tool) which contains all commands on the system except for duplicates in QSYS and the previous release libraries.

PROLIB

The Protect Library tool helps prevent specified critical libraries from an accidental use of CLRLIB or DLTLIB. The tool uses the system provided command exit program technique. In addition to CLRLIB and DLTLIB, the TAA Tools CLRLIB2 and DLTLIB2 are also protected. Not even an *ALLOBJ user will be able to accidentally clear or delete a protected library.

RMVLSTCHR

The Remove Last Character command sets the last character in a variable to blank. It is primarily intended for use when receiving escape messages that already have a period at the end of the message text and should be resent using SNDESCMSG (which causes a period to be added at the end of the text). The message text must be declared as *CHAR LEN(512).

RTVDECARA

The Retrieve Decimal Data Area command retrieves the value of a decimal data area without knowing the length or decimal positions to a *CHAR LEN(17) variable. A minus sign may precede the value. A decimal format character will exist if decimal positions are defined for the data area.

RTVLSTSPLF

The Retrieve Last Spooled File command retrieves information about the last spooled file written in the current job. This includes the name of the spooled file, the spooled file number, and the date and time of the create.

RUNIO

The Run I/O command is a testing aid to submit a batch job to perform a series of writes to a data base file in QTEMP. This can assist in testing system performance by various tools that need to work with data base activity.

SNDESCMSG5

The Send Escape Message 5 command is similar to the TAA SNDESCMSG2 command (part of the SNDESCMSG tool), but also allows a 'stack counter' to be specified. This allows the escape message to be sent to a program higher in the stack than the calling program. The QMHSNDPGM API is used.

New tools as of Jul 15, 2010

CHKJOBFNC

The Check Job Function command checks for an active job having a specific Function type-description as seen with WRKACTJOB such as 'PGM-xxx'. Multiple jobs may satisfy the request. A job name is required. Both the Function type and the Function description are optional.

CHKOWNCHG

The Check Owner Change command compares the current owner of one or more objects to the owner that created the object and displays a listing. Those objects with the same owner are bypassed. Options exist to process only those owned by a named user or created by a named user.

CPYTOCSV

The Copy to CSV command copies from an externally described data base file to a stream file and adds delimiters. The intent is to make a stream file for a spread sheet processor. Options exist to add delimiters at the end of fields, surround fields with quotes, and to include column headings.

CVTOBJD5

The Convert Object Description 5 command provides an outfile for most of the fields created by DSPOBJD and adds large fields for the object and save size values to allow for 15 and 20 digit fields. Edited values are also provided as separate fields. This provides a simple means of working with large sizes. The model file is TAAOBLZP with a format name of QLIDOBJD.

CVTPGMA2

The Convert Program Attributes 2 command converts program object (*PGM) information to an outfile with one record per program. This includes module information for up to 100 modules which is written as an array. This allows simple processing of programs that are made up of multiple modules. The same information as available with CVTPGMA plus the module information is output by CVTPGMA2.

DSPDEPLGL

The Display Dependent Logical command provides a display of the dependent logical files of a physical file. A physical file must be specified for the FILE parameter. An option exists from the display to access other options such as the access path information.

DSPLSTOBJ

The Display Last Object command displays information about the last object name of a generic group of objects. The default is for all object types. If the same name exists for different object types, the last object type (per system order) determines the object that is displayed. If you are naming objects using a generic technique, DSPLSTOBJ can assist in providing information about the last name assigned.

DSPUSRCMD

The Display User Commands command displays the audit records for commands run by a user that is specified with CHGUSRAUD AUDLVL(*CMD). DSPUSRCMD is intended for use on critical security profiles such as QSECOFR and QSRV to allow a review of the commands that were entered. The Journal Code T (Audit) records with an Entry Type of CD (command was run) are processed using the CPYAUDJRNE outfile.

DTAARAARC

The Data Area Archive provides online save files for specified data areas. Multiple versions may exist for each data area. The DTAARAARC tool is not intended to replace normal backup, but rather to allow a quick review of a previous value. A typical use would be to restore the object to a different library to allow a review. You can also restore from the online save files. Several commands are provided.

RMVMSGQMS2

Remove Message Queue Messages 2 command allows a removal from one, generic, or all message queues for messages that are past a retention date. The default is to bypass any message queues with a name beginning with Q in a library beginning with Q. Other message queues may be specifically bypassed.

RMVQSYSMSG

The Remove QSYSMSG Messages tool allows both removal and archiving of messages from the QSYSMSG system message queue. Removal is done based on the number of days to retain the messages. Archiving is optional and provides for the QSYSMSGP file in QGPL. If archiving is used, all new messages (not previously archived) are copied to QSYSMSGP.

RNMIFSPGP

The Rename Primary Group Profile command uses the CHGPGP command to rename the Primary Group Profile of the objects for a user. The To user becomes the new Primary Group Profile. The default is *CHECK meaning no changes would occur and a listing of the objects that would be changed is output. *CHANGE may be specified to change the Primary Group Profile attribute.

RNMOBJPGP

The Rename Object Primary Group Profile command sets the PGP attribute of one or more objects to a new user profile. The PGP attribute is set by the CHGOBJPGP command. The default for RNMOBJPGP is for ACTION(*CHECK) which causes a listing of what would be changed. ACTION(*CHANGE) should be specified to change the attribute (set it to the new user profile).

RPTCMD

The Repeat Command command is primarily a testing aid and allows a command to repeated between 1 and 99999 times. RPTCMD can be helpful when stress testing a function.

RTVLSTOBJ

The Retrieve Last Object command retrieves the last name of a generic name by object type. If you are naming objects using a generic technique, RTVLSTOBJ can assist in determining the last name assigned.

RTVNXTID

The Retrieve Next ID command is designed to return the next ID in a sequence. For example, if the last ID input is ABC, the next ID that would be returned is ABD. This allows the assigning of names based on the last ID that was used. This could be used for object or member names or for field names in a data base file. Numbers in the ID are optional.

RVKIFSPGP

The Revoke IFS Primary Group Profile command sets the Primary Group Profile to *NONE for a specific user. This allows some cleanup of the IFS objects. The command defaults to '*CHECK' and provides a listing of what would be changed if '*REVOKE' had been specified.

RVKOBJPGP

The Revoke Object Primary Group Profile command sets the PGP attribute of one or more objects to *NONE. The PGP attribute is set by the CHGOBJPGP command. The default for RVKOBJPGP is for ACTION(*CHECK) which causes a listing of what would be changed. ACTION(*REVOKE) should be specified to revoke the attribute (set it to *NONE).

SYSACT

The System Activity tool is a series of commands that lets you capture and work with the data produced by the WRKSYSACT system command. This provides performance information for jobs/tasks that have occurred during one or more intervals. The SYSACT tool can be helpful in reviewing performance characteristics such as CPU usage, I/O counts and a breakdown of reads/writes for data base and non-data base activity.

New tools as of Apr 15, 2010

CHKTAACHG

The Check TAA Changes command helps provide an understanding of potential incompatibilities when moving to a new update or version of the TAA Productivity Tools. The tool is run automatically at the time of install using the last used date of the previous TAA commands and a listing is output. The information may not be 100% complete, but should provide a review of what you should consider.

CHKTAAOUTF

The Check TAA Outfiles command checks for any existing TAA outfile names to determine if the level ID is the same as that used by the current tool. The command is run automatically when the TAA Productivity Tools are installed and may also be run at any time. The output listing describes outfiles that may need to be deleted for successful tool use.

CLCDATTIM2

The Calculate Date/Time 2 command returns the difference in terms of number of minutes (an optionally the number of seconds) between a From date/time and a To date/time. CLCDATTIM2 may be useful when determining time differences.

CMPLIBFMT

The Compare Library Format command compares one or more physical files in one library to the same file names in another library. The comparison is done for the number of fields, the record length, and the level ID. This can assist in ensuring files that are intended to match have the same format in different libraries.

CPYDBFDAT

The Copy Data Base Date command copies records in a data base file based on a comparison of a field value and a specified date and operator. Different date formats are valid for character, zoned, packed, date, or time stamp fields.

CPYRFMT

The Copy and Reformat command provides better reformatting capability than the system CPYF command which supports only *MAP and *DROP. In addition to *MAP and *DROP functions, CPYRFMT allows renaming of a field. The To file must exist.

CVTIFSAUT2

The Convert IFS Authority 2 command converts IFS authorities for a single user to an outfile named IFSAUT2P. This allows simplified processing of user authorities. The model file is TAAIFTWP with a format name of IFSAUT2PR.

CVTLIBAUT

The Convert Library Authorizations command converts the object authority information of all objects within a library and the library object to an outfile. The system command DSPOBJAUT operates on only a single object. The outfile name is OBJAUTP. The model file is QAOBJAUT in QSYS with a format name of QSYDSAUT.

CVTLIBAUT2

The Convert Library Authority 2 command converts the authorities of users to library objects (not the objects within a library) to an outfile. The DSPOBJAUT command operates on only a single object. The outfile name is OBJAUTP. The model file is QAOBJAUT in QSYS with a format name of QSYDSAUT.

CVTOBJD4

The Convert Object Description 4 command creates an outfile of object descriptions based on the DSPOBJD V5R3 outfile format. This allows a program which uses the outfile that is created on a more current release to be transferred to a prior release and operate successfully. The V5R3 format is created using the QUSLOBJ API and has a format name of QLIDOBJD.

CVTSFWRSC

The Convert Software Resources command provides a simpler outfile to work with than the system DSPSFWRSC command. Only the data that appears on the DSPSFWRSC OUTPUT(*PRINT) listing is converted to the SFWRSCP outfile. The model file is TAASYTXP with a record format name of SFWRSCR. Because the listing must be read by CPYSPLF, only the lower and upper case English language versions of DSPSFWRSC are supported.

CVTTIMSEC

The Convert Time to Seconds command converts a time value (HHMMSS) to a return parameter containing the number of seconds prior to midnight. For example, if the value is 030000 (3:00 AM), the return seconds would be (3600 x 3) or 10,800. CVTTIMSEC may be helpful when dealing with time values.

DLTDBFDAT

The Delete Data Base Date command deletes (or checks for deletion) records from a data base file based on a comparison of a field value and a specified date and operator. Different date formats are valid for character, zoned, packed, date, or time stamp fields. DLTDBFDAT can assist in cleaning up files.

DSPACGCDE

The Display Job Accounting Codes command displays a list of job accounting codes in code sequence from both User Profiles and Job Descriptions. This simplifies understanding what Job Accounting Codes exist and where they are defined.

DSPJOBPERF

The Display Job Performance command lists job performance information for the current job. The RESJOBPERF command (part of the JOBINF tool) should first be used to begin capturing the information. After some commands are entered, DSPJOBPERF may then by used to display the information.

DSPMSGUSE2

The Display Message Use 2 command reads the outfile created by the SCNEXTMSGF TAA Tool and creates a listing of the message ID and the command name that sends the message if it is known. Only system commands that send escape messages can be identified. Diagnostic messages and messages from APIs cannot be identified.

DSPSUMJOBQ

The Display Summary of Job Queue command provides a summary of a job queue by Status and Job Priority. One or both of the summaries may be listed along with an optional line for each job. DSPSUMJOBQ can help determine how many jobs exist for each type.

DSPSUMOUTQ

The Display Summary of Output Queue command provides a summary of an output queue by Status, Form Type, and User Data. One or all of the summaries may be listed along with an optional line for each spooled file. DSPSUMOUTQ can help determine how much printing must occur for each type.

DSPUSRSTG

The Display User Storage command provides a display or listing with one line per user of the number of objects owned and the total storage used. One, generic, or all users may be requested along with an omit list. The number of programs, files, and other objects is also shown.

JOBINF

The Job Information tool provides commands that allow you to create a record when a job begins and ends. The information that is captured includes how and when the job started and a summary of performance information when the job ended. The STRJOBINF and ENDJOBINF commands must be included in the job.

RNMIFSAUT

The Rename IFS Authorities command allows you to change the authorities from one user to another for IFS objects. The default is for ACTION(*CHECK) which will not cause any changes, but a listing is produced describing the changes that would occur. Two exceptions exist that will prevent a change 1) if the user is the owner of an object, or 2) if the user is the Primary Group Profile of the object.

RTVJOBPERF

The Retrieve Job Performance command retrieves performance information about the current job. The system keeps statistics for each job which are retrieved using the API QUSRJOBI. A 'reset' of the statistics must first be used for the job by RESJOBPERF or RTVJOBPERF RESET(*YES). Following the running of normal commands, RTVJOBPERF RESET(*NO) may then be used to retrieve the performance information that has occurred since the last 'reset'.

RTVTCPSTKS

The Retrieve TCP Stack Status command retrieves TCP information for IPv4 and IPv6. Status information such as whether TCP is active or inactive is available for both IPv4 and IPv6. Starting and ending information is also available for IPv4.

RVKIFSAUT

The Revoke IFS Authority command revokes the authorities of a specified user to IFS objects. The default is to 'check' rather than 'revoke'. A listing is produced describing the results. The authority is not revoked if the user is the owner of the object or if the user is the Primary Group Profile. If the user is authorized via an Authorization List, the Authorization List is not changed.

New tools as of Jan 15, 2010

CHGRPGCPY

The Change RPG /COPY (CHGRPGCPY) command allows changes to /COPY statements in RPG for one, generic, or all members of a source file. The CHGRPGCPY2 exists for RPGLE source which also handles /INCLUDE. The default is OPTION(*CHECK) which means no changes are made and the listing describes what changes would be made. Selection criteria exists for the file, library, or member names in the existing /COPY statement.

CHKVAL

The Check Value command is intended for the case where the user inputs a value to a CL program and the value must be validated. CHKVAL offers several checking options that vary depending on the type requested. Special values are also supported. Standard error text may be used to simplify the explanation of any errors.

CLCTIMZOND

The Calculate Time Zone Difference command returns the number of minutes difference between two time zones. The time zone names as used by WRKTIMZON must be input or special values such as *PACIFIC. Daylight savings time is considered. An optional return value describes the difference in HH:MM format. A minus value may be returned.

CMPALLSRC

The Compare All Source command compares one, all, or generic source members in one or more source files in a library to the same file and members in a different library. A listing is produced for each file and the members. If the corresponding member does not exist or the data does not match, the member is flagged. An option exists for a detail comparison of unmatched members.

CPYNONGEN

The Copy Non Generic command copies records from one file/member to another and bypasses the records containing a list of generic values for a named field. This allows 'all but generic xxx' to be copied. Most queries do not support a selection by '*NE a generic value'. Using CPYNONGEN allows a subset file to be created which can then be queried.

CVTIP6DEV

The Convert IPv6 Device command converts the IP version 6 device information to the IP6DEVP outfile in a named library. TCP must be active. Only TCP/IPv6 network interfaces are supported. One record is written for each IP device. The API QtocLstNetIfc is used. For a description of the field values in the outfile, refer to the API documentation for format NIFC0200.

CVTSRCMBR

The Convert Source Member command converts source that exceeds 70 columns of data to a format not exceeding 70 columns. This allows a tool such as EDTSRC to work with previously created DDS source such as CL or DDS. The type of source must be named (CL, CMD, DDS, or TXT). Any non supported source types are flagged.

DSPCLPSRC

The Display CLP Source command displays or lists the source for a CLP type program (CLP, CLP38 and CLLE). If the source does not exist for a CLP or CLP38 program (non-TAA), a prompt occurs asking if RTVCLSRC should be used and a display occurs after retrieval. If a TAA program is specified and the user is authorized to the TAASRCACC Authorization List, the source in the TAA Archive is displayed.

DSPCMDSRC

The Display Command Source command displays or lists the command source for a command. If the source does not exist for a non-TAA command, a prompt occurs asking if RTVCMDSRC should be used and a display occurs after retrieval. If a TAA command is specified and the user is authorized to the TAASRCACC Authorization List, the source in the TAA Archive is displayed.

DSPDSTDAT

The Display DST (Daylight Savings Time) Date command displays or lists the start and end date/times for daylight savings time for a time zone in a specific year. The system support for Time Zone Descriptions does not include actual dates of change.

DSPIFSAUD

The Display IFS Auditing command displays the auditing attribute of IFS objects. Selection may be made on the type of auditing including *NONE. DSPIFSAUD assists in understanding what is being audited. To specify auditing for an IFS object, use CHGAUD.

DSPTAANAM

The Display TAA Name command allows input of 4 characters for a TAA ID such as SRCF and sends a completion message with the tool name and description. This can simplify determining what tool is being used when only an object name is known.

DSPTIMZONT

The Display Time Zone Time command displays or lists the date and time for a specified time zone. The day of week and offset from GMT are also shown. Daylight savings time (DST) is considered if the time zone supports DST and the current date/time is within the DST start and end date/time.

OPNSPLF

The Open Spooled File command is a testing aid. It allows a spooled file to be opened with a specific name and remain open. The intent of OPNSPLF is to allow other functions to test how they operate on an opened spooled file.

RTVDSTDAT

The Retrieve DST (Daylight Savings Time) Date command retrieves the actual dates that daylight savings time will begin and end for a Time Zone Description in a specific year. The system support for Time Zone Descriptions does not include actual dates of change. The TAA9893 escape message is sent if the Time Zone Description does not support daylight savings time.

RTVTIMZONT

The Retrieve Time Zone Time command retrieves the current date and time for a specified time zone. The day of week and offset from GMT may also be retrieved. Daylight savings time (DST) is considered if the time zone supports DST and the current date/time is within the DST start and end date/time.

SBMCHKACT

The Submit Check of Active Job command is intended for the case where a job should either 1) Not run longer than n seconds or 2) Be running after n seconds. A message is sent to a specified message queue if the status is not what is requested.

SCNDBFFLD

The Scan Data Base Field command allows a scan of a field in a data base file for *EQ, *LE, ... *CT (contains). Up to 3 fields that help identify the record where a match was found may be listed. SCNDBFFLD provides a simple query of data.

SCNDEVDSPA

The Scan Device Display Attributes command scans one, generic, or all display devices for attribute values. This acts as a simple query to determine the value of attributes of display devices.

SCNDEVPRTA

The Scan Device Printer Attributes command scans one, generic, or all printer devices for attribute values. This acts as a simple query to determine the value of attributes of printer devices.

SCNJOBLOG

The Scan Job Log command is intended to 'net out' a job log to allow a review by selection criteria. It allows a display or listing of a subset of the messages from a specific job log. The selection of messages may be done by a list of message IDs, message types, date/time range, severity, or by scanning the message text.

UNLOAD

The Unload a Device command provides a simple function to ensure a device is unloaded. If the command completes successfully and unloads the device or the device is not in a ready status (the status if already unloaded), the command completes normally. Different completion message text describes the condition. The command may be helpful when several save commands are used in a CL program and it is not known what the device condition is at the end.

New tools as of Oct 15, 2009

ADDRDBDIR2

The Add Relational Data Base (RDB) command is intended to assist in moving RDB entries as seen with DSPRDBDIRE to a different system. You must first capture the RDB entries to an outfile with DSPRDBDIRE and then move the outfile to the system to be applied to. Duplicate RDB names are rejected as well as a second version of *LOCAL for the Remote Location Name.

ADJAPOST

The Adjust Apostrophes command is designed to adjust the number of apostrophes in a variable so that the return result is valid for command processing. ADJAPOST is specifically designed for IFS processing, but may be used for variables intended for non-IFS use.

CHKDBFMBR

The Check Data Base File Member command simplifies checking for a data base file and authority to it. This provides clear messages when the file or member does not exist, the file is not the requested file type, or the user does not have the proper authorization.

CHKSTDJOBS

The Check Standard Jobs command provides a method of determining if required system and standard processing jobs are active. CHKSTDJOBS operates by using the output of the TAA CVTWRKACT command when the system is known to be in a good state and checking the jobs to see if they are still active.

CVTJOBPERF

The Convert Job Performance command converts job performance information for specified active jobs to an outfile. A reset capability exists. This provides a simple summary of such things as CPU seconds used, the percentage of CPU seconds used, transaction count, and response time. The model file is TAAJOFDP with a format name of JOBPERFR.

CVTLIBLCK

The Convert Library Locks command converts any locks held on a library and any objects within the library. This allows a determination of whether any locks exist before a function that requires exclusive use of the library. The model file in TAATOOL is TAAOBJDP with a format name of OBJLCKR.

CVTLIBLCK2

The Convert Library Locks 2 command converts any locks held on one or more object types. This allows a determination of who has the library on their library list or has made an explicit allocation of a library. The model file in TAATOOL is TAAOBJDP with a format name of OBJLCKR.

CVTSEUTYP

The Convert SEU type command converts an SEU type such as RPG to the object type *PGM (or PF to *FILE). This can be helpful when an end user inputs an SEU type and the object type is needed.

DLYSBMJOB

The Delay Submit Job command provides a simple solution for submitting a job to start in a specified number of seconds, minutes, hours, and days. This avoids the use of SBMJOB which requires the SCDDATE and SCDTIME parameters to do a simple submit after a time delay. The DLYSBMJOB job would be placed on the QSYSNOMAX job queue with the generated SCDDATE and ENDTIME parameters and would submit the requested job (and command) after the delay.

DSPEMTMBR

The Display Empty Members command displays or prints the empty members for one, generic, or all files in one or more libraries. Size information is also supplied to point out space savings that can be achieved for members that are no longer needed. The size information includes the data and access path size, but not the member description object which can be up to 20K bytes.

DSPLSTJLG

The Display Last Job Log command displays the last QPJOBLOG file for the current user based on the job number. This simplifies displaying the job log for programmers and operators when the last submitted job fails.

DSPSPLCRTD

The Display Spool Create Date command displays spooled files for one or more output queues in ascending create date sequence. Totals occur for each day. An outfile is optional. A beginning date may be specified to allow a number of current days to be bypassed. DSPSPLCRTD may assist in understanding cleanup requirements.

DSPSRCCHG

The Display Source Change command displays the changes to a source member between two dates. Both dates default to the last time the source member was changed. The default is to display just the changes. All statements may be listed with the changes flagged.

DSPTAPSIZ

The Display Tape Size command displays or lists an approximation of how much data has been written to a tape. Each file is listed along with a total. An outfile is optional. Hardware compression is not considered. DSPTAP is used to determine the information. Because a spooled file must be read, only lower and upper case English is supported.

DUPALLSPLF

The Duplicate All Spooled Files command duplicates selected spooled files from one output queue to another. The default is to duplicate all spooled files. A variety of selection criteria exists.

EDTSRC

The Edit Source tool is a subset of an SEU (PDM) like function. The intent of the tool is to provide a simple source editor for a system that does not have the STRSEU command or a similar function. This would be typical in some remote or small installations. Any source may be edited, but prompting exists only for CLP, CLLE, and CMD type source.

RCLSTGBCH

The Reclaim Storage in Batch command is designed to allow you to run RCLSTG (requires the restricted state) in batch. This allows scheduling of RCLSTG using the Job Scheduler or the SBMJOB SCDDATE/SCDTIME function. The RCLSTG2 command which is a front end to RCLSTG is used as it provides a better historical view of the Reclaim Storage results.

RMVEMTMBR

The Remove Empty Members command removes empty members in a data or source file. An ACTION parameter exists that defaults to *CHECK meaning a listing is produced of what would be removed if *REMOVE had been specified.

RTVSQLPKGA

The Retrieve SQL Package Attributes command retrieves basic information about an *SQLPKG object type. The spooled file from PRTSQLINF is used to access some of the information. Only lower and upper case English is supported.

SAVSYSBCH

The Save System in Batch command is designed to allow you to run backup functions in batch that require the restricted state. This includes Save the Entire System (Option 21), Save System Data (Option 22), and Save User Data (Option 23). This allows scheduling of these functions using the Job Scheduler or the SBMJOB SCDDATE/SCDTIME function. Both tape and virtual tape are supported.

SBMJOBSCDE

The Submit Job Schedule Entry command submits one of the job schedule entries immediately. The job schedule entry is not changed. This allows a batch command interface instead of Option 10 (Submit immediately) from the WRKJOBSCDE display.

SCNUSRPRFA

The Scan User Profile Attributes command scans one, generic, or all user profiles for attribute values. This acts as a simple query to determine the value of attributes of user profiles.

SNDIFSMAIL

The Send IFS Mail command sends a note and an IFS attachment to one or more recipients. The recipients are described by using a name and a corresponding E-Mail address that must exist in a MAILADRP file or by entering a specific E-Mail address. The SNDDST command is used internally.

SNDMSGLIN

The Send Message Line command allows a long message to be sent to a joblog or displayed interactively where each line of text from the command is a separate line. Each line of the message can be up to 56 bytes and can be up to 7 lines. SNDMSGLIN avoids a continuous string of text in a message which can be difficult to read.

WRKSRC

The Work Source command is a subset like WRKMBRPDM function. The intent of the tool is to provide a simple work display for source members on a system that does not have the WRKMBRPDM command or a similar function. This would be typical in some remote or small installations. The TAA EDTSRC command is used to edit the source.

New tools as of Jul 15, 2009

CHKCMDQLFN

The Check Command Qualified Name command checks the parameters from CRTCMD that support qualified names to ensure that if a program is specified that the library qualifier is not *LIBL. Using *LIBL from a command that is used in a program that adopts authority presents a security exposure where a bogus program could be used.

CHKJOBMSGW

The Check Job Message Wait command allows you to send a notification when a job is waiting for a response to a message (MSGW status). The notification can be one or more of 1) Send a break message to a message queue on the current system, 2) Send a break message to a workstation on a different system (using FTP), 3) Send an Email to a user (using TAA tool SNDTXTMAIL)

CHKOBJATR

The Check Object Attribute command checks for an object attribute such as RPG or PF. The value '*ALL' is considered valid. TAA9893 is sent as an escape message for an invalid attribute. The command is useful for checking other command input which allows an object attribute.

CVTOBJD3

The Convert Object Description 3 command converts DSPOBJD information to a subset outfile using the same field names (such as ODOBNM for object name). Not all fields from the system file are included. The command is intended for the case where the program is created to run on a prior release where the DSPOBJD model file may differ and cause a file override error in a program. A list of object attributes may be specified.

DLYHLDSPLF

The Delay Hold Spooled File command submits a batch job to QSYSNOMAX to run HLDSPLF after a delay time of a specified number of seconds. This allows a processing program to perform functions while the spooled file is the READY status.

DLYRLSSPLF

The Delay Release Spooled File command submits a batch job to QSYSNOMAX to run RLSSPLF after a delay time of a specified number of seconds. This allows a processing program to perform functions while the spooled file is the HELD status.

DSPOBJSIZ

The Display Object Size command displays or lists objects and their sizes. Selection can occur on a generic object name, object type, object attribute, and owner. Sequencing can be requested by size. DSPOBJSIZ provides a simple review of objects by size.

DUPAUTLAUT

The Duplicate Authorization List Authorities command duplicates the authorities from one *AUTL to another. Both *AUTL objects must be owned by the same user. All authorities from the To *AUTL are removed first and the authorities from the From *AUTL are copied. DUPAUTLAUT is helpful when you want to create an *AUTL that is similar, but not the same as an existing *AUTL.

ENDOLDJBQJ

The End Old Job Queue Jobs command ends jobs which are on one or all job queues based on a specified number of retention days. Jobs that have a schedule date are bypassed. An Action parameter exists that allows a determination of the jobs that would be ended if ACTION(*END) had been specified.

PGMADP

The Program Adopt tool provides a series of commands to help manage the programs that adopt a user profile during the running of the program. This allows a review and approval of these programs and a method of monitoring for changes.

RTVLFSRC

The Retrieve Logical File Source command retrieves the information from an existing logical file object and writes a DDS source member that attempts to emulate the original source that was used. The command has several restrictions. It is limited to simple logical files. Key fields described for the logical file are written to the DDS along with select/omit criteria.

SCNCLSA

The Scan Class Attributes command scans one or more Class Objects for attribute values. This acts as a simple query to determine the value of attributes of Class objects.

SCNCMDA

The Scan Command Attributes command scans one or more Command Objects for attribute values. This acts as a simple query to determine the value of attributes of Command objects.

SCNDSPFA

The Scan Display File Attributes command scans one or more display files for attribute values. This acts as a simple query to determine the value of attributes of display files.

SCNDTAQA

The Scan Data Queue Attributes command scans one or more Data Queues for attribute values. This acts as a simple query to determine the value of attributes of Data Queue objects.

SCNJOBDA

The Scan Job Description Attributes command scans one or more job description objects for attribute values. This acts as a simple query to determine the value of attributes of job descriptions.

SCNJOBQA

The Scan Job Queue Attributes command scans one or more Job queue objects for attribute values. This acts as a simple query to determine the value of attributes of Job Queues.

SCNLFA

The Scan Logical File Attributes command scans one or more logical files for attribute values. This acts as a simple query to determine the value of attributes of logical files.

SCNMSGQA

The Scan Message Queue Attributes command scans one or more Message Queues for attribute values. This acts as a simple query to determine the value of attributes of Message Queue objects.

SCNOBJDA

The Scan Object Description Attributes command scans one or more objects for attribute values. This acts as a simple query to determine the value of attributes of objects.

SCNOUTQA

The Scan Output Queue Attributes command scans one or more Output Queues for attribute values. This acts as a simple query to determine the value of attributes of Output Queue objects.

SCNPFA

The Scan Physical File Attributes command scans one or more physical files for attribute values. This acts as a simple query to determine the value of attributes of physical files.

SCNPGMA

The Scan Program Attributes command scans one or more programs for attribute values. This acts as a simple query to determine the value of attributes of program objects.

New tools as of Apr 15, 2009

BOMBRUN

The Bombing Run command provides an interactive game where you attempt to bomb a target. A plane moves across the display after you press Enter. F6 is used to drop the bomb. You must account for the direction and maximum speed of the wind. The target is also moving.

CHKAUDAUT

The Check *AUDIT Special Authority command checks if the user (including group authority and adopted authority) has *AUDIT special authority. The command completes normally if the user has *AUDIT authority with no feedback. If the user does not have *AUDIT authority, TAA9891 is sent as an escape message.

CHKAUDVAL

The Check Audit Value command checks a list of specified audit value such as *AUTFAIL against the values in the QAUDLVL and QAUDLVL2 system values. If one of the specified values does not exist, TAA9891 is sent as an escape message.

CLRLIB2

The Clear Library 2 command is like the system CLRLIB command, but also clears objects that can cause CLRLIB to fail such as dependent logical files in a different library, constraints specified by ADDPFCST, receivers that have not been saved, and output queues with entries. Some exceptions exist that may prevent a cleared library.

CNFDLTRCD

The Confirm Delete Record command allows deleting a record by entering a relative record number of a record in a file. A prompt appears with the data from the file (characters below X'40 appear as blanks). You must confirm the deletion by pressing F6. CNFDLTRCD may only be used in an interactive environment.

CPYFRMCSV

The Copy From Comma Delimited File tool provides two commands to copy comma delimited files (such as from a spread sheet) to an externally described file. CPYFRMCSV should be used for one time functions or for the first time to help you create a customized externally described file. CPYFRMCSV2 should be used when an externally described file already exists.

CPYNULLFLD

The Copy Null Fields command copies data from a file that contains null fields to a corresponding file that does not have null fields. The null values are changed to zeros. You may create the corresponding file or replace the data in the file if it already exists. CPYNULLFLD may be used to allow functions that do not operate on null field files to be used.

CVTPING

The Convert Ping command captures the information from a PING command and places the results in one record written to an outfile. Each record contains the results for 5 ping attempts and the minimum, average, and maximum of all attempts. The outfile name is always PINGP. The model outfile is TAATCPM with a format name of PINGRCD.

DLTLIB2

The Delete Library 2 command is like the system DLTLIB command, but also deletes objects that can cause DLTLIB to fail such as dependent logical files in a different library, constraints specified by ADDPFCST, receivers that have not been saved, and output queues with entries. Some exceptions exist that may prevent the library from being deleted.

DSPCRTDAT

The Display Create Date command provides a display or listing of objects with selection on the create date and time. The default displays the objects in descending create date and time order. DSPCRTDAT may be useful in understanding recent changes.

DSPCRTUSR

The Display Create User command displays or lists objects and compares the 'create user' to the 'current owner'. A specific 'create user' may be selected. Differences are flagged. DSPCRTUSR may be helpful in understanding changes that have occurred.

DSPEXCLCK

The Display Exclusive Locks command displays or lists the objects/members that have exclusive locks. This can be a very slow running command if many physical file objects are specified to be checked as CVTOBJLCK must be used on each to determine if any members are locked exclusively. DSPEXCLCK can assist in determining what cannot be processed because of exclusive locks.

DSPSPLOWN

The Display Spooled Files Owner command displays or lists by spooled file owner either each owned spooled file or a summary by user. This allows a review of how many spooled files and how much spooled file storage is owned by users. Specific libraries may be named or all libraries.

DSPSTGUSE

The Display Storage Use command displays or lists the amount of storage used in descending order by user profile. A percentage (default of 90%) may be specified to flag those profiles that are approaching the maximum storage allowed per profile. DSPSTGUSE is helpful in understanding what users have used versus the maximum allowed for each.

DSPSYSSEC

The Display System Security command displays or lists the high level information about system security and what the pending changes are. The RTVSYSSEC TAA command is used to retrieve the information.

DSPTAADAT

The Display TAA Integration Date command displays or lists tools by integration date. This provides a review of what tools have been shipped by date. A 'from' and 'to' date may be specified along with a category. A count by year is optional.

RMVSRCMBR

The Remove Source Members command removes members from a source file based on a number of retention days. The comparison may be made to the Create Date, the Change Date, or the Use Date. An ACTION parameter exists and defaults to *CHECK to provide a listing of what would be removed.

RSTOBJSAVF

The Restore Objects to Save File command reads a tape saved by SAVLIB or SAVOBJ for one, many, or all libraries and restores the objects to the TAATMPLIB library for each library found. After each library is restored, a save file is created in a named library and the TAATMPLIB library is saved to the save file. The TAATMPLIB library is then cleared and the next library is processed.

SCNALLSRC2

The Scan All Source 2 command will scan for up to 20 arguments in all source files in one or more libraries. Special values exist for the library name such as *ALLUSR. An omit list of libraries may also be named. The command is submitted to batch with JOBD and JOBQ parameters.

SCNSPLF2

The Scan Spooled File 2 command scans selected spooled files for a string and displays or prints the results. This allows searching for a string that exists in spooled files such as job logs. The QUSLSPL API is used to determine the selected spooled files.

New tools as of Jan 15, 2009

CHKALLOBJO

The Check *ALLOBJ Owner command checks the owner of an object to ensure he has *ALLOBJ special authority. For example, if a user with *ALLOBJ authority creates a program with USRPRF(*OWNER), but the user is part of a group that does not have *ALLOBJ and the group profile becomes the owner, the program will not run with *ALLOBJ authority. CHKALLOBJO can be used as part of the create step to ensure the proper create of a program.

CHKLCKSYSV

The Check Locked System Value command checks a system value to see if it is locked by the DST/SST function. This prevents certain system values from being used by CHGSYSVAL (or the Change option on WRKSYSVAL). The escape message TAA9896 is sent if the DST/SST function has been used and the system value is one that is on the list that may be locked. Otherwise, the command completes normally.

CLCDATDIF4

The Calculate Date Difference 4 command is like CLCDATDIF3, but allows a list of one or more day names to be specified. This allows an answer to a question such as 'How many Tuesdays and Thursdays exist between 2 dates?'

CLROUTQ2

The Clear Output Queue 2 command clears all but a specified number of spooled files from an output queue. The spooled files are first sorted in descending sequence by open date/time. The spooled files are then read, the specified number are bypassed, and the remainder are deleted. CLROUTQ2 simplifies keeping an output queue with a manageable number of spooled files.

CMPIFS

The Compare IFS command is designed to assist when you want to ensure that IFS objects in one or more directories on different systems or partitions are the same. The CAPIFS command must be used on both systems/partitions to capture the IFS information. The two libraries containing the CAPIFS information must exist on the same system when CMPIFS run. A spooled file is displayed or output with the differences.

CMPOUTQ

The Compare Output Queue command compares the major attribute information from each spooled file in one or more output queues to the same information created on another system. The CAPOUTQ command must be used on both systems/partitions to create a library with the spooled file information. The two created libraries must exist on the same system when CMPOUTQ run. A spooled file is displayed or output with the differences.

CMPRPYLE

The Compare System Reply List Entries command compares two versions of the RPYLSTP file output by CVTRPYLE. This may be used to compare against a previous version on the same system or to compare against the output from two different systems.

DSPDSKSTS

The Display Disk Status command displays or lists information about the disks attached to the system. The display differs from the system WRKDSKSTS command in that fewer statistics are shown, but the data is grouped by ASP with additional information about each hardware resource. The data is accessed from the TAA CVTDSKSTS command.

DSPLIBSIZ

The Display Library Size command displays or lists a summary of a library with size and count information. One, generic, or many libraries may be requested to be included. The library object record is included in the size and count of objects. An outfile may also be requested which contains many additional fields. The outfile model file in TAATOOL is TAALIDHP with a format name of LIBSIZR.

DSPLIB2

The Display Library 2 command displays or lists objects, data members, and source members in a named library. Summaries of each section are shown. More information is shown than the system command DSPLIB, but only a spooled file exists (not an interactive display). DSPLIB2 can be helpful when reviewing the contents of a library.

DSPQMQRY

The Display QMQRY command displays either a *QMQRY or *QRYDFN object by retrieving basic information about the object and the source retrieved by RTVQMQRY. The command may be useful in reviewing an existing query.

DSPSBSJBQE

The Display Subsystem Job Queue Entries command displays the job queue entries for one or more subsystems. This allows a review of the important entries that control batch work. Selection by a specific job queue may be made. An outfile is optional.

FIXDBFFLD

The Fix Data Base Field changes a character field (or an entire record) in a member to trim leading blanks, remove a list of characters, and translate characters. A single field may be used for selection. FIXDBFFLD may be useful when data is received from another system that contains unwanted characters.

HLDJOB2

The Hold Job 2 command holds one or more jobs using the system HLDJOB command. Generic job names or user names may be specified along with a subsystem name. An ACTION parameter allows either *CHECK or *HOLD. HLDJOB2 can assist when a set of jobs needs to be held. You must have *JOBCTL special authority to use HLDJOB2.

LOOKUP

The Lookup command provides a search within a CL program of a character variable that is an array of equal length elements. The variable must be declared as *CHAR LEN(32000). An alternate array may be specified and the corresponding element returned after a successful lookup. The alternate array variable must also be declared as *CHAR LEN(32000).

LOOKUP2

The Lookup 2 command provides a search within a CL program of a character variable of 32,000 bytes that is an array of equal length elements. An option allows the insertion into the first blank element. Another option allows a shorter length for the lookup argument to enable additional information to be stored in each element.

PMTOPR2

The Prompt Operator 2 command is a simpler version of PMTOPR and DSPWINDOW. It allows a CL program to display a window and optionally allow an F12 for Cancel and/or a Y/N return value. Up to 6 lines of text may appear plus a title. PMTOPR2 provides a simple method of communicating with an operator.

RLSJOB2

The Release Job 2 command releases one or more jobs that are in a HLD status by using the system RLSJOB command. Generic job names or user names may be specified along with a subsystem name. An ACTION parameter allows either *CHECK or *RELEASE. RLSJOB2 can assist when a set of jobs needs to be released. You must have *JOBCTL special authority to use RLSJOB2.

RTVSYSSEC

The Retrieve System Security command retrieves the overall system security values including the current and pending security level, current and pending password level, whether changes can be made to security system values, whether to allow digital certificates to be added, and whether the service tools password can be changed.

SCNCLPCMD

The Scan CLP Command scans CL source members for up to 50 different command names. A display or listing is output. An outfile is optional. SCNCLPCMD offers better function that the system PRTCMDUSG command in terms of finding command usage. If an outfile is created, the model file in TAATOOL is TAACLTEP with a format name of CMDRCD.

SCNDTAQ

The Scan Data Queue command scans the entries in a data queue for a value. Both the scan value and the entry are converted to upper case before scanning. A listing of the entries containing the value is optional. An option also exists to send an escape message if the scan value is not found.

SNDOBJLCKM

The Send Object Lock Message command sends a break message to workstations that have jobs with locks held on up to 100 different named objects. An option exists to end the jobs after sending a break message. SNDOBJLCKM can be used to inform users that an exclusive function is needed for the objects and ending of the jobs is required. A listing that describes the actions taken is displayed or output.

SORTCLPVAR

The Sort CLP Variable command provides a sort of a number of fixed length elements of up to 100 bytes in a 32,000 byte variable. The data is sequenced in either ascending or descending order and returned in the same variable. The array may be loaded by a tool such as LOOKUP2. The first all blank element or if the variable is full signals the end of the elements.

WRKSYSVAL2

The Work System Value 2 command allows an entry of a string of characters such as 'LMT' or 'LIMIT' and scans the system value names and text for matches. A work display appears with the matching system values and options to display or 'work with'. WRKSYSVAL2 simplifies accessing a system value when you know part of the name or a word in the text description.

New tools as of Oct 15, 2008

ADDDATMBR

The Add Date Member command adds a new member to a multi-member file using the name MCYYMMDDnn where CYYMMDD is the current date and nn is a consecutive number beginning with 01. Up to 99 versions may exist for a single day and a maximum of 32,767 members in the file. A return value exists for the member name that was assigned.

ADDDAT3

The Add Date 3 command allows a number of days to be added or subtracted from a date and returns a new date. ADDDAT3 is similar to ADDDAT2, but has been optimized for new dates in the same year as the input date. The number of days parameter is limited to -365 to +365. Any date format may be input and output.

CHGIFSOWN2

The Change IFS Owner 2 command changes all IFS objects owned by one user profile to another. This allows a simple means of switching owners. An option exists to revoke the current owners authority. You must have *ALLOBJ special authority to use CHGIFSOWN2.

CHKPWDBLK

The Check Password Block command provides the same function as the system V6R1 support to control users who attempt to change their password too frequently. The system supports checking with the use of CHGPWD, but not with CHGUSRPRF. CHKPWDBLK is intended to be placed in a program that uses CHGUSRPRF to change passwords, but also wants to ensure infrequent changes. TAA9897 is sent as an escape message if the time limit has not passed.

CMPLIB2

The Compare Library 2 command is designed to assist when you want to ensure that one or more libraries on different systems or partitions are the same. The CAPLIB2 command must be used on both systems/partitions to capture object and member information. The libraries containing the CAPLIB2 information must exist on the same system when CMPLIB2 run. A spooled file is displayed or output with the differences.

CMPMSGD

The Compare Message Descriptions command compares message descriptions in one message file to another. Corresponding message IDs are checked for in both files and the individual attributes of a message description are compared for matching IDs. A range of message IDs may be specified. A spooled file is created with any differences.

CVTPRTSTS

The Convert Printer Status command converts the status information for all or generic printers to an outfile. This includes the output queue associated with the printer and the status of both the writer and the output queue. The outfile is always PRTSTSP and the model file is TAAPRTJP. The API QGYRPRTL is used along with the TAA Tool RTVDEVPRT.

DLTIFSOWN

The Delete IFS Owner command deletes all IFS objects owned by a user profile. This allows a simple means of IFS cleanup. You must have *ALLOBJ special authority to use DLTIFSOWN.

DSPDBFALW

The Display Data Base File Allow Functions command displays the options for 'allow update' and 'allow delete' that may be set for physical data base files. A listing is produced of either all files or only those which have specified either of the 'allow' options. The intent of DSPDBFALW is to allow a review of these options.

DSPMBRCPC

The Display Member Capacity command displays one line per member describing the current number of records and the record capacity. Multiple libraries and a generic file name may be used. A specified percentage allows a flagging of those members which are nearing their record capacity. The command defaults to list only those members which are flagged.

DSPMLTFMT

The Display Multi-Format Files command displays or lists Logical Files that have either multiple formats or are joined files. The dependent files are also listed. One or more libraries may be specified with a request for a single, generic, or all files.

DSPPGMADP2

The Display Program Adopt 2 command displays the programs which adopt (USRPRF = *OWNER) or those which do not use adopted authority from a calling program (ie CHGPGM has been used with USEADPAUT = *NO). Both *PGM and *SRVPGM object types are supported. The DSPPGMADP2 function operates on a library basis as opposed to the system DSPPGMADP command which operates on a user profile basis.

DSPRSTDAT

The Display Restore Date command displays or lists the objects that have been restored to a library after the library was restored. More than one library or the entire system may be reviewed. Options exist to list the new libraries and new objects (never restored). DSPRSTDAT assists in understanding what objects have been restored or created since the last restore of a library.

DSPSAVSUM

The Display Save Summary command displays or lists a save summary from one or more libraries of where objects are saved to. The objects are separated into several categories: 1) Not saved since created or changed 2) Saved to a save file or 3) Saved to a tape device. Separate summaries appear for each save file used and each volume ID (first volume only) used. A detail listing of objects is optional.

ENDJOB2

The End Job 2 command provides for ending multiple jobs such as generic job names, generic user names, etc. The parameters of the command (such as OPTION and DELAY) are passed to individual ENDJOB commands for active jobs that meet the selection criteria. You must have *JOBCTL special authority to use ENDJOB2.

GENRANPWD

The Generate Random Password command generates a random password of a specified length from 5 to 100 bytes. Options exist to allow digits, allow vowels (AEIOUY), and allow lower case. No adjacent characters will ever be the same. The first character is always an upper case letter A-Z that is not a vowel. The second character is always a digit if digits are allowed.

HLDALLJOBQ

The Hold All Job Queues command holds all job queues in one or more libraries using generated HLDJOBQ system commands. A single job queue name, a generic name, or all job queues may be held. An ACTION parameter allows either *CHECK or *HOLD. HLDALLJOBQ can assist when a full or partial shutdown of the system is needed. You must have both *ALLOBJ and *JOBCTL special authority to use HLDALLJOBQ. See the companion tool RLSALLJOBQ.

HLDALLOUTQ

The Hold All Output Queues command holds all output queues in one or more libraries using generated HLDOUTQ system commands. A single output queue name, a generic name, or all output queues may be held. An ACTION parameter allows either *CHECK or *HOLD. HLDALLOUTQ can assist when a full or partial shutdown of the system is needed. You must have both *ALLOBJ and *JOBCTL special authority to use HLDALLOUTQ. See the companion tool RLSALLOUTQ.

HLDALLWTR

The Hold All Writers command holds all writers by using generated HLDWTR system commands. A single writer, a generic name, or all writers may be held. An ACTION parameter allows either *CHECK or *HOLD. HLDALLWTR can assist when a full or partial shutdown of the system is needed. You must have *JOBCTL special authority to use HLDALLWTR. See the companion tool RLSALLWTR.

RGTADJVAR

The Right Adjust Variable command takes a value such as '23@@@@@' and adjusts it to '@@@@23'. RGTADJVAR is intended for character variables that contain decimal values. Both character and decimal return variables are supported. A value such as '-23,112.38@@@' is also valid. Options exist to determine if special characters are valid.

RLSALLJOBQ

The Release All Job Queues command releases all job queues in one or more libraries using generated RLSJOBQ system commands. A single job queue name, a generic name, or all job queues may be released. An ACTION parameter allows either *CHECK or *RELEASE. RLSALLJOBQ can assist when bringing up the system after a full or partial shutdown. You must have both *ALLOBJ and *JOBCTL special authority to use RLSALLJOBQ. See the companion tool HLDALLJOBQ.

RLSALLOUTQ

The Release All Output Queues command releases all output queues in one or more libraries using generated RLSOUTQ system commands. A single output queue name, a generic name, or all output queues may be released. An ACTION parameter allows either *CHECK or *RELEASE. RLSALLOUTQ can assist when bringing the system up after a full or partial shutdown. You must have both *ALLOBJ and *JOBCTL special authority to use RLSALLOUTQ. See the companion tool HLDALLOUTQ.

RLSALLWTR

The Release All Writers command releases all writers using generated RLSWTR system commands. A single writer, a generic name, or all writers may be released. An ACTION parameter allows either *CHECK or *RELEASE. RLSALLWTR can assist when bringing the system up after a full or partial shutdown. You must have *JOBCTL special authority to use RLSALLWTR. See the companion tool HLDALLWTR.

RPLJOBDLIB

The Replace Job Description Library command allows a replace of an existing library in one or more job descriptions with a different library name. The replace library takes the position in the library list of the library being replaced. RPLJOBDLIB can be useful if library names must be changed.

SCNSPLF

The Scan Spooled File command scans a spooled file for a string and returns a count of how many strings were found. Other return variables exist for the line of data where the scan value was found, the position within the line, and the page number. These values are returned as arrays of up to 100 values. Only the first time the string is found on a print line is considered.

New tools as of Aug 1, 2008

CMPMODA

The Compare Module Attributes command compares the attributes of two module (*MODULE) objects. A spooled file is created of any differences.

CMPOUTFILE

The Compare System Outfiles command compares the formats used by system outfile commands from the current release to a previous release. For example, you may be interested to know if the DSPOBJD outfile format has changed in this release. A display or a listing is produced. The QA* files in QSYS used for outfile formats are compared.

CVTACTPRFL

The Convert Active Profile List command builds an outfile of the user profiles displayed by the DSPACTPRFL command. DSPACTPRFL lists the profiles which will not be disabled by the system ANZPRFACT function. CHGACTPRFL is used to maintain the list. CHGUSRPRF may still be used to disable such a profile. The outfile is named ACTPRFP. The model file is TAASEHSP with a format name of ACTPRFLR.

CVTIFSOWN

The Convert IFS Owner command builds an outfile of the owned objects in the IFS (does not include objects in libraries). The system DSPUSRPRF OUTFILE function does not output this information. The QSYLOBJA API is used to extract the information. The outfile is named IFSOWNP and is placed in a specified library. The model file is TAAIFTP with a format name of IFSOWNR.

DLTJOBDLIB

The Delete Job Description Library command deletes a library from the INLLIBL attribute of one or more job descriptions. This command is useful if a library has been deleted and should be removed from any Job Descriptions. No error occurs if the library is not found in a Job Description.

DSPIFSOWN

The Display IFS Owner command displays or lists owned objects in the IFS (does not include objects in libraries). The system DSPUSRPRF command does not display this information. The QSYLOBJA API is used to extract the information.

DSPJOBDLIB

The Display Job Description Libraries command provides two functions for one, generic, or all job descriptions: 1) A simple listing of the libraries in each job description 2) A check for any non-existent libraries. The output is either displayed or listed.

DSPLIBJOBD

The Display Library Job Description command displays or lists one or more libraries and job descriptions in one or more libraries that contain a specified library name. This allows you to determine what libraries are specified within job descriptions.

DSPQHST

The Display QHST command provides a method of searching the data from the QHST logs and displays or lists the entries. The QHST information must first be converted to a QHST2 file using the CVTQHST2 command. DSPQHST provides several search criteria such as a date range, a generic job or user name, message ID, and a scan value to scan the message text.

DSPSCDJOBQ

The Display Scheduled Job Queue Jobs command displays or lists the jobs on one or all job queues that have a scheduled date. A range of date and time value may be specified. You must have *ALLOBJ special authority to specify *ALL as a library qualifier.

DSPTBL

The Display Table command is similar to the display that appears using option 5 from the system WRKTBL command to display a *TBL object. A listing is optional. The TAA version also shows any differences from the base value. For example, if X'04' is output as X'37' and not as X'04', ** is used to flag the position.

DSPTOTPAG

The Display Total Pages command displays or lists a running total of the pages for spooled files in an output queue. The intent of the command is to provide an indication for a user of where his output is in the queue and how many pages are to be printed before a specific spooled file.

RVKDUPIFSA

The Revoke Duplicate IFS Authority command checks or revokes duplicate authorities to the *PUBLIC user of IFS objects. You must first run CVTIFSAUT to create an outfile of authorizations. If the authorization for a user is the same as the *PUBLIC profile, it is considered a duplicate (except for the owner). If the *PUBLIC user is specified as *AUTL, the authorizations from the *AUTL are used. Duplicates because of Group Profiles are not considered. The default is to 'check' (a listing if produced).

SELSPLF

The Select Spooled File command operates from an interactive CL program and displays the spooled files for the current or named user and allows the selection of one spooled file. The ID information about the spooled file is passed back to the calling program. The QUSLSPL API is used to determine the spooled files.

WRKJOBSTS

The Work Job Status command provides a work display or listing of all jobs in one or more named status values such as RUN or DSC. The display has a similar layout and options as the WRKACTJOB display. The jobs appear in job number order as opposed to the subsystem sequence used by WRKACTJOB.

ZIP

The ZIP and UNZIP commands perform standard PC zip and unzip functions for compressing/decompressing data in the IFS. This can be used to provide better performance for the transmission of objects. The Qshell and jar functions are used along with the QTOCVRT API. A DSPZIP command also exists.

New tools as of May 15, 2008

CHKBLKFLD

The Check Blank Fields command checks all values for each field in a file to determine if only blanks exist for character fields or zeros for decimal fields. This is intended as a debugging aid to check if a program that 'adds new records' is populating the correct fields. If only some records in the file contain values, the field is flagged with a different code.

CHKOWNSAVF

The Check Owner of Save File command checks the objects in a save file to see if they are owned by a specified user. If a library object is in the save file, it is also checked. An option exists to check the owner of the save file. TAA9896 is sent as an escape message if a different owner exists.

CVTARPTBL

The Convert ARP (Address Resolution Protocol) Table command creates an outfile of ARP table information for a specified line description. Address Resolution Protocol allows physically distinct networks to appear as if they were a single, logical network. The QtocLstPhyIfsARPTbl API is used. The outfile name is ARPTBLP. The model file is TAATCPKP with a format name of ARPTBLR.

DLTUSRPRF3

The Delete User Profile command does more than the system DLTUSRPRF command by deleting spooled files owned by the user, listing job descriptions, and job schedule entries where the user is named. A 'check' option is the default to allow you to review what will be deleted.

DSPARPTBL

The Display ARP (Address Resolution Protocol) Table command displays or prints the ARP table information for a specified line description. Address Resolution Protocol allows physically distinct networks to appear as if they were a single, logical network. The QtocLstPhyIfsARPTbl API is used to extract the values.

MAILADR

The Mail Address tool is a series of commands that allow you to create and maintain a list of E-Mail addresses. The MAILADR tool is required to use the SNDxxxMAIL commands unless a specific E-Mail address is entered. MAILADR allows an optional logging of anything sent by the SNDxxxMAIL commands.

MONMSGQ

The Monitor Message Queue tool provides a simple solution for monitoring a message queue for specific message IDs so that an action may be performed. For example, you may want to call a program when a specific message arrives on a message queue such as QSYSMSG. To use MONMSGQ, see the 'Getting started' instructions.

MYQ

The MY Q tool is a series of commands that lets you send and receive entries to a simple queue. This allows one program to place the entries on the queue and a second (or the same) program to receive them in a loop or by an entry number. The queue is a *USRSPC object that can contain up to 8,000 entries. All commands default the name of the queue to MYQ in QTEMP. A specific queue and library may be named.

SAVFARC

The Save File Archive tool is a series of commands that allows archiving of save files. This provides an online solution for save files to allow a restore of saved information without having to mount media. The sub tools WRKSAVFOBJ and WRKSAVFMBR may be used to allow an option for restore rather than entering complex commands.

SNDSPLMAIL

The Send Spooled File E-Mail command sends a spooled file in *SCS format with a brief text message to one or more recipients. The recipients are described by using a name and a corresponding E-Mail address that must exist in a MAILADRP file or by entering a specific E-Mail address. The SNDDST command is used internally. See the SNDTXTMAIL command for sending a long text message without a spooled file.

SNDTXTMAIL

The Send Text E-Mail command sends a text message to one or more recipients. The recipients are described by using a name and a corresponding E-Mail address that must exist in a MAILADRP file or by entering a specific E-Mail address. The SNDDST command is used internally. See the SNDSPLMAIL command for sending an E-Mail with an attached spooled file.

WRKOBJ2

The Work Object 2 command provides more options than the system WRKOBJ command. In addition to the same options as WRKOBJ, WRKOBJ2 supports options for Change/Work, DSPxxx, DSPOBJD2, and MOVOBJ. WRKOBJ2 provides specific commands for options such as CHGJOBD and DSPJOBD if a JOBD object is being displayed.

WRKSAVFMBR

The Work with Save File Members command provides a work display of the members of a saved data base file in a save file. Simple options allow a restore of the member or to display the description of the online member in the file where the member was saved from. WRKSAVFMBR provides a better solution than the system DSPSAVF command. such as the owner of the file has changed, the library doesn't exist, the file has no members, etc

WRKSAVFOBJ

The Work with Save File Objects command provides a work display of the objects saved in a save file. Simple options allow a restore of the object, access to the WRKSAVFMBR command (for data base files) or to display the object in the library where the object was saved from. WRKSAVFOBJ provides a better solution than the system DSPSAVF command.

New tools as of Mar 21, 2008

AUDITING

This is a documentation member only to help understand the basics of auditing on the system and some of the helpful TAA Tools. This provides an overview and some simple examples of how to get started with auditing.

CMPAUTLAUT

The Compare Authorization List Authority command compares the authorizations from one *AUTL object to another. This includes the owner and individual authorities. Differences are noted including From *AUTL users who do not exist for the To *AUTL and vice versa.

CVTTOBYT

The Convert to Bytes command allows a conversion from bytes to kilobytes, megabytes, etc. The companion command is Convert From Bytes which converts from kilobytes, megabytes etc to bytes.

DIVIDE

The Divide command provides a quotient, a remainder, and a decimal fraction after dividing a dividend by a divisor. The CL division function does not provide for a remainder. All variables must be specified as *DEC LEN(15 0).

DLTDLUSPLF

The Delete Deleted User Spooled Files command checks all spooled files on the system to determine if the user still exists. If the user does not exist, an action parameter determines whether the spooled file is listed or listed/deleted. This allows a cleanup of when a user profile is deleted that owns one or more spooled files.

DLTUSRSPLF

The Delete User Spooled Files command deletes the spooled files for a named user in one, generic, or all output queues. The user profile does not have to exist which allows cleanup when the user profile has been deleted, but still is the owner of spooled files. An action parameter determines whether the spooled file is listed or listed/deleted.

DSPBOF

The Display Based On File command displays the based on physical file members for a logical file. This provides a simpler means of determining the based on file members rather than using DSPFD. Other information about the access path is also displayed.

DSPOBJAUD

The Display Object Auditing command displays all audited objects in a list of libraries or all libraries. Auditing of an object is set by the CHGOBJAUD command. Options exist for selection by object type, a list of omitted libraries, and the library type.

DSPSPLUSE

The Display Spooled File Use command displays spooled files from one, generic, or all output queues that have not been used in a specified number of days. This provides an assist in cleanup where users claim they need spooled files kept online. The DLTOLDSPLF command may be used to clean up old spooled files that are not being used. See the COMPDATE parameter.

DSPUSRAUD

The Display User Auditing command displays a list of users and the attribute information about object auditing. A single user, a generic name, or all users may be requested. You may optionally bypass any user who does not have user auditing requested.

SCNAUDLOG

The Scan Audit Log command provides a different method of displaying or listing audit entries from the Audit Log data base file provided by the AUDLOG tool. In addition to standard selection fields such as date, time, user profile, etc, SCNAUDLOG allows a search on the entry data field. This can be particularly helpful for the 'T' Journal code (audit entries) where most of the data is in the entry data field.

STROBJCVN2

The Start Object Conversion 2 command is a front end to the system STROBJCVN command. STROBJCVN2 provides an easier solution by allowing a list of named or generic libraries and an omit list of libraries. A listing is produced instead of messages in the job log. Status messages describe which library is being operated on.

WRKLIBAUD

The Work Library Auditing command provides a work display for making changes to the create object auditing value for libraries. A named, a generic, or all libraries may be displayed. Selection may be made on the existing library create auditing value.

WRKOBJAUD

The Work Object Auditing command provides a work display for making changes to the object auditing value for objects in a library. A named, a generic, or all objects in a library may be displayed. Selection may be made on the existing object auditing value.

WRKUSRAUD

The Work User Auditing command provides a work display for making changes to user auditing values. A named, a generic, or all user profiles may be displayed. Selection may be made on the object auditing value or the user auditing actions.

New tools as of Jan 1, 2008

ADDUNQMBR

The Add Unique Member command adds a unique member to an existing data base file. The naming convention UNQnnnnnnn is used where nnnnnnn is a number in the range of 1 to 9,999,999. The maximum members in a file at one time may only be 32,767. A return value exists for the member name that was assigned. The text description parameter should contain the purpose of the member.

CHGSGNDAT

The Change Signon Date command is intended for the case where a user profile swap has occurred and the user profile should be updated so that the current date and time becomes the signon date/time value. CHGSGNDAT may also be used without a profile swap to update the current profile if an option is specified. CHGSGNDAT may only be used in a CL program. The QSYCHGPR API is used.

CHKTAAAUT

The Check TAA Authorities command checks the current authorities for TAA objects and compares them to the shipped version of the product. TAA objects in QSYS may also be included in the check such as Authorization Lists. This allows a simple determination of what authority changes have been made on your system. This helps ensure that the TAA Tools may not be used without proper authority.

CMPDBF2

The Compare Data Base File 2 command compares two identical format unique keyed files and lists the changes to the data for a specific field name. CMPDBF2 allows you to make a periodic copy of a uniquely keyed file and then compare the current version against the last copied version to see the changes for a specific field.

CMPMSGFA

The Compare Message File Attributes command compares the attributes of two Message File objects. A spooled file is created of any differences.

CMPMSGQA

The Compare Message Queue Attributes command compares the attributes of two Message Queue objects. A spooled file is created of any differences.

CVTPTFGRP

The Convert PTF Group command converts the PTF groups to an outfile. There is one record output for each PTF group. This is the same information that can be displayed with WRKPTFGRP. The API 'QpzListPTFGroups' is used. The file name is always PTFGRPP with a format name of PTFGRPR.

CVTPTFGRPD

The Convert PTF Group Details command converts the individual PTFs for a PTF Group or all PTF Groups to an outfile. Each record contains several fields describing the status of the PTF. This is the same information that can be displayed with WRKPTFGRP using Option 5. The API 'QpzListPTFGroupDetails' is used. The file name is always PTFGRPDP with a format name of PTFGRPR.

DSPJRNA

The Display Journal Attributes command is similar to the system WRKJRNA command. DSPJRNA provides a 'display only' function. No Function keys allow a WRK type of command. No journal entries may be displayed. DSPJRNA may be useful for operations personnel who do not need WRK type functions.

DSPJRNRCVD

The Display Journal Receiver Directory command displays or prints the list of journal receivers for a specific journal. This is a 'display only' function that may be safely used by operations personnel.

DSPJRNRCV2

The Display Journal Receiver Attributes 2 command is similar to the system DSPJRNRCVA command, but does not provide for an F10 key which allows a WRK command. Only attributes of a journal receiver are displayed (not the journal entries).

GENPRMNBR

The Generate Prime Numbers command writes one record per prime number to the PRIMEP file. Each number is 7 digits in a packed field named PRIME. A range of prime numbers may be generated from 2 to 9,999,999. Prime numbers may be helpful in different applications. The algorithm used is a modified Sieve of Eratosthenes. The model outfile is TAANBREP with a format name of PRIMER.

RTVCMDSRC2

The Retrieve Command Source 2 command is designed to retrieve the source for system commands. It differs from RTVCMDSRC which does not provide prompt text for system commands. In order to provide prompt text for keywords, the command help text is accessed. You must correctly perform the actions described in the prompt when RTVCMDSRC2 is used. Several restrictions exist.

RTVCOLHDG

The Retrieve Column Heading command is a program that can be called (TAADBLRR) to retrieve the column headings for a field in a file. An externally described data structure is used to communicate with the program (TAADBLRP). The intent of the program is to allow a general purpose print program where neither the file nor the fields are known when the program is written. Either the field name or the column headings (as described in DDS can be returned) and are justified for printing.

RTVDAT4

The Retrieve Date 4 command is a subset of the RTVDAT TAA command. RTVDAT4 returns only the digit of the day of the week and the week of the year. The intent is to provide better performance than RTVDAT. Both return parameters should be specified for better performance.

RTVDAT5

The Retrieve Date 5 command allows an input of a one digit day of the week (1 = Sunday) and/or a 2 digit month (01 = January) and returns the spellings for the day and month. RTVDAT5 may be used following RTVDAT4 to return the spelling of the day.

RTVDOCOBJ

The Retrieve Document Object command allows the retrieval of information about a *DOC object when only the system object name that exists in the QDOC library is known. The system object names may appear from a function such as when using the DSPOBJD outfile. These names do not relate to a user recognizable name. RTVDOCOBJ provides a translation from the *DOC object name to the information provided by QRYDOCLIB.

RTVFLDDTA

The Retrieve Field Data command is a program (TAADBLSR) that may be called to retrieve the data for a field in a file. An externally described data structure (TAADBLSP) and a record image is used to communicate with the program. The intent of the tool is to allow a general purpose print program where neither the file nor the fields are known when the program is written. The data to be passed back may include editing characters for decimal data if a edit code is requested.

RTVGENOBJ

The Retrieve Generic Object command provides a simple method of processing a list of generic objects in a CL program. Each use of the command returns the basic information about a single object with the name, library, type, attribute, and text description. The list may be retained and processed multiple times.

RTVREGINF

The Retrieve Registration Information command retrieves information as displayed with WRKREGINF. RTVREGINF retrieves information for one exit point. The Retrieve Server Authentication Entries (QsyRetrieveServerEntries) API is used.

RTVSVRAUTE

The Retrieve Server Authentication Entry retrieves information for an authentication entry (added by ADDSVRAUTE). CCSID, User ID, and 'Password specified' values are returned. You must have both *ALLOBJ and *SECADM special authority to use RTVSVRAUTE.

TIMRCD

The Time Record tool is a series of commands that allow capturing of time in seconds and 6 digits of sub seconds by using SNDTIMRCD at various points in an application. A journal entry is written. The CVTTIMRCD command may then be used to extract the entries to a data base file. The DSPTIMRCD command allows you to analyze the entries with the calculated difference in time. TIMRCD is designed to assist in understanding performance tradeoffs, but may also be used to provide an audit trail.

New tools as of Sept 15, 2007

CHGOBJAUT

The Change Object Authority command allows changes to authority for one, generic, or *ALL objects in a library of a specific type, or all types. A list of up to 50 users may be specified for specific authorities or to remove all authorities.

CHGOBJAUTL

The Change Object Authorization List command changes the authorization list for one, generic, or all objects in a library. The authorization list may also be set to *NONE. This simplifies making mass changes.

CHKIASP

The Check IASP Status command checks that all IASPS are online. An omit list of IASPs may be specified. An escape message (TAA9892) is issued if all requested IASPs are not online.

CHKMINRLS

The Check Minimum Release command finds objects that were created with a target release earlier than the one specified on the command and determines if the source still exists. *PGM, *MODULE, and *SRVPGM objects are checked. All *SQLPKG objects are flagged. Objects with creation data may be bypassed. The companion tool to re-create the objects is FIXMINRLS. The tool is designed to assist in conversion to V6R1M0.

CHKSELOMT

The Check Select/Omit command allows select and/or omit lists to be checked against a name value. The lists may contain generic names. A *YES/*NO result field is returned to assist in your processing. CHKSELOMT simplifies programming when performing select/omit processing of names against lists.

CMPCMDLST

The Compare Command List command is intended for the case where a command supports both an 'include' and an 'exclude' list of system names or generic system names. CMPCMDLST ensures that both lists are unique and generic names do not overlap specific names (or generic names) in the other list. TAA9896 is sent as an escape message for non-unique situations. An option exists to allow generic overlap.

CRTTSTDTA

The Create Test Data command either adds new test data records to an existing member or updates existing records. A prompt appears with the fields from the file and various options may be selected such as consecutive numbers, random numbers, unique numbers, constants, character data, or digit data. Fields not specified are added as blanks or zeros or not changed during an update.

CVTCTLASC

The Convert Controller Description ASYNC command converts one, generic, or all ASYNC controller descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always CTLASCP. The model file is TAACFGVP with a format name of CTLASCR.

CVTCTLHOST

The Convert Controller Description Host command converts one, generic, or all Host controller descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always CTLHOSTP. The model file is TAACFGYP with a format name of CTLHOSTR.

CVTCTLLWS

The Convert Controller Description Local Workstation command converts one, generic, or all local workstation controller descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always CTLLWSP. The model file is TAACFGWP with a format name of CTLLWSR.

CVTCTLNET

The Convert Controller Description Network command converts one, generic, or all network controller descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always CTLNETP. The model file is TAACFGXP with a format name of CTLNETR.

CVTCTLVWS

The Convert Controller Description Virtual Workstation command converts one, generic, or all virtual workstation controller descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always CTLVWSP. The model file is TAACFGZP with a format name of CTLVWSR.

CVTLINASC

The Convert Line Description ASYNC command converts one, generic, or all ASYNC line descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always LINASCP. The model file is TAACFGUP with a format name of LINASCR.

CVTLINETH

The Convert Line Description Ethernet command converts one, generic, or all Ethernet line descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always LINETHP. The model file is TAACFGPP with a format name of LINETHR.

CVTLINPPP

The Convert Line Description PPP (Point to Point Protocol) command converts one, generic, or all PPP line descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always LINPPPP. The model file is TAACFGRP with a format name of LINPPPR.

CVTLINSDLC

The Convert Line Description SDLC command converts one, generic, or all SDLC line descriptions to an outfile. This provides a simple method of processing the information. The outfile name is always LINSDLP. The model file is TAACFGQP with a format name of LINSDLR.

DSPDTAARAD

The Display Data Area Description command displays or prints the attributes of a data area. The data area value is not shown.

DSPOBJD4

The Display Object Description 4 command is a problem determination aid and is similar to DSPOBJD2. DSPOBJD4 allows any object description on the system to be displayed if the user has *USE authority to the TAADSPOBJ4 authorization list. 'Display only' functions for additional object level information are also provided for most object types. No data can be displayed.

DSPSELOMT

The Display Select Omit command displays or prints the select/omit criteria of a logical file. A better display exists than that used by DSPFD TYPE(*SELECT) which makes it more obvious what the relationships are. Only single format logical files are supported.

FIXDECERR

The Fix Decimal Errors command fixes packed and/or zoned fields in an externally described file member. Packed fields are set to zeros if invalid decimal data exists. Zoned fields with invalid characters have the characters made valid. Use the VALDBF tool to check for decimal errors (does not change values).

FIXMINRLS

The Fix Minimum Release command finds objects that were created with a target release earlier than the one specified on the command and replaces the object for most cases. *PGM, *MODULE, and *SRVPGM objects are checked. *MODULE and single module *PGM objects are replaced. Objects with creation data may be bypassed. All *SQLPKG objects are flagged. The tool is designed to assist in conversion to V6R1M0.

FNDJOB

The Find Job command provides an interactive display of jobs by entering job/user/status values. The job and user names may be generic and may contain wildcards. Options exist on the display for further information or for actions such as ENDJOB if authorized. FNDJOB simplifies finding a job when only part of the job name or user name is known.

GENUNQNBR

The Generate Unique Number tool generates unique numbers within a specified range. The GENUNQNBR command is intended for CL program use and generates a single unique number each time the command is used. The GENUNQNBR2 command creates an outfile of unique numbers. The outfile name is always UNQNBRP which uses the model file TAANBRDP with a format name of UNQNBRR.

RTVCTLASC

The Retrieve Controller Description ASYNC tool retrieves information about an ASYNC controller. Because many parameters exist, 2 commands are provided (RTVCTLASC, and RTVCTLASC2). This provides the current information about the controller. The QDCRCTLD API is used to retrieve the data.

RTVCTLHOST

The Retrieve Controller Description Host tool retrieves information about a host controller. Because many parameters exist, 3 commands are provided (RTVCTLHOST, RTVCTLHOS2, and RTVCTLHOS3). This provides the current information about the controller. The QDCRCTLD API is used to retrieve the data.

RTVCTLLWS

The Retrieve Controller Description Local Workstation command retrieves information about a local workstation controller. This provides the current information about the controller. The QDCRCTLD API is used to retrieve the data.

RTVCTLNET

The Retrieve Controller Description Network command retrieves information about a network controller. This provides the current information about the controller. The QDCRCTLD API is used to retrieve the data.

RTVCTLVWS

The Retrieve Controller Description Virtual Workstation command retrieves information about a Virtual Workstation controller. This provides the current information about the controller. The QDCRCTLD API is used to retrieve the data.

RTVLINASC

The Retrieve Line Description ASYNC tool retrieves information about an ASYNC line. Because many parameters exist, 2 commands are provided (RTVLINASC and RTVLINASC2). This provides the current information about the line. The QDCRLIND API is used to retrieve the data.

RTVLINETH

The Retrieve Line Description Ethernet tool retrieves information about an Ethernet line. Because many parameters exist, 2 commands are provided (RTVLINETH and RTVLINETH2). This provides the current information about the line. The QDCRLIND API is used to retrieve the data.

RTVLINPPP

The Retrieve Line Description Point to Point Protocol (PPP) tool retrieves information about a PPP line. Because many parameters exist, 2 commands are provided (RTVLINPPP and RTVLINPPP2). This provides the current information about the line. The QDCRLIND API is used to retrieve the data.

RTVLINSDLC

The Retrieve Line Description SDLC tool retrieves information about an SDLC line. Because many parameters exist, 2 commands are provided (RTVLINSDLC and RTVLINSDL2). This provides the current information about the line. The QDCRLIND API is used to retrieve the data.

RTVPGMREFL

The Retrieve Program Referenced Libraries command retrieves from a program type object the list of libraries used by externally described files when the program was created. The system DSPPGMREF command is used to determine the files used by the program. An option exists to add the libraries to the library list if they are not already on the list. RTVPGMREFL can be helpful when re-creating a program or module.

New tools as of July 4, 2007

None. A maintenance release.

New tools as of Jun 30, 2007

CHGUSRPRF3

The Change User Profile 3 command is a front end to the CHGUSRPRF command that allows a list of up to 300 user profile names or generic names to be changed. Most of the parameters from CHGUSRPRF are supported. This simplifies making mass changes to user profiles or for standardizing users of a department.

CHKMSGDSPE

The Check Message Description Spelling command checks a single message description for the spelling of the first and second level text. CHKMSGDSPE is helpful after adding or changing a message description. To check the spelling of all message descriptions in a file, use CHKMSGSPE.

CLCSQRT

The Calculate Square Root command calculates the square root of a numeric value that is greater than 0. The input value should be passed as a *DEC (15 5) value which allows numbers such as 123 or 123.456 to be input. The return value must be specified as *DEC LEN(15 5).

CMPOBJSEC

The Compare Object Security command compares security from one object to another. Individual authorities, ownership, and authorization lists are compared. If both objects are *PGM types, the USRPRF attribute and the USEADPAUT attribute (set by CHGPGM) are also compared.

CMPOBJSEC2

The Compare Object Security 2 command allows a comparison of one, generic, or all objects in a library to a specific object. This allows a determination if all security is being handled identically for a set of objects. A summary spooled file is output with one line for each object checked. Detail spooled files will exist for each object where the security differs.

CMPSRC4

The Compare Source 4 command is a front end to CMPSRC2. CMPSRC2 compares one, generic, or all members in a source file to another source file. CMPSRC4 allows all source files (or standard source files) to be compared from one library to another library.

CMPWLDCRD

The Compare Wild Card command provides a comparison of a system name against a compare value that contains fixed and/or floating wild cards. The companion command is CHKWLDCRD which is intended to be used before performing a function such as a DSPxxx OUTFILE or when using a list type API. Additional commands CMPWLDCRD2 and CHKWLDCRD2 may be used on any string (up to 500 bytes) such as customer names or addresses.

CRTCLPCALL

The Create CLP Call Parameters command creates the CALL and DCL statements for a CLP source member using the entry parameter list from a program (CLP, RPG, or single module RPGLE/CLLE). After ensuring a CL source member exists, CRTCLPCALL may be used to add records for the CALL and DCL statements. This simplifies building the proper interface between a CL program and the program to be called.

CRTCLPENT

The Create CLP Entry Parameters command creates the PGM and DCL statements for a CLP source member using the call and parameter list from a program (CLP, RPG, or single module RPGLE/CLLE) or from the keywords of a command. After adding a CL source member, CRTCLPENT may be used to add records for the PGM and DCL statements. This simplifies building the proper interface between a program or command which invokes a CL program.

CRTRPGCALL

The Create RPG Call Parameters command creates the CALL and PARM statements for an RPG or RPGLE source member using the entry parameter list from a program (CLP, RPG, or a single module RPGLE/CLLE). After ensuring an RPG source member exists, CRTRPGCALL may be used to add records for the CALL and PARM statements. This simplifies building the proper interface between an RPG program and the program to be called.

CRTRPGENT

The Create RPG Entry Parameters command creates the *ENTRY PLIST and PARM statements for an RPG or RPGLE source member. The information is extracted from a CALL and parameter list from a program (CLP, RPG, or single module RPGLE/CLLE) or from the keywords of a command. After adding an RPG source member, CRTRPGENT may be used to add records for the *ENTRY PLIST and PARM statements. This simplifies building the proper interface between a program or command which invokes an RPG program.

CVTTIMZOND

The Convert Time Zone Description command converts one, generic, or all time zone descriptions to an outfile. This provides a simple method of processing time zone information. The outfile name is always TIMZONP. The model file is TAATIMZP with a format name of TIMZONR.

DSPDBFKEY

The Display Data Base File by Key command displays or prints records from a single format data base file in keyed sequence. The key fields appear as the first fields in the listing. Any remaining fields that fit into the 378 maximum wide print line are also listed. DSPDBFKEY is a front end to the PRTDB key which allows listing fields by name.

DSPGENOBJ

The Display Generic Object command displays or prints a list of objects. A single object, all objects, a generic name, or a name including wild card characters may be used. If a display is requested, an option exists to use the TAA Display Object Description command which provides more information about the object.

DSPPGM2

The Display Program 2 command displays or prints information about a program by combining information from DSPPGM, RTVOBJD, DSPPGMREF, DSPOBJAUT, the entry list parameters, and whether programs of the same name exist in any other libraries. Text descriptions are displayed for objects and users if they can be found. This simplifies searching for information about a program.

EXTQLFJOB

The Extract Qualified Job Name command accepts an input value such as '123456/USERA/JOB1' and returns separate variables for JOB, USER, and JOBNBR. If your program is attempting to parse a message containing a qualified job name, EXTQLFJOB may be helpful.

FNDCMD

The Find Command command displays a list of commands that match a string such as 'JOBD'. By default all commands from QSYS and TAATOOL are displayed that match the string. When the display appears, options exist to prompt for the command or use the TAA DSPOBJD2 command. A separate command CRTFNDCMD may be used to build the file of commands for all or named libraries.

PRTREVERSE

The Print Reverse command prints a spooled file in reverse page order by creating a new spooled file. For example, if 3 pages exist, the new spooled file would contain page 3 as the first page, page 2 as the second page, and page 1 as the 3rd page. The lines per page are printed in the same order as they appear in the original spooled file.

RTVTIMZOND

The Retrieve Time Zone Description command retrieves information about a specific time zone description. This allows a program to process what is displayed by an option on WRKTIMZON.

SAVOWNOBJ

The Saved Owned Objects command saves objects owned by a specific user from a named library. A list of object types may be named. You must have *SAVSYS special authority to use SAVOWNOBJ.

SCNEXTMSGF

The Scan Extracted Message File tool is a series of commands that let you build a file of messages and then scan for a value. This can be helpful when you have seen a message containing a value such as 'authenticate', but no longer have the message ID to help determine the full text of the message. You may scan either the first or both the first and second level text.

SWPUSRPRF

The Swap User Profile command allows a swap to a user profile and runs a command under the new user profile. You must have *USE authority to the new user profile, but the authority may be adopted. When the command completes (either normally or abnormally), a special 'scope' program is used to ensure a swap back occurs to the original profile. Among other uses, SWPUSRPRF allows a means of adopting when using IFS objects.

New tools as of Mar 26, 2007

CHGDSTLE

The Change Distribution List Entry command lets you change or remove an entry from one, generic, or all distribution lists. The From User ID value must match an existing entry. An ACTION parameter exists which defaults to *TEST to allow testing of what the *CHANGE function will provide.

CHGGRPPRF2

The Change Group Profile 2 command allows you to change all members of a group profile for the parameters OWNER, GRPAUT, or GRPAUTTYP. This provides a simple method of ensuring all members of the group have the same attributes related to group profile processing.

CHKACTJOB

The Check Active Job command determines whether a job or generic job name is active. This can be helpful in determining if a server job is active. TAA9893 is sent as an escape message if the specified parameters do not find a job.

CHKDIRE

The Check Directory Entry command checks the directory (see WRKDIRE) using the outfile of DSPDIRE to determine if the full user ID (ID, address, and description) exist. If not, TAA9894 is sent as an escape message.

CHKGRPPRF

The Check Group Profile command checks a profile to see if it is a group profile. TAA9891 is sent as an escape message if the profile is not a group profile. You must have *USE authority to the group profile to use CHKGRPPRF.

CHKINACT2

The Check Inactive Job 2 tool is a series of commands that allow the ending or discontinuing of jobs that have been inactive for a specified period of time. This allows security control when users walk away from their devices while still signed on. It may also be used to end jobs that are hung. CHKINACT2 allows for different timeout values while the CHKINACT tool has a single timeout value.

CHKJOBENDS

The Check Job End Status command is intended for batch jobs that are waiting for a delay time and periodically need to check if an End Job or End Subsystem command has issued a controlled cancel - OPTION(*CNTRLD). CHKJOBENDS allows a periodic wakeup with a total time specified. The escape message TAA9891 is sent if a controlled cancel has been requested.

CHKSAVF

The Check Save File command is designed to allow you to determine if a save file is available for use. For example, if a save is occurring to the save file, TAA9892 will be sent as an escape message.

CRTEXTPRTF

The Create Externally Described Printer File command reads an RPG source member with a program described printer file and creates the DDS for an externally described printer file and the printer file. Exceptions such as duplicate output lines for the same EXCPT line are noted and a new format name is assigned. You must make changes to the RPG source as well as correct any exceptions that are noted.

DSPGRPPRF

The Display Group Profile command displays or prints the members of a group and detail information. The command is an improvement over the system DSPUSRPRF OPTION(*GRPPRF) function in that information about the individual members is displayed.

DSPMOON

The Display Moon command displays the dates of the full moon for a specific year. The new moon occurs about 14 days earlier than the full moon. The 1st quarter moon occurs about 7 days earlier and the last quarter moon occurs about 7 days after the full moon.

DSPUSAHST

The Display USA History command displays information about the history of the USA by year. This includes notable events such as Presidential elections, significant battles, and other information. Some major events outside of the US are also included.

DSPUSAPRES

The Display USA President command displays information about a US President including the electoral voting, the Vice President, notable cabinet members, and major events that occurred during the presidency. By default a list of Presidents will be displayed and a selection may be made (F19) or a specific President may be entered on the command.

ENAGRPPRF

The Enable Group Profile command ensures that all members of a group profile are enabled. The companion command is Disable Group Profile which ensures that all members of a group profile are disabled. An option exists to determine if the users who are part of a supplemental group profile should be enabled/disabled. No change to the status of the named group profile occurs.

ENDSBSJOB

The End Subsystem Job command ends one or more jobs from one or all subsystems based on a number of minutes active. For example, you can end all jobs in a subsystem that have been active for more than 640 minutes (8 hours).

EXTQLFNAM

The Extract Qualified Name command extracts an object and optional library qualifier from a string such as 'ABC/DEF' where ABC is considered to be the library and DEF the object. Leading blanks and apostrophes are ignored. Any characters following the end of the object name (after the blank delimiter) are ignored.

RTVDDMA

The Retrieve DDM Attributes command retrieves the attributes of a DDM file. This includes such attributes as the Remote File name, Remote location name, and Remote network identifier. Only a file created by CRTDDMF may be used.

RTVDIRE

The Retrieve Directory Entry command retrieves a directory entry (see WRKDIRE) when only the name and address or just the name is known. This allows use of the return values to be used in other commands.

WRKDSAUSR

The Work Disabled User command provides a work display of the users with a *DISABLED status. An option exists to enable the users. An omit list of profiles may be specified which would allow the use of WRKDSAUSR in a CL program where you could omit certain profiles that were known to be disabled.

New tools as of Jan 1, 2007

CHGJOBSPLF

The Change Job's Spooled Files command changes all the spooled files for a job for specified attributes such as changing to a different form type. This simplifies cleanup at the end of a job for spooled files created during the job.

CHGQDFTJRN

The Change QDFTJRN Data Area command creates and/or changes the QDFTJRN data area in a named library. The QDFTJRN data area is used by the system to automatically start journaling for objects intended for remote journaling. Using CHGQDFTJRN simplifies entering data into the required data area.

CHGUSRAUD2

The Change User Auditing 2 command is similar to the system CHGUSRAUD command, but prompts for CHGUSRAUD with the existing values from the user profile. This simplifies making additions or deletions of the AUDLVL parameter which may contain several items.

CHKFILATR

The Check File Attribute command provides a simple check of an existing file to ensure it has an attribute that you want to process. A list of one or more valid file attributes must be provided. If the attribute of the named file is not in the list, TAA9896 is sent as an escape message.

CHKPGMATR

The Check Program Attribute command provides a simple check of an existing program to ensure it has an attribute that you want to process. A list of one or more valid program attributes must be provided. If the attribute of the named program is not in the list, TAA9896 is sent as an escape message.

CHKSRCTYP2

The Check Source Type 2 command provides a simple check of an existing source member to ensure it has a source type that you want to process. A list of one or more valid source types must be provided. If the source type of the named member is not in the list, TAA9896 is sent as an escape message.

CVTDAT13

The Convert Date 13 command converts the 13 character date retrieved by many system commands in the format CYYMMDDHHMMSS and returns date and time values ready for printing. The date is returned in job format with the job date separator used. The time is returned with the job time separator used.

DSPDFTRCD

The Display Default Records command displays the Relative Record numbers of the records in a file that match the default record used by the system when adding a new record. It is possible for an application or a utility like DFU to add a default record as an error. DSPDFTRCD will find these conditions, but not all may indicate an error. You must decide based on your application.

DSPPWDLMT

The Display Password Limit command uses converted data from QHST and displays or prints the devices and/or user profiles that have been disabled because the QMAXSIGN system value limit has been reached. This provides a good review of attempted break-ins or users who are having trouble.

DSPPWDLMT2

The Display Password Limit 2 command uses converted data from QHST and displays or prints the conditions where a user profile has successfully signed on after one or more invalid password attempts to a list of user profiles. This provides a good review of authorized users who may be trying to discover a password of another profile.

DUPJOBSPLF

The Duplicate Job Spooled File command duplicates the spooled files for the current job to a different output queue with a different owner. This allows a tool like Spool Archive (SPLARC) to back up a job's spooled files even if the owner deletes them when the job completes.

PRTSAVAUD

The Print Save Audit command is intended to provide a listing for an auditor after a significant save has occurred such as some combination of SAVSECDTA, SAVCFG, SAVLIB, and SAV. The critical messages from the job log are printed to a listing. An option exists to print the QSYS data area information instead and one line per library with save date/time.

RTVDBFRR

The Retrieve Data Base File by Relative Record command allows a retrieval of the contents of up to 10 fields from a record in a data base file using a RR number. Both character (up to 50 bytes) and decimal fields are supported. The command allows a general purpose approach that may avoid having to write a program.

RTVDTAQ

The Retrieve Data Queue command retrieves the first entry in a data queue. Return values include the arrival date/time, sender ID, and the data. RTVDTAQ allows you to check if any processing should occur based on the arrival date and time of the first entry. The entry is not removed from the data queue. TAA9896 is sent as an escape message if no entries exist.

RTVLIBSIZ

The Retrieve Library Size command retrieves the size and number of objects in a library. The library object is also considered. The command is slow running against a large library or a library with many source members.

RTVMTHDAT

The Retrieve Month Date command allows a retrieval of the date in a month based on a day of the week and which week is desired. For example, you can determine the date of the 3rd Wednesday of a given month.

RTVSPLFID2

The Retrieve Spooled File ID 2 command is intended for the situation where you need to know the spooled file name and number of the last spooled file in a job and you do not know the name of the spooled file. The return variables may then be used with commands such as RTVSPLFA to determine other attributes or DUPSPLF to duplicate the spooled file.

RTVTOLCMD

The Retrieve TAA Tool Commands retrieves a list of commands for a named TAA Tool. The commands are passed back in a large variable which may then be used to perform other processing.

SAVJRNRCV

The Save Journal Receiver command saves all, active, or detached receivers for a specific journal. Saving an active receiver (not detached) is supported by the the system, but can make it awkward to restore.

SAVRSTASP

The Save and Restore ASP command allows a library to be saved and restored from one ASP to another. Both named and numbered ASPs are supported. An option exists to delete the existing library and must be used if the same library name is used for the restore library. A permanent library must be used for the creation of a save file used to save the library to and restore from. The save file is deleted if SAVRSTASP completes successfully.

SAVSNDM

The Save and Send Member with FTP tool is designed to simplify sending a member, generic members, or all members (from the same file) to another i5 System. Either a source or data file may be used. The SAVSNDM command saves one or more members to a save file and the save file is transmitted using FTP. On the remote system, use RSTSNDM (part of the SAVSNDM tool) to restore the member.

SAVSYSINF2

The Save System Information 2 command is a front end to the system SAVSYSINF command. SAVSYSINF saves a subset of the system data saved by SAVSYS and can be used after restoring a SAVSYS version. SAVSYSINF2 is preferable to the system function because SAVSYSINF2 runs SAVSYSINF and then updates a data area in TAASECURE. This provides a version of the save information which would be lost if the last SAVSYS was restored.

VRYCFGOFF

The Vary Configuration Off command provides a simple version of the VRYCFG command to vary off a device. The user must be authorized to the TAAVRYCFGO authorization list. The system VRYCFG command requires the user to have *JOBCTL special authority. The intent of VRYCFGOFF is to provide a solution without authorizing a user to *JOBCTL and may be used as an option an option on the SECOFR2 menu.

WRKVLDL

The Work Validation Lists command provides a work display for Validation List (*VLDL) objects. From the display, you may create and delete validation lists and access the TAA WRKVLDLE display to work with individual entries for a specific validation list.

WRKVLDLE

The Work Validation List Entries command is a series of commands that simplify working with validation list entries. After creating a Validation List, the remaining functions such as adding, changing, removing, displaying, verifying, retrieving, and converting can be done with TAA commands rather than system APIs.

New tools as of Sept 15, 2006

CHKNAMFLD2

The Check Name Field 2 command allows you to check name and address values for proper case such as 'THomas ThuMb' or 'Thomas thumb' and returns a value of 'Thomas Thumb'. The return value is ensured to have the first letter of each word capitalized and the remaining letters to be lower case.

CVTAUDJRNE

The Convert Audit Journal Entries command converts specific audit entries from the QAUDJRN journal to an outfile. The format of the outfile is determined by the entry type using system supplied model files. The intent of CVTAUDJRNE is to simplify the process of creating an outfile that can be used to write a query against audit entries.

CVTMSGQ2

The Convert Message Queue 2 command converts the messages found in an external message queue (such as QSYSOPR) to an outfile. This differs from the CVTMSGQ tool in that the open list QGYOLMSG API is used to allow a very large number of messages to be converted. Selection criteria allows different types of messages to be converted as well as a start date and time.

CVTOBJD2

The Convert Object Description 2 command creates the OBJDSCP outfile of objects similar to DSPOBJD. However, the output records contain only the object, library, and object type. The advantage of this approach is that the system does not have to determine the size of the objects. If a file has many members, the basic information can be retrieved quickly.

DSPDBFSTAT

The Display Data Base File Statistics command displays usage statistics for a physical file member. Usage for dependent logical files is also shown. This can assist in determining if logical file access paths should be used versus temporary indexes. The system data base statistics are used which are reset at each IPL.

DSPJOBLOG5

The Display Job Log 5 command provides a different method of viewing a job log and attempts to display the last escape message (and associated messages) first. The messages are displayed on an 80 byte wide display using a subfile with one line per message plus a detail display option. Different positions within the subfile can be quickly displayed along with a scanning capability to find any character string.

DSPTAPLBL

The Display Tape Label command displays or prints basic information about a tape label including the date the first file was written and the first expiration date. DSPTAPLBL is very efficient in displaying information from a virtual tape. The command can be very slow when certain tape devices are used.

ENDDSCJOB

The End Disconnected Job command checks for jobs in the DSC (disconnected) state and ends them by default. This allows a simple cleanup solution prior to a backup. An option exists to just list those jobs that are in the disconnected state.

RTVAUDMDLF

The Retrieve Audit Model File command retrieves the model file in QSYS based on an entry type for a journal entry. Only the entry types associated with the T journal code (for Journal type = Audit) are supported.

RTVDBFM

The Retrieve Library Data Base File Members command returns counts of data files and members and source files and members in a library.

RTVJOBTYPD

The Retrieve Job Type Description command returns a 15 byte description for a job type such as BCH or SBS.

RTVOUTDTAQ

The Retrieve Output Queue Data Queue command retrieves the information about a spooled file that has just entered the RDY status in an output queue. A data queue must be created to receive the data queue entries. This allows a CL program to be written to perform a typical task such as moving spooled files in a RDY status to a different output queue.

TRMFSTBLK

The Trim First Blank command trims an input value after the first blank position. For example, if 'ABC DEF' is input, 'ABC ' is returned. The INPVAL may be up to 256 bytes. The RTNVAL parameter must be specified as *CHAR LEN(256).

WRKOUTQ2

The Work Output Queue 2 command is similar to the system WRKOUTQ command, but allows a list of multiple output queues to be specified and an option for a WRKALLSPLF type program. WRKOUTQ2 does not support a command line such as on WRKOUTQ.

New tools as of July 15, 2006

ADDSPCAUT

The Add Special Authority command allows the addition of a special authority to one or more profiles. This is a simpler interface than CHGUSRPRF which requires an entry for any existing authorities as well as a new special authority. A RMVSPCAUT command is also provided to remove a special authority from one or more profiles.

CAPPTFINF

The Capture PTF Information tool allows you to periodically capture PTF information using the outfile from the system DSPPTF command. Each captured version becomes a separate member in the PTFINFP data base file. The CMPPTFINF command may then be used to compare the changes between different versions.

CHKMAILADR

The Check E-Mail Address command checks the validity of an E-Mail address. The local-portion of an address is ensured to have proper syntax. The domain-portion is either syntax checked or checked using APIs to determine if the domain name exists. To check if the domain name actually exists, your system must have access to a domain name server.

CHKMAILFLD

The Check E-Mail Field command checks a field in all records in a file for a valid E mail address. A listing is output. The local-portion of an address is ensured to have proper syntax. The domain-portion is either syntax checked or checked using APIs to determine if the domain name exists. To check if the domain name actually exists, your system must have access to a domain name server.

CPYFOMIT

The Copy File With Omit command copies from one file/member to another and omits records with specified values in a designated character field. The To file/member (it may be created) must have 0 records and have the same definition as the From file. The From file/member must not have 0 records. Up to 150 values may be specified to be omitted.

CRTVTP

The Create Virtual Tape tool provides a simple interface for creating, displaying, and deleting a virtual tape structure. The intent of the CRTVTP tool is that you would create or replace a virtual tape structure each time you need to use a virtual tape function and replace or delete it after the tape media is written.

CVTIMGCLG

The Convert Image Catalog command converts the image catalogs to the IMGCLGP outfile in a named library. The QVOIRCLG API is used to retrieve the entries. The model outfile is TAACLGBP with a format name of IMGCLGR.

CVTIMGCLGE

The Convert Image Catalog Entries command converts the entries for a specific image catalog to the IMGCLGEP outfile in a named library. The QVOIRCLD API is used to retrieve the entries. The model outfile is TAACLGAP with a format name of IMGCLGER.

CVTJOBLCK

The Convert Job Locks command converts the locks for a specific job to an outfile. The file can then be processed for a variety of needs. The name of the output file is JOBLCKP. The model file is TAAJOEDP with a format name of JOBLCKR.

CVTNETSTAT

The Convert Network Statistics tool allows the conversion of TCP network statistics to outfiles. Options on the CVTNETSTAT command allow conversion of TCP/IP 1) Interface status, 2) Route information, and 3) Connection status. Each of the sub functions is a separate command. System APIs are used to access the data.

CVTOBJD

The Convert Object Description command is similar to the DSPOBJD function of creating an outfile. Unlike DSPOBJD, an object name such as '*XYZ*' may be specified to output a record for any objects containing 'XYZ' within the name field. Selection by object attribute (eg PF) or owner may also be made.

CVTUSRPRF2

The Convert User Profile 2 command converts the DSPUSRPRF outfile to an externally described file containing all of the fields in the QADSPUPB outfile plus individual fields for each of the special authorities, each of the supplemental groups, etc. This allows a simple query to use the individual fields for analysis.

DSPJOBLOG4

The Display Job Log 4 command allows a user who has specific *USE authority to the TAASPLSEC authorization list to be able to display any job log on the system. Program adopt and group adopt are not considered valid.

DSPMSGTYP

The Display Message Type command provides a simple display of the codes and descriptions the system uses for the RCVMSG RTNTYPE parameter.

DSPVTPRSC

The Display Virtual Tape Resources command provides a subfile display of the virtual tape resources. The command must be entered in an interactive environment. To see the virtual tape resources that are in use, enter the DSPVTP command.

RTVDBFOVR

The Retrieve Data Base Override command retrieves the override values assigned to a data base file. The OVRDBF command is passed back in a large variable. RTVDBFOVR reads the spooled file created by DSPOVR. The command requires an upper/lower case English language system.

RTVMSKPWD

The Retrieve Masked Password tool provides a command to mask a password (CHGMSKPWD) and a command to retrieve a masked password (RTVMSKPWD). The password is translated to different characters and the positions are rearranged within a 256 byte field in the MSKPWDP file in TAASECURE. The tool may be used for a variety of needs such as with the TAA FTP commands which require a password be entered.

RTVNXTVER

The Retrieve Next Version command allows the input of a value such as ABC001, increments the digit portion and returns a value of ABC002. This can be helpful when an application is attempting to add another version.

RTVPRDDSC

The Retrieve Product Description command retrieves a description of a licensed product such as 5761SS1. The description is returned in a 25 byte variable.

RTVPRTOVR

The Retrieve Printer Overrides command retrieves the override values assigned to a printer file. The override command is passed back in a large variable so they may be used to override to a different file. Restrictions exist.

RTVTAPLBL

The Retrieve Tape Label command retrieves information about a mounted volume and the first file (if any). This can be used to determine such information as the volume ID, the owner, the density, the name of the first file on tape, the date it was written, and the expiration date. The QTARTLBL API is used.

RTVVTPRSC

The Retrieve Virtual Tape Resources command retrieves the list of virtual tape resources, the status of each, and a count of how many exist. The names and status of each of the resources are passed back in a 1000 byte and 1200 byte variables where each resource name is 10 bytes and each status is 12 bytes.

New tools as of Apr 15, 2006

CHKARACDE

The Check Area Code command provides a method of checking for a valid area code. The TAA9891 escape message is sent if the area code is invalid. An optional completion message is provided. Only the area codes provided by the PRTARACDE tool are supported (includes US, Canada, Caribbean, Samoa, etc).

CHKARAFLD

The Check Area Code Field command checks a named field in a data base file for a valid area code. Depending on the field type, different lengths are valid. Only the area codes provided by the PRTARACDE tool are supported (includes US, Canada, Caribbean, Samoa, etc).

CPYSPLFDTA

The Copy Spooled File Data command reads a spooled file and outputs a file intended for a spread sheet processor. Selection criteria exist so that only columnar data may be output. An option exists to include delimiters and column headings. Either a data base file or an IFS object may be output.

CPYUNQKEY

The Copy Unique Key Records command copies unmatched keyed records from one file to another. Both files must be keyed and have the same definition. This allows a merging to occur for unique keys. By default, PROCESS(*CHK) is used to check what the results would be. An optional listing of the matched and unmatched records may be specified.

DSPCCSID

The Display File CCSIDs command displays either a total of the CCSIDs that exist in a data base file or the CCSIDs for the individual fields. CCSIDs are assigned to each character field in a file and normally all character fields will use the same CCSID. If different CCSIDs are used within the file, different processing may be required. DSPCCSID allows you to determine if a file uses a standard CCSID for all character fields and what the value is.

DTAARC

The Data Archive provides online save files for critical data. Multiple version may exist. Options exist for 'save while active' and saving dependent logical files. The DTAARC tool is not intended to replace normal backup. A typical use would be to restore the save file to a different library to review a previous value. In an emergency, you can restore from the online save files.

JOBACT

The Job Active tool provides a periodic check for critical jobs that are designed to be active at all times. If one of these jobs is not active, a message may be sent to QSYSMSG (QSYSOPR is used if QSYSMSG does not exist) or a command may be run.

MOVCLPDCL

The Move CLP DCLs command moves DCL and DCLF statements from anywhere in CL or CLLE source to the correct place in the source. This allows you to enter a DCL statement when you are coding and then use MOVCLPDCL before compiling the program.

RTVARACDE

The Retrieve Area Code command retrieves the description of an area code including the time zone, state, and up to 5 descriptions (such as city names). Only the area codes provided in PRTARACDE are supported (includes US, Canada, Caribbean, Samoa, etc).

RTVCCSID

The Retrieve File CCSID (Code Character Set ID) command retrieves a summary of the CCSIDs specified for a data base file. CCSIDs are assigned to each character field in a file and normally all character fields will use the same CCSID. If different CCSIDs are used within the file, different processing may be required. RTVCCSID allows you to determine if a file uses a standard CCSID for all character fields and what the value is.

SBMTIMJOB2

The Submit Time Job 2 command is a front end to SBMJOB that allows the same job to be submitted multiple times for a given day. A start and end time must be specified as well as a time interval in minutes.

New tools as of Feb 15, 2006

CHGCMDLIB

The Change Command Library command allows you to change the name of the alternate library used for TAA commands (and a few other TAA objects). Depending on the existing command library, you may be asked to run DLTTAACMD and/or DUPTAACMD.

CPYSHFLFT

The Copy and Shift Left command copies a member beginning at a specified position to another member. This allows shifting of the data to the left. The user must have *ALL authority to the To file to use CPYSHFLFT.

PRTAUTLOBJ

The Print Authorization List Objects command prints a listing of one or more authorization lists and the objects that are authorized to each list. The system command DSPAUTLOBJ, lists only a single authorization list. See the PRTAUTL command for the user authorizations to the lists.

PRTMBRSUM

The Print Member Summary command prints a listing of all data base files in a library with one line per file. The number of members and the save date of the files are shown. Totals by PF-Dta, LF-Dta, and PF-Src are provided. PRTMBRSUM may be helpful to review how many members exist in a library.

PRTSPLANZ

The Print Spool Analysis command analyzes a QSPL library. A summary by day or month may be made. The listing includes the number of members (empty or with data) and the corresponding sizes. PRTSPLANZ provides a summary of how much spooled data exists.

SCNGENSRCD

The Scan Generic Source Description command provides a simple display or listing of generic source members. One line per member appears. Either a single source file, all source files, standard source files, or the QATT source files in a library may be requested.

New tools as of Nov 15, 2005

CHKNAMFLD

The Check Name Field command allows you to check or update a name and address field in a file for names such 'THomas ThuMb' or 'Thomas thumb' and have them changed to 'Thomas Thumb'. The field to be checked is ensured to have the first letter of each word capitalized and the remaining letters to be lower case.

CMPJOBSCDE

The Compare Job Schedule Entries command may be used to compare the values of job schedule entries from two different systems or from a previously captured version from the same system. The CVTJOBSCDE TAA command must be used to capture the information.

CMPLVLID

The Compare Level ID command compares level IDs for one, generic, or *ALL files in one library to another. An escape message is optional if differences exist. CMPLVLID may be helpful for situations such as when a file in a production library must match the same file in the test library.

CRTSFLPGM2

The Create Subfile Program 2 command creates a display file and program (RPG or RPGLE) which allows a display of data from arrays. A 'position to' function is optional. It is expected that you will make modifications to the program to build your own array, detail display, etc.

DLTMSGQMSG

The Delete Message Queue Messages command is an alternative to the RMVMSGQMSG command. DLTMSGQMSG is intended to be used when there are too many messages in a message queue for RMVMSGQMSG to be used. DLTMSGQMSG uses a different technique than RMVMSGQMSG. Messages may be deleted by a count or within a date range or both.

DSPLSTUSE

The Display Last Use command displays or prints a listing of one line per object in a library identifying the create date, the last used date, and the use count. Objects that have never been used are always listed. An option exists to list those objects that have not been used prior to a specified number of days. DSPLSTUSE helps determines what objects may be deleted because of lack of use.

FNDRNMRSTM

The Find Renamed Restore Members command outputs a spooled file for any members found that have a name ending in 4 digits. This typically occurs if a member has been saved, deleted, re-created with the same name, and then restored. One or more libraries may be searched. FNDRNMRSTM can assist you in cleaning up your system.

JOBANZ

The Job Analysis tool submits a never ending batch job to capture WRKACTJOB information at specified intervals. Options exist such as sending a message if a job has used more than a specified amount of CPU percentage during an interval. The JOBANZ tool can assist in determining which jobs and conditions are causing a slowdown in system performance.

SNDLNGMSG

The Send Long Message command is intended as a debugging aid to send one or more messages from a large variable. This allows the value of the variable to be more easily seen on a command entry display or in the job log. The message length may be between 20 and 512. A ruler is optional.

New tools as of Aug 15, 2005

CHKWRD

The Check Word command checks the spelling of a word. An escape message is sent if the word is not in one of the specified TAA dictionaries. The default dictionary includes about 80,000 English words, places, proper names, system words (eg QCLSRC), TAA words (eg ADDDAT), and PRTSEUTXT words (eg PARM1).

CRTSFLPGM

The Create Subfile Program command creates a file maintenance program which uses a subfile. A keyed file must be specified. Simple validity checking, lower case, and edit codes may be specified. Both display file and RPG program source are generated and then the objects are created. You may need to modify the code to provide for such things as advanced validity checking.

DSPUSRJOB

The Display User Job command is a display only version of the system WRKUSRJOB command. Only display options are valid for a job. An option exists to display, work with, or prevent access to the spooled files of a job. Any user can display jobs and display the details of his own job. Only a user with *JOBCTL special authority can display the the details of a job which is not his own.

FNDWRD

The Find Word command lets you find an English word beginning with the letters you specify or you may scan for all words containing the value that was entered. Wildcards ('_') may also be used. An option exists to include proper names such as 'John' and place names such as 'Johnstown'. The supplied dictionary that is searched has about 80,000 words and names. FNDWRD is helpful when you do not know how to spell a word or name.

PARSE

The Parse command allows the parsing of an input value into one or more return variables. A list of separator characters must be specified (default is 'blank') to determine how the input value should be parsed. Up to 30 return variables of a maximum length of 200 bytes may be returned. PARSE is not intended to parse an i5/OS command string.

PRTALLJOBQ

The Print All Job Queues command prints one line per job queue for one or many job queues. Each line has the total number of jobs by RLS, HLD, and SCD categories and the subsystem the job queue is attached to (if any). Options exist to bypass job queues that do not have any jobs and select those which have jobs that match a status such as HLD.

PRTALLOUTQ

The Print All Output Queues command prints one line per output queue for one or many output queues. Each line has the total number of spooled files, the number of pages to be printed, and the allocated size of the spooled files. Options exist to bypass output queues that do not have any spooled files and select those output queues that have spooled files that match a status such as HLD.

RMVCHAR

The RMVCHAR command is similar to the RPG IV %TRIMx functions. Unlike %TRIMx, RMVCHAR allows you to remove specified characters anywhere in a string of up to 1000 bytes. The length of the returned value may also be returned.

RTVMBRSUM

The Retrieve Member Summary command returns variables for such things as the number of members, the number of active records, and the data space size of all members for a data base file. Both physical and logical files are supported. RTVMBRSUM is designed for multi-member files. For single member files, the RTVMBRD and RTVLFMD should be used.

SAVDBDLF

The Save Data Base Dependent LFs and Restore Data Base Dependent LFs commands provide a solution for the case where a logical file is built over a physical file in another library and a system restore is needed. SAVDBDLF must be run prior to the save of the system. RSTDBDLF is run after the restore of the system to restore the logical files. Access paths may be rebuilt. A few LFs are created, saved by SAVDBDLF, then deleted before RSTDBDLF is run.

SPELL

The Spell command provides a simple name to remember to allow access to the CHKWRD and FNDWRD tools. A menu of all the TAA spell checking tools is also available.

TRIM

The TRIM command is similar to the RPG IV %TRIMx functions. Leading blanks may be trimmed off the left hand side of a value along with specified characters. Trailing characters may also be trimmed off the right side of a value. Because the command returns a 1000 byte variable, there is no concept of trimming off trailing blanks. The length of the returned value may also be returned.

New tools as of Jun 1, 2005

ADDSUPGRP

The Add Supplemental Group command allows the adding of a supplemental group profile to one or more user profiles. The companion command is Remove Supplemental Group to remove a supplemental group profile from one or more user profiles.

CAPSECINF

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

CAPSYSINF

The Capture System Information tool provides a method of capturing all object, member, and IFS object information on a system. Each type of information is optional. Each time CAPSYSINF is run, new versions are added to files in a named library (the default name is TAASYSINF). These files can then be used by other TAA Tools such as CPYSYSINF or CMPSYSINF or queried by user functions.

CHGDIRAUT

The Change Directory Authorization command changes the authorization to a directory and its objects and all subdirectories and their objects. The command is a front end to the system command CHGAUT and uses the same parameters. CHGDIRAUT simplifies making mass changes to IFS authorizations. You may need to change the test case for your home directory.

CMPNETA

The Compare Network Attributes command compares two different uses of CVTNETA and describes any differences. Each use of CVTNETA creates a named member with one record containing unique fields for all of the network attributes. The value of each network attribute is compared between the two file/members by CMPNETA. CHGNETA of MAXINTSSN to bump it by one, do the compare, and then reset MAXINTSSN.

CMPREGINF

The Compare Registration Information command compares two different uses of the CVTREGINF command and describes any differences. Each use of CVTREGINF creates a named member with one record for each combination of exit point and exit program. The values of each combination are compared from the two file/members by CMPREGINF. This will add an exit program and remove it when complete.

CMPSYSINF

The Compare System Information tool supports several commands to compare different versions of the information in the library specified on CRTSYSINF as captured by the CAPSYSINF command. This allows a determination of what objects are new, have been deleted, or have grown in size more than a specified value. The commands CMPSYSINFO, CMPSYSINFM, and CMPSYSINFI are provided.

CPYSYSINF

The Compare System Information tool supports several commands to compare different versions of the information in the library specified on CRTSYSINF as captured by the CAPSYSINF command. This allows a determination of what objects are new, have been deleted, or have grown in size more than a specified value. The commands CPYSYSINFO, CPYSYSINFM, and CPYSYSINFI are provided.

CVTNETA

The Convert Network Attributes command converts the network attributes to an outfile. NETATRP is the name of the outfile in the library you specify. One record with unique fields for each of the network attributes is written to the file. This allows a comparison to be made with other uses of CVTNETA at different dates. See the CMPNETA command.

DSPCLPCNT

The Display CLP Count command counts the number of lines of commands in a CL source member, generic members, or all members in a source file. Comment lines and blank lines are also counted. A percentage of comments is provided. DSPCLPCNT provides a better understanding of the amount of actual source versus a count of the number of statements in a source member.

DSPCMDCNT

The Display CMD Count command counts the number of lines of commands in a CMD source member, generic members, or all members in a source file. Comment lines and blank lines are also counted. A percentage of comments is provided. DSPCMDCNT provides a better understanding of the amount of actual source versus a count of the number of statements in a source member.

DSPDDSCNT

The Display DDS Count command counts the number of lines in a DDS source member, generic members, or all members in a source file. Comment lines and blank lines are also counted. A percentage of comments is provided. DSPDDSCNT provides a better understanding of the amount of actual source versus a count of the number of statements in a source member.

DSPRPGCNT

The Display RPG Count command counts the number of lines of code, array data, and comments in a source file. All RPG types are supported. A percentage of comments is provided. DSPRPGCNT provides a better understanding of the amount of actual source versus a count of the number of statements in a source member.

FNDRNMRSTF

The Find Renamed Restore File command outputs a spooled file for any files found that have a name ending in 4 digits. This typically occurs if a file has been saved, the format of the file has been changed, and you have requested a restore of the original object with ALWOBJDIF(*ALL). One or more libraries may be searched. FNDRNMRSTF can assist you in cleaning up your system.

GRTAUTMSGQ

The Grant Authority to Message Queue command is intended to prevent the *PUBLIC user from displaying and answering messages in a message queue such as QSYSOPR. The command sets the *PUBLIC authority to allow sending of messages, but prevents the use of DSPMSG to the message queue. A named user may be specified who will be able to both send messages and use DSPMSG.

RTVMBRD3

The Retrieve Member Description 3 tool is designed for HLL program use to retrieve the description of a member. An externally described data structure is used to both pass the ID fields (file, library, and member) and return the description fields. The program TAADBKUR must be called and passed the externally described data structure. No command exists.

SCNIFS

The Scan IFS command scans one or more stream files for an argument. If the argument is found anywhere in the stream file, a line is listed identifying the IFS object. SCNIFS assists in searching for values in the IFS.

SCNSRC2

The Scan Source 2 command is the inverse of the SCNSRC command. SCNSRC2 scans for an argument and lists the member in a spooled file if the argument does not exist. One, generic, or all members in a source file may be scanned. An outfile is optional.

New tools as of Apr 15, 2005

CRTLST

The Create List command is intended for the case where a CL program wants to create a variable that can be used to simulate a list passed from a command. This can be used with the TAA EXTLST function.

CVTJOBSPLF

The Convert Job Spooled Files command converts existing spooled files for a specified job to an outfile. The WRKSPLFP data base file is written with one record for each spooled file. This is the same format as used by CVTWRKSPLF. CVTJOBSPLF provides a performance advantage over CVTWRKSPLF when the spooled files for a specific job are needed.

DSPSPLSIZ

The Display Spool Size command displays the number of members and their size from the QSPL library. The number of members with and without data are also displayed. A member may exist that does not hold any spooled data as the system tries to limit the number of members that must be created.

DSPTXT

The Display Text tool simulates (as best it can) a PC browser function on an i5 System. The data to be displayed is passed in an array of up to 9,999 elements of 78 bytes each. You must supply a program to interface to the Display Text tool. Use the DMODSPTXT command for a demonstration.

ENDACTJOB

The End Active Job command ends jobs for a specific job name, a user name, or both. All batch and interactive jobs would be ended. Jobs on the job queue would not be ended.

IFSLST

The IFS List tool provides commands to create a list of IFS Directories that may be used with the CVTIFS OBJ(*IFSLST) and CAPSYSINF IFS(*IFSLST) functions. This provides a specific set of directory names that will be converted. This allows you to minimize the time it takes to do CVTIFS or CAPSYSINF to the IFS directories you are interested in.

PRTJBQAUT

The Print Job Queue Authority command prints a listing of all job queues in one or more libraries. The important security options such as OPRCTL and individual authorizations are listed for each job queue.

PRTOTQAUT

The Print Output Queue Authority command prints a listing of all output queues in one or more libraries. The important security options such as DSPDTA, OPRCTL, and individual authorizations are listed for each output queue.

RTVNXTDAY

The Retrieve Next Day of Week command retrieves the date and the number of days from a date until a named weekday. For example, what is the date of the next Sunday. The date is returned in CYYMMDD format.

RTVPGMDBGA

The Retrieve Program Debug Attributes command retrieves a Y/N value about whether a program or module can be debugged by the ILE debugger. APIs for the ILE debugger are used to return the debug information.

RTVSPLSIZ

The Retrieve Spool Size command retrieves the number of members and their size from the QSPL library. The number of members with and without data are also retrieved. A member may exist that does not hold any spooled data as the system tries to limit the number of members that must be created.

SCNOUTQ

The Scan Output Queue command scans for a spooled file name, generic name, or all spooled files in an output queue for 1 to 20 arguments. A spooled file is output with the results including the spooled file name, line number, and the data for each successful scan.

STRBCHDBG

The Start Batch Debug command assists in debugging a program or service program in batch. STRBCHDBG removes the tedious and confusing steps involved in setting up an environment to debug in batch. With STRBCHDBG, debugging a batch program becomes about as easy as debugging an interactive program. The ILE debugger is used to debug (this will allow debugging of OPM programs).

New tools as of Feb 1, 2005

BUSCAL

The Business Calendar tool provides a solution for the question 'How many working days exist between 2 dates?'. A 'business calendar' object (a *USRSPC) must be created. The definition of 'working days' is made by use of the WRKBUSCAL command which allows days to be 'excluded' such as 'Saturday', 'Christmas', or specific dates. WRKBUSCAL then builds a list of the 'excluded' and 'included' dates.

CHGOBJ

The Change Object command provides either CHGxxx or WRKxxx commands for most object types that can be changed. While the command is intended for use as a menu option where the object and object type are already known, it may be used as a general purpose CHGxxx command. Either a system or TAA command is used.

CHGSYSTXT

The Change System Library Text command allows the text descriptions of certain system libraries to be changed to the system supplied value as seen with GO LICPGM. Many system libraries are shipped with blank text descriptions. The default provides a listing of what would be changed. Other library text descriptions such as QDSNX may be optionally changed to English text.

CHKTAACMD

The Check TAA Command checks for TAA commands in a source file or all source files in a library or all libraries. The command is helpful for determining what usage is being made of TAA commands. See also the Determining TAA Tool usage option on HELPTAA.

CPYAFPSTMF

The Copy AFP Resources to Stream File command copies an AFP resource such as a page segment to a stream file. This allows a PC editor such as InfoPrint Designer to edit the information. The stream file would then be copied back and a command such as CRTPAGSEG to be run to re-create the original object.

DLTGENLIB

The Delete Generic Library command deletes one library or generic libraries. You must have *ALLOBJ special authority to use DLTGENLIB. You cannot delete a library beginning with the letter Q or the letters TAA.

DLYJOBLOOP

The Delay Job Loop command simplifies the case where you are in a loop waiting for some event to occur such as a subsystem to end. Because an unusual event might occur, good coding practice would be to place a limit on the number of times the program will wait for the event to occur. DLYJOBLOOP supports a LOOPLIMIT parameter that allows the command to send the CPF9898 escape message if the limit is reached.

DSPOBJ

The Display Object command provides various DSPxxx commands for most object types. While the command is intended for use as a menu option where the object and object type are already known, it may be used as a general purpose DSPxxx command. In some cases WRK commands are used when no corresponding DSP command exists. Either a system or TAA command is used.

DSPRPGHLP

The Display RPG Help tool provides help text and samples for 1) RPG III operation codes and 2) RPG IV operation codes (both fixed and free form), Built-in functions, and H/F/D keywords. Help text may be displayed when using the Source Entry Utility (SEU) by entering 'H' or % in any column of the sequence number or by the command DSPRPGHLP. An exit program must be specified for SEU. In addition, the F7 command key can be used to split a line or join 2 lines.

DSPSRCMBRS

The Display Source Members command displays or prints source member information from one or more source files with various selection criteria. The selection options include source type, generic member name, create date, change date, last used date, a scan of the member name or text, and the number of existing records. DSPSRCMBRS simplifies searching for source member information.

ENDSBS2

The End Subsystem 2 command is similar to the system ENDSBS command except ENDSBS2 does not complete until the subsystem has reached an inactive state. Wait time options may be specified. ENDSBS2 simplifies writing a CL program that ensures a subsystem has ended properly.

RTVCALDAYS

The Retrieve Calendar Days command returns a large variable with the days of the year in CYMD format plus a digit representing the day of the week (Sunday = 1). Each entry is 8 bytes. Selection criteria exists for specific days of the week. RTVCALDAYS is useful when a list of days is needed.

RTVSMTPA

The Retrieve SMTP Attributes command retrieves information based on a user ID about SMTP (Simple Mail Transfer Protocol). The QATMSMTPA file in QSYS is used. RTVSMTPA may only be used in a CL program.

SCNALLDTAA

The Scan All Data Areas command allows a scan for up to 20 different values for one, generic, or all data areas in a one or more libraries. This can be helpful when attempting to identify where values are located.

SNDTCPOUTQ

The Send TCP Output Queue command sends all spooled files in a named output queue to another system using TCP. The command uses SNDTCPSPLF for each spooled file to be sent.

WRKOBJTXT

The Work Object Text command provides a simple means of reviewing and cleaning up text for objects. A subfile of one or more objects in a library is displayed and allows a direct change to the text. Various selection criteria exist. Options exist to display, change, and delete the objects along with an option to display the object description.

New tools as of Dec 1, 2004

CHGPF2

The Change Physical File 2 command allows changes to one, generic, or all physical files in a library. Only the typical parameters that are changed by CHGPF are supported by CHGPF2. An omit list of files may be specified.

CHKDUPAP

The Check Duplicate Access Path command checks for files in one or more libraries that have a duplicate access path with another file. The system will automatically share an access path if it can. Complete duplicates and partial duplicates (where only the high order keys are the same) are listed. The purpose of CHKDUPAP is to assist in cleaning up objects that are not needed.

CLRSTMF

The Clear Stream File command clears a stream file in the IFS. The IFS entry will still exist, but the size of the entry will be 0 as seen by the WRKLNK display of attributes for the entry. The TAA RTVIFSED command will also return a 0 value for the size.

CRTCLPDCL

The Create CLP DCL command creates CLP DCL statements based on the field definitions of an externally described data base file. The DCL statements are added to the end of an existing source member. The statements can then be moved by a source editor to the DCL section of the source. CRTCLPDCL may be useful when dealing with an external definition of a data base file or a data area.

CRTCLPEXT

The Create CLP Extract command creates CLP source for use in extracting data from a record buffer to variables declared from a data base file format. The CRTCLPDCL command may be used to create the DCL commands. CRTCLPEXT simplifies the use of a RDDBR command from the CLPDBR tool. See also the CRTCLPINS command which performs the inverse function.

CRTCLPINS

The Create CLP Insert command creates CL source for use in inserting data from variables declared from a data base file into a record buffer. The CRTCLPDCL command may be used to create the DCL commands. CRTCLPINS simplifies the use of an UPDDBR or WRTDBR command from the CLPDBR tool. See also the CRTCLPEXT command which performs the inverse function.

CVTLFMD

The Convert Logical File Member Description command converts member information from one or more logical files to an outfile named LFMBRP in a named library. For each member of a logical file, one record is output for each 'based on' physical file. The file can then be analyzed by various functions.

CVTREGINF

The Convert Registration Information command converts the data displayed by WRKREGINF to an outfile. One record is written for each exit point and program that is registered. If no programs are registered for an exit point, a record will will still be written containing the exit point information. The QusRetrieveExitInformation API is used to extract the information.

PRTPGMCALL

The Print Program Calls command prints a listing of the calls from a program and optionally cascades to print the calls used by any sub programs. Parameter lists may optionally be printed. Only CL and RPG along with single module CLLE and RPGLE programs are supported.

RSTOBJIFS

The Restore Object from IFS command simplifies restoring objects from an IFS stream file such as was sent in an E mail attachment. The objects must have been saved by a SAVOBJ command such as the companion command SAVOBJIFS. RSTOBJIFS does the following: 1) Creates a save file in QTEMP using the name of the library where the objects exist 2) Uses CPYFRMSTMF to copy the stream file to the save file 3) Uses RSTOBJ to restore the objects to an existing library. See the companion tool SAVOBJIFS.

RTVSGNPOS

The Retrieve Sign Position command allows input of a zero decimal position field and returns a *CHAR LEN(1) value for the low order digit. The low order digit will be a zoned value. RTVSGNPOS is useful when attempting to convert a negative decimal value to a character value.

SAVLIBSAVF

The Save Library to Save Files command saves one or more libraries to save files in a specified library. Special values exist and libraries may be omitted. Save files are created if they do not exist using the name of the library to be saved. The intent of SAVLIBSAVF is to allow you to save to a library of save files that can then be backed up to media at a later time. The companion command DLTLIBSAVF will delete the created save files.

SAVOBJIFS

The Save Object to IFS command simplifies saving objects to an IFS stream file in order to allow the stream file to be used as an E mail attachment. The command does the following: 1) Creates a save file in QTEMP with the name of the library 2) Uses SAVOBJ to the save file 3) Uses CPYTOSTMF to copy the save file to the specified stream file. See the companion tool RSTOBJIFS.

SCNUPDCL

The Scan and Update CL Source command scans one or all members of CL or CMD source for an argument and if found replaces it with a replacement value. The replacement value can be the same length, a shorter length, or a longer length. The source is reformatted similar to prompting in SEU.

WRKNETA

The Work Network Attributes command provides a subfile of all network attributes and their current values. A Change option exists to allow a prompt for CHGNETA and the specifically selected network attribute. The existing current value is shown during the prompt. WRKNETA provides a significantly better interface than the system CHGNETA command which prompts for all parameters and shows *SAME.

WRKSPLF2

The Work Spooled File 2 command is similar to WRKSPLF, but allows better selection criteria. For example, you can select on a generic output queue name, spooled file size, number of pages, and other values. You must have *SPLCTL special authority to specify a user other than *CURRENT.

New tools as of Sept 1, 2004

CHKCMD

The Check Command command provides the functions of QCMDCHK with additional options provided by the QCAPCMD API. This includes 1) Prompting for the command on missing required parameters or some invalid entries and 2) Limited user checking. The command is not run, but can be useful when attempting to simulate a command line on a menu.

CLPDBR

The CLP Data Base Record tool provides a command interface to allow a CL program to position to (key or RR), read sequentially, read randomly (by key or RR), write, update, and delete data base records. A record buffer (string of data) must be provided (the tool does not operate on a list of fields).

CVTALLGRPP

The Convert All Group Profiles command builds a keyed data base file with one record for each combination of user profile and group profile. Supplemental groups are considered. The GRPPRFP file is output. You must have *ALLOBJ special authority to use CVTALLGRPP.

CVTSRVPGMA

The Convert Service Program Attributes command converts the attributes of *SRVPGM object types to an outfile named SRVPGMP in a named library. This provides a simple method of reviewing and processing service program objects.

DSPCMDHLP

The Display Command Help command displays the help text for a system or user command including commands the user is not authorized to. The command is useful for such functions as attempting to simulate the system command line function. The QCAPCMD API is used.

DSPLFMD

The Display Logical File Member Description command displays or prints information about a logical file member. The first based on physical file member information is also displayed.

DSPSBS

The Display Subsystem command provides a display for a single subsystem. High level information such as the status and number of active jobs are displayed. Up to 3 storage pools assigned to the subsystem are displayed and an option allows access to the storage pool statistics. Command keys exist to access the jobs that are active and the subsystem description.

DSPSTGPOOL

The Display Storage Pool command displays or prints the attributes and performance statistics of a storage pool. Either a shared pool name (such as *BASE) or a system pool ID may be specified. The display may be refreshed and the performance statistics reset.

MOVDECCHR

The Move Decimal to Character command moves a *DEC value (packed data) to a *CHAR LEN(8) variable and retains the packed representation. The data is right adjusted in the return variable. This allows the data to be passed to other functions which require a packed representation.

RSTLIBIFS

The Restore Library to IFS command simplifies restoring a library from an IFS stream file such as was sent in an E mail attachment. The library must have been saved by the companion tool SAVLIBIFS or a SAVLIB command. The command does the following: 1) creates a save file in QTEMP 2) uses CPYFRMSTMF to copy the stream file to the save file 3) uses RSTLIB to restore the library. The library to be restored must not exist.

RTVLFMD

The Retrieve Logical File Member Description command retrieves information about a logical file member. The 'based on' PF information is retrieved for the first physical member. The QUSRMBRD API is used.

RTVOBJAUT2

The Retrieve Object Authority 2 command retrieves the object authorities for a user of an object. Only the specific authorities for the user as seen on the DSPOBJAUT display are returned. Group authorities, Authorization List authorities, Program adopt, and *PUBLIC authorities are not considered.

RTVSBSPOOL

The Retrieve Subsystem Pool command uses the number assigned to a subsystem pool to retrieve the corresponding system pool number when the subsystem is active. This is the same information as seen on WRKSBS.

RTVSTGPOOL

The Retrieve Storage Pool command retrieves the information about a storage pool. Either a shared storage pool name or a pool ID must be specified. Various return parameters exist. The QWCRSSTS API is used.

RUNMNUCMD

The Run Menu Command command provides the functions of QCMDEXC with additional functions provided by the QCAPCMD API. The additional functions include: 1) Prompting for the command on missing required parameters or some invalid entries and 2) Limited user checking. The command can be useful when attempting to simulate a command line on a menu.

RVKDUPAUT

The Revoke Duplicate Authorizations command provides a method for checking and revoking duplicate authorizations such as a specific user has *CHANGE authority as well as the *PUBLIC user to the same object. Group profiles and authorization lists are also considered. By default only a check occurs which produces a listing (no authorizations are changed).

SAVLIBIFS

The Save Library to IFS command simplifies saving a library to an IFS stream file in order to allow the stream file be used as an E mail attachment. The command does the following: 1) creates a save file in QTEMP 2) uses SAVLIB to the save file 3) uses CPYTOSTMF to copy the save file to the specified stream file. See the companion tool RSTLIBIFS.

WRKJOBSTG

The Work Job Storage command provides a work display or a listing of the temporary storage used by active jobs. Selection criteria exists for the amount of storage, by job, and by user. This provides a simple review of the amount of storage being used. *JOBCTL is required to use WRKJOBSTG.

New tools as of June 15, 2004

ANZRPGSRC

The Analyze RPG Source command outputs a listing for a specific RPG or RPGLE source member. Some information is standard and is always output such as the number of comments and counts by spec type. Other information is optional such as where subroutines begin/end and an operation code summary. Both RPG III and RPG IV (fixed form) member types are supported.

BLKSYSMSG

The Blank System Message command allows you to blank out an existing message in a message file and rename the message ID. This is intended for bothersome messages such as EDT0630 ('Have you tried the modern alternative to SEU?'). The message will continue to be sent, but only blanks will appear on the display. When BLKSYSMSG is used, a confirming display appears with the text of the message to be blanked out.

CHGQHST

The Change QHST Version command creates a new version of a QHST file. The intent of the tool is to allow you to run the command at the end of some time period where you want to back up complete versions of QHST such as all for the previous month and start a new time period.

CHKASPSTG

The Check ASP Storage command allows you to check a percentage of available storage in an ASP against the size of objects you need to create. An escape message (TAA9896) is sent if the amount of requested storage exceeds a specified percent of available storage. This can be useful when an application needs to duplicate a large object in QTEMP.

CHKIFSDMG

The Check IFS Damage command attempts to save one or more individual IFS objects to a save file. *DIR, *FLR, and *DOC objects are bypassed. Messages are sent for those objects which could not be saved. While this is not a perfect solution, the messages can be used to indicate damage situations.

CLRUSRIDX

The Clear User Index command clears the entries from an existing user index. Any user index may be specified (not just those created by the TAA CRTUSRIDX command).

CPYMSGQ

The Copy Message Queue command copies messages from one message queue to another. Only *COMP, *DIAG, and *INFO message types are copied.

CRTUSRIDX

The Create User Index command creates a user index (*USRIDX) object. Only a fixed length keyed user index may be created. The length of an index entry may be from 1 to 2000 bytes. The user index may be used by other TAA tools or system functions.

CVTHEXOBJ

The Convert Hex Object Type command converts the internal object type form in hexadecimal (such as 0201) into the external object type form (such as *PGM). For the inverse function, see CVTOBJTYP. For a work display that allows interactive conversion, see DSPHEXOBJ.

CVTOBJTYP

The Convert Object Type command converts from an external object type (such as *PGM) to an integer value and/or a 4 byte character value (such as '0201'). For the inverse function, see CVTHEXOBJ. For a work display that allows interactive conversion, see DSPHEXOBJ.

CVTRMTOUTQ

The Convert Remote Output Queue command creates an outfile of the output queues that are specified as remote output queues. The base information is the same as that produced by CVTOUTQD plus the addition of information provided by RTVHOSTNAM. The output file name is RMTOUTP.

CVTTOMSGQ

The Convert To Message Queue command reads the output file (MSGLSTP) from CVTMSGQ and writes the messages to a specified message queue. Only *COMP, *DIAG, and *INFO message types are written. This allows copying messages from one message queue to another. See the CPYMSGQ command for a direct method of copying messages from one message queue to another.

CVTUSRIDX

The Convert User Index command creates an outfile of the entries from a user index. The outfile includes fields for the attributes of the user index as well as the entry information. The outfile created is named USRIDXP.

DLTDUPRCD

The Delete Duplicate Records command deletes duplicate records in a named file based on a series of key fields. By default, only a listing is output with what would occur if ACTION(*DELETE) was specified. When *DELETE is specified, the first duplicate record of a group is retained and the others are deleted.

DSPDUPCMD

Display Duplicate Command is intended to check if duplicate command names exist in two libraries or in one library and the rest of the system. Having duplicate command names can be an integrity or security exposure. The typical uses would be to ensure your user command names are not found in either QSYS or TAATOOL.

DSPHEXOBJ

The Display Hex Object Type command allows the input of an external object type (such as *DTAQ) and displays the internal hexadecimal value (such 0A01). It also allows the input of an internal object type (such as 0201) and displays the external object type (such as *PGM). The display may also be used for conversions.

DSPJOBSCDD

The Display Job Schedule Description command displays or prints a single job schedule entry. The command is usually entered as an option from the DSPJOBSCDE subfile, but may also be entered directly. The description may be displayed or printed.

DSPJOBSCDE

The Display Job Schedule Entries command is a 'display only' function similar to the system WRKJOBSCDE command. This allows making the WRKJOBSCDE command private so that only authorized users may make changes while the *PUBLIC user can use DSPJOBSCDE.

DSPUSRIDX

The Display User Index Entries command displays or prints the entries in a user index object. Only fixed length keyed user indexes are supported up to a 2000 byte maximum entry length. The initial display shows one line per entry and allows positioning to a key. A detail display is available with an option to display in hex.

DSPUSRIDXA

The Display User Index Attributes command displays or prints the attributes of a user index. Any user index may be specified (not just those created by the TAA CRTUSRIDX command).

FIXCLENDDO

The Fix CL ENDDO command adds a comment to the ENDDO commands in CL source that matches the expression such as (&A *EQ &B) of the corresponding IF command. MONMSG commands with EXEC(DO) are handled in a similar manner with the message ID added as a comment to the corresponding ENDDO. One, generic, or all CL and CLLE source members in a source file may be specified.

FIXSRCSEQ

The Fix Source Sequence Numbers command searches for invalid decimal data in the sequence number positions (1-6) of source statements. The default prints a report of any statements that have invalid decimal data. An option allows updating to create valid sequence numbers.

PRTCHGSUM

The Print Change Summary command prints one line per source member and describes the number of changes that have occurred from a specified date. This provides a good review of what has changed in a source file. By default, only the changed members are listed.

RTVHOSTNAM

The Retrieve Host Name command uses an IP address to retrieve the name of a host and up to 4 alias names. The command may be useful when the IP address is known, but not the system name. The 'gethostbyaddr' API is used.

RTVLSTQHST

The Retrieve Last QHST command retrieves information about the last (current) QHST file in QSYS. The number of QHST files and their total size may also be retrieved.

RTVOBJVER

The Retrieve Object Version command allows you to retrieve the first or last version (based on the create date/time) when the same object name exists in multiple libraries. The command is useful when different versions are shipped in different libraries.

RTVSRCCHG

The Retrieve Source Change command retrieves the number of source statements that have been changed in a source member since a specified date. The most current change date and the oldest change date are also returned.

RTVUSRIDXA

The Retrieve User Index Attributes command retrieves the attributes of a user index. Any user index may be retrieved from (not just those created by the TAA CRTUSRIDX command). The QUSRUIAT API is used.

SAVSRCF

The Save Source Files command allows a save of all source files in one or more libraries to tape or all source files in a single library to a save file. The system save commands allow only a save of *FILE objects and do not allow the saving of just source files.

SNDSTSCNT

The Send Status Count command provides a simple interface for sending a status message describing progress after the processing of n items. This allows the user to be informed of progress by a long running user written function that is processing items such as members or objects. Either a count, a percentage, or a 'progress bar' of the completed items may be sent. The command may only be used in a CL program.

USRIDX

The User Index tool provides an interface to allow reading, writing, updating, and deleting entries from a user index. Several other tools such as CRTUSRIDX also use interfaces provided by USRIDX. Only keyed fixed length user indexes are supported. The maximum entry length is 2000 bytes including the key.

WRKRMTOUTQ

The Work Remote Output Queue command provides a work display for remote output queues. Options exist such as STRRMTWTR, ENDWTR, HLDWTR, and WRKOUTQ. A print option also exists to provide a listing of all remote output queues. WRKRMTOUTQ lets you focus on the remote output queues.

New tools as of Mar 31, 2004

DSPACGSGN

The Display Job Accounting Signon command displays the job accounting records for interactive jobs within a range of 'From date/time' to 'To date/time'. All users or a generic user profile name may be entered. The user must have signed off and the Job Accounting journal entries converted for the JOBACG tool to find the information.

DSPDUPFLD

The Display Duplicate Field command checks a specific field or fields in a data base member for duplicates. The file is sorted on up to 6 fields and a program checks for duplicate values. Up to 3 print fields may be specified to help identify the records that have duplicate values.

DSPLSTSGN

The Display Last Signon command allows you to sequence user profiles by the last signon date/time and select on a range of 'From date/time' and 'To date/time'. All users or a generic user profile name may be entered. This can be used to display users who have signed on in the last n hours or have a last signon prior to n months ago.

DSPMBRLST

The Display Member List command is intended for multi-member data files. One, generic, or all files in a library may be listed. A heading line is printed for each file. One line is printed for each member in the file with information such as the create, change, and last used dates, number of records, etc.

DSPPWDINF

The Display Password Information command displays the information for one or more profiles relative to the password and signon information. The password itself is not displayed.

RTVPRTA

The Retrieve Printer Attributes command retrieves the attributes of a printer and the status of what it is printing. Because many attributes exist, two commands (RTVPRTA and RTVPRTA2) are used. Choose one or both to return the attributes you need.

SAVRCVL

The Save and Receive Library with FTP command is designed to simplify receiving a library from another i5 System. The SAVRCVL command saves the library to a save file in QTEMP and transmits the save file using FTP.

UPDMSGF

The Update Message File command uses the MSGFP outfile created from the TAA CVTMSGF command to update the message descriptions in a message file. UPDMSGF allows you to keep a data base file of messages or update selected messages on the same or another system.

WRTIFS

The Write IFS tool provides a solution for writing to the IFS from RPG programs using RPG's SPECIAL file. Sample programs are provided that range from simple to complex in terms of the function that is used. You may use these as models for your programming. A standard program (WRTIFS) exists in TAATOOL that may be called as part of the SPECIAL file.

New tools as of Jan 15, 2004

CHKIFSOPN

The Check IFS Open command provides a method of determining if an IFS object is available for a type of use and allows a specified type of sharing with other jobs. If the open is successful, the file is closed and the command completes normally. If the file cannot be opened, TAA9872 is sent as an escape message.

CVTDTAARA

The Convert Data Area command converts the attributes and the data from one or more data areas to the outfile DTAARAV. Both *DEC and *CHAR data areas are supported. The outfile may then be queried for consistency or searching for specific values.

DSPCURUSR

The Display Current User command is similar to the WRKUSRJOB system command except that the current user of the job is also shown and no change options are allowed. This allows support for jobs that swap profiles to be displayed. Only active jobs are displayed.

FTP2

The FTP2 (Start TCP/IP File Transfer) command allows the use of FTP without entering the FTP subcommands. The subcommands are generated internally and used to send a file to a remote system. A log of FTP subcommands, errors, and information is kept to allow error reporting.

PRTCRTUSR

The Print by Create User command prints the objects in one or more libraries by the user who created the object. This may not be the current owner of the object. The user who created the object may not exist on your system. Selection can be used on a minimum create date, a minimum last used date, and the size of the object. PRTCRTUSR can be helpful in cleaning up the system if group profiles own most of the objects.

RSTMNYCHG

The Restore Many Changes command restores from a tape created by SAVCHGOBJ or TAA tools such as SAVALLCHG which uses SAVCHGOBJ. The command allows one or more libraries to be restored. See the companion command RSTALLCHG which allows a restore of all libraries from a tape with an optional list of excluded libraries.

RTVCURMBR

The Retrieve Current Member command retrieves information about the newest member (or generic member) in a data base file. This is based on the create date/time of the members. RTVCURMBR may be helpful when you want to process the most current member of a file and do not know the name of the member.

RTVHOMDIR

The Retrieve Home Directory command retrieves the home directory from the user profile for a named user. You must have *USE authority to the user profile to retrieve the information for a profile that is not your own. The RtvUsrInf API is used to extract the information.

RTVNONSYS

The Retrieve Non-System command retrieves the libraries that are not saved by a SAVLIB(*NONSYS). Each entry returned has 2 libraries to allow for a range test such as QSYS00033 to QSYS00255. If only a single library like QSYS is not saved, the name is placed in both parts of the entry.

RTVUSRTXT

The Retrieve User Text command retrieves a user text description based on a user profile name. The command is useful if additional information is stored in the text description of the user profile or as a sub function when just the description is needed. The user of the command does not need to be authorized to the user profile. Only the text description is retrieved.

SAVCHG23

The Save Change 23 command is intended to be used on a daily basis between a periodic use of a Save Option 21 that saves the entire system. SAVCHG23 saves 1) System values, 2) Reply list entries, 3) Network Attributes, 4) Security data, 5) Configuration data, 6) Changes to objects in all user libraries 7) Changes to objects in system libraries that contain user data 8) Changes to DLO objects, and 8) Changes to IFS objects. The restricted state is not required. IASPs are not saved.

SAVSNDL

The Save and Send Library with FTP tool is designed to simplify sending a library to another i5 System. Your objects should be placed in a unique library. The SAVSNDL command saves your library to a save file and the save file is transmitted using FTP. On the remote system, use RSTSNDL (part of the SAVSNDL tool) to restore the library.

SORTCMDLST

The Sort Command List command allows the sorting of a simple list. The list would normally be input from a command which allowed multiple entries (such as a list of library names) and you want to process the names in the list in ascending sequence.

UPSMON

The UPS Monitor tool provides a solution for achieving a normal system power down after a power outage occurs and a delay time has been reached. You must have a UPS attached to the system and understand its capabilities. You must ensure the TAAUPSMON job is running.

WRKCURUSR

The Work Current User command is similar to the WRKUSRJOB system command except that the current user of the job is also shown. This allows support for jobs that swap profiles to be displayed and operated on. The same options as on WRKUSRJOB such as CHGJOB are supported. Only active jobs are displayed.

New tools as of Oct 15, 2003

CHGDSTPWD2

The Change DST Password 2 command resets the DST password to the default value. The purpose of the command is allow a user who is not QSECOFR to reset the DST password. CHGDSTPWD2 may only be used interactively by a user who is authorized to the TAADSTPWD2 authorization list.

CHGINLMNU

The Change Initial Menu command checks or changes the initial menu in one, generic, all user profiles, or in the profiles belonging to a group profile. System profiles are never changed. An existing initial menu may be named to ensure that only specific changes are made. The current initial menu value may be a specific initial menu, *ANY, or *SIGNOFF.

CHGINLPGM

The Change Initial Program command checks or changes the initial program in one, generic, all user profiles, or in the profiles belonging to a group profile. System profiles are never changed. An existing initial program may be named to ensure that only specific changes are made. The current initial program value may be a specific initial program, *ANY, or *NONE.

CHKTAP2

The Check Tape 2 command is similar to the system CHKTAP command. Neither the system CHKTAP nor the SAVxxx commands will send an inquiry message to the device's message queue if the tape is not in a 'ready' status (such as no tape is mounted), the volume ID does not exist, the sequence number does not exist, etc. CHKTAP2 sends an inquiry message requesting a C = Cancel, or R = Retry response.

CVTFD

The Convert File Description command is similar to the system DSPFD command, but only creates an outfile (does not print or display). In addition to the base functions of DSPFD, CVTFD also provides for IASP support. Selection can be made by type of library and a omit list of libraries may be specified.

DLTIFSDIR

The Delete IFS Directory command optionally deletes a directory and all sub items within the directory including other directories. The default is 'check' which produces a listing of what would be deleted and any errors such as 'not authorized to delete'. Several catastrophic operations are prevented such as deleting the root ('/'), /QDLS, and /QSYS/LIB.

DSAOLDPRF

The Disable Old Profile command optionally disables user profiles that have not been signed onto recently or not at all. Two retention periods may be specified for: 1) Profiles that have not signed on recently. 2) Profiles that have never signed on. Profiles created by the system or are PASSWORD(*NONE) are not considered. DSAOLDPRF may be used to minimize the exposure that profiles will be inappropriately used.

DSPPGMSTMT

The Display Program Statement command is intended as a debugging aid when an error has occurred and the MI instruction number is known, but the HLL source sequence number is not. By entering the program name and the MI instruction number, DSPPGMSTMT displays a spooled file with the HLL source sequence number and statement. Only CLP and RPG OPM program types are supported. The source for the program must exist.

DSPUSRTXT

The Display User Text command displays a user text description based on a user profile name. The command is useful if additional information is stored in the text description of the user profile. The user of the command does not need to be authorized to the user profile. Only the text description is displayed.

FIXQLFCPP

The Fix Qualified CPP command is intended to library qualify the programs that are called from the command definition object of user written commands. This is an important consideration if you write programs that adopt (USRPRF = *OWNER). A command definition object (*CMD) describes the CPP and its library. If the CPP uses *LIBL or *CURLIB, FIXQLFNAM determines if the CPP is on the library list and if so provides an option to change the command definition object.

PRTGRPPRF

The Print Group Profile command prints one or all group profiles along with the members of each group. The listing contains more information than the system commands which display group profiles. PRTGRPPRF provides for a better review of your group profiles and the members of the group.

RTVALLUSR

The Retrieve All User command retrieves the exception libraries found in the SAVLIB LIB(*ALLUSR) help text for system libraries. Unique return parameters exist for # and Q libraries. The # libraries are not saved by SAVLIB(*ALLUSR). The Q libraries are saved by SAVLIB(*ALLUSR). This assists in the processing of commands that emulate the *ALLUSR function or the unique TAA *ALLUSR2 function.

RTVLIBL

The Retrieve Library List command returns a single variable which contains the libraries in the library list in the same sequence the system will check them when *LIBL is used. RTVJOBA returns portions of the library list, but not the complete list. The return variable is large enough to account for additional growth. If the same library exists twice on the list, only the first occurrence is returned.

RTVOUTFILE

The Retrieve Outfile command retrieves the model file and format for commands which create outfiles. Both system DSPxxx and TAA CVTxxx commands are supported. RTVOUTFILE may only be used with commands that use a single outfile. For example, DSPFD and CVTFD support multiple outfiles and are not supported. If a TAA CVT command is used, the outfile name used is also retrieved if one exists.

SNDESCINF

The Send Escape Information command is designed to work in a CL program standard error handling routine such as used in the TAA Productivity Tools. You must first extract the SENDER information from an escape message and specify it on SNDESCINF. SNDESCINF sends a message with the program, library, and MI instruction where the escape message occurred.

New tools as of Aug 15, 2003

ANZFLD

The Analyze Field command sequences an externally described file on a named field and allows analysis by percentiles, ranges, or unique values. For each summary line printed, decimal fields may be summed, averaged, the maximum and minimum values determined, and the standard deviation calculated. Selection criteria may be specified to limit what is processed.

DLTEVENT

The Delete EVENT command deletes the EVFEVENT files in one or more libraries. EVFEVENT files are created by ILE compilers and debuggers and may consume a large amount of space. Only one file will exist per library, but will contain a member for each program. If you don't have any, using STRTRCDBG will create one.

MTNALLJRN

The Maintain All Journals command provides a simple means of creating and deleting journal receivers for all journals on the system. The command is intended to be run just prior to a backup. This allows for a full save of the recently detached journal receivers and deletes any old journal receivers that are already saved. A listing is provided of all journals and journal receivers with any action taken.

PRTBIGOBJ

The Print Big Object tool assists in determining the large size objects on your system. This can help cleanup of a system. One or more libraries may be processed by a single command. An optional exception file may be used to avoid flagging those objects which are known to be large.

PRTOWNOBJ

The Print Owned Objects command prints a listing of owned objects. The command is similar to the system DSPUSRPRF TYPE(*OBJOWN) function, but provides better output (such as last change date, last used date, size, etc). You can select on the last used date and a minimum size to reduce the number of objects that will be listed.

RTVIPLTIM

The Retrieve IPL Time command retrieves the date/time the IPL started/ended, the number of seconds required to IPL, and the same information for the last powerdown. The end time of the IPL is not the time the system is fully operational as other jobs must be started such as TCP. RTVIPLTIM provides basic information about the time required.

RTVQLFNAM

The Retrieve Qualified Name command extracts the command, qualifier, and label from a string. It also returns variables for whether a prompt character (?) exists, whether a leading comment exists, and the library where the command exists.

RTVSYSPTN

The Retrieve System Partition command returns the total number of partitions on a system and the current partition. The command is useful when dealing with LPAR systems.

New tools as of July 15, 2003

ADDRPYLE2

The Add Reply List Entry 2 command uses the outfile created by CVTRPYLE on one system to allow individual entries to be added to another system. One entry at a time is added to the System Reply List. The command can make it easier to keep the System Reply Lists similar on multiple systems.

CHKCPPAUT

The Check CPP Authority command checks command objects in one or more libraries that are specified as *PUBLIC *EXCLUDE. If the Command Processing Program (CPP) is not also *PUBLIC *EXCLUDE, the command is flagged. If your intent is to prevent access by the *PUBLIC user to a command, the CPP should also be considered for *PUBLIC *EXCLUDE to prevent the use of the CALL command to the CPP.

CHKDUPOBJ

The Check Duplicate Object command checks for duplicate object type/names in multiple libraries. A listing is output describing the duplicate groups. This can be helpful when attempting to clean up the system or solving problems.

CLCUCCCHKD

The Calculate UCC Check Digit command calculates the check digit for several UCC standards such as UPC-12 used for most grocery items. This can be used to assist in assigning the value for a new item.

CMPMNU

The Compare Menu command compares the CRTMNU command parameters of two Menu objects. A spooled file is created of any differences.

CVTASPA

The Convert ASP Attributes command builds an outfile of one or all ASPs (Auxiliary Storage Pools). The outfile created is named ASPP. The outfile may then be queried for consistency or searching for specific values such as the overflow recovery policy.

CVTJOBQA

The Convert Job Queue Attributes command builds an outfile of one or more Job Queue objects. The outfile created is named JOBQAP. The outfile may then be queried for consistency or searching for specific values such as those job queue objects containing jobs.

CVTLIBA

The Convert Library Attributes command builds an outfile of one or more Library objects. The outfile created is named LIBP. The outfile may then be queried for consistency or searching for specific values such as those Library objects that are specified as TEST types.

CVTMNUA

The Convert Menu Attributes command builds an outfile of one or more Menu objects. The outfile created is named MNUP. The outfile may then be queried for consistency or searching for specific values such as the programs that are used for menus.

CVTMSGFA

The Convert Message File Attributes command builds an outfile of one or more Message File objects. The outfile created is named MSGFAP. The outfile may then be queried for consistency or searching for specific values such as those Message File objects containing a certain CCSID.

CVTOPNF

The Convert Open Files command builds an outfile of the files that are open to a job. The outfile created is named OPNFILP. You must have *JOBCTL special authority to specify a job that is not being run under the same profile name. The QDMLOPNF API is used.

CVTUSRSPCA

The Convert User Space Attributes command builds an outfile of one or more User Space objects. The outfile created is named USRSPCP. The outfile may then be queried for consistency or searching for specific values such as the Autom Extend option.

DLTDSAPRF

The Delete Disabled Profile tool provides a cleanup function to allow disabled profiles to be deleted after N days. You must run a nightly job that is entered into the job scheduler by the STRDSAPRF command. Q name profiles and PWD(*NONE) profiles are never deleted. The default provides a check of what the command would do.

DSPPHNINTL

The Display Phone International command displays one, some, or all of the prefixes used for international calls. You may search by prefix or country abbreviation (such as POR). Only major cities are supported and many cities in English speaking countries.

DSPUSRAUT2

The Display User Authority 2 command displays a user's authority to objects within a library. Both individual authority, group authority (including supplemental groups), and authority controlled by authorization lists are described. An individual object, a generic name, or all objects can be specified. A specific type, or all object types may be requested.

FIXQLFNAM

The Fix Qualified Name command allows you to add a library qualifier to non-system commands (and optionally to system commands) used within CL source. The source is updated to include the library that the command is found in. The source is reformatted in a manner similar to if you had prompted for every command in SEU. The library of the command must be on the library list and the first occurrence is used.

PRTJRNANLI

The Print Journal Analysis IFS command analyzes the IFS Journal Code entries (JOCODE = B). You must first create an OUTFILE using DSPJRN with a *TYPE1 format. Only the B entries are selected and sorted. You may cause a control break on the object, program within object, or user within program within object.

PRTPHNINTL

The Print Phone International command prints a listing of the prefix phone codes used for international long distance. You may search by prefix or country abbreviation (such as POR). An option exists to print all countries by prefix. Only major cities are supported and many cities in English speaking countries.

RTVAUTSRCD

The Retrieve Authority Source Description command translates the 2 character 'Authority Source' provided by the QSYRUSRA API or the TAA RTVOBJAUT command and returns a 30 byte text description. The description can be used to provide a meaningful value for how authority is determined.

RTVIFSPATH

The Retrieve IFS Path command retrieves the IFS path name based on a 'File ID' such as found in a journal entry when an IFS object is journaled. An IFS journal entry does not contain the complete path name. The 'File ID' (16 bytes) is placed in the object name and library name (first 6 bytes). RTVIFSPATH allows a conversion from the 'File ID' to the actual path name. The API Qp0LGetPathFromFileID is used.

RTVMNUA

The Retrieve Menu Attributes command retrieves the attributes of a *MENU object. This assists in any application function where the attributes of a menu are needed. The function is release dependent and limited to upper and lower case English versions of the listing output.

RTVOBJLIB

The Retrieve Object Library command returns the library name where a specified object was found. The libraries searched are specified in a library group as defined by the TAALIBGRP tool. The intent of the tool is to be used as sub function when the library list cannot be used to identify all of the libraries where an object may exist.

RTVRPYLE

The Retrieve Reply List Entry command retrieves the attributes of a specific System Reply List Entry based on a Sequence Number. Because the command returns variables, it may only be used in a CL program.

New tools as of May 1, 2003

CPYIFSSPLF

The Copy IFS to Spooled File (CPYIFSSPLF) command creates a spooled file from the output of CPYSPLFIFS STMFTYPE(*SYS). The intent of the two commands is to allow a spooled file on a source system to be converted to the IFS, sent as an attachment to an E-mail, received on a target system, downloaded to the IFS, and then converted to a spooled file.

CVTCLSA

The Convert Class Attributes command builds an outfile of one or more Class objects. The outfile created is named CLSP. The outfile may then be queried for consistency or searching for specific values such as those Class objects containing a certain run priority.

CVTCMDA

The Convert Command Attributes command builds an outfile of one or more Command objects. The outfile created is named CMDP. The outfile may then be queried for consistency or searching for specific values such as those Command objects containing a prompt override program.

CVTDTAARAA

The Convert Data Area Attributes command builds an outfile of one or more Data Area objects. The outfile created is named DTAARAP. The outfile may then be queried for consistency or searching for specific values such as those Data Area objects containing decimal values.

CVTDTAQA

The Convert Data Queue Attributes command builds an outfile of one or more Data Queue objects. The outfile created is named DTAQP. The outfile may then be queried for consistency or searching for specific values such as those Data Queue objects with keyed sequence.

CVTMSGQA

The Convert Message Queue Attributes command builds an outfile of one or more Message Queue objects. The outfile created is named MSGQP. The outfile may then be queried for consistency or searching for specific values such as those Message Queue objects containing messages.

FRCOBJSTG

The Force Object Storage command forces an object in the *USER domain to non-volatile storage. Only the object types *USRIDX, *USRQ, and *USRSPC may be specified and the object must be in the *USER domain. Without forcing the object to non-volatile storage (disk), a system failure could cause the object on disk to contain the value prior to your change.

New tools as of Mar 15, 2003

CHGLIBOBJA

The Change Library Object Authorities command changes the owner, authorization list, and individual authorities of one or more objects in a library based on the output of the CVTLIBOBJA command. This may be used to help keep the authorization information the same between libraries on different systems.

CHKINACT

The Check Inactive tool provides a function to end or discontinue inactive interactive jobs. The typical example is where the user has walked away from the workstation without signing off. The system values QINACTITV and QINACTMSGQ are used plus a standard program which runs continuously in batch. A list of exception devices/users may be specified and a list of 'run status' values may be used to check whether to perform an action on the job.

CMPLIBOBJA

The Compare Library Object Authorities command compares the output of two uses of CVTLIBOBJA and prints a list of differences. This may be used to compare the authorizations between what should be the same library on different systems or a previous version of the authorizations from the same library.

CVTALLDBD

The Convert All Data Base Dependencies command finds all files on the system or all files in all user libraries for the situation where the -Based on- physical file is in a library other than the dependent file. An outfile ALLDBDP is created containing one record for each dependent file that is in a different library.

CVTJOBD

The Convert Job Description command builds an outfile of one or more Job Descriptions. The outfile created is named JOBDP. The outfile may then be queried for consistency or searching for specific values such as those job descriptions containing a certain job queue.

CVTLIBOBJA

The Convert Library Object Authorities command builds an outfile of all the authorizations to objects in one or more libraries. The outfile may then be used for a function such as the CMPLIBOBJA or the CHGLIBOBJA TAA Tools.

DUPTAADBF

The Duplicate TAA Data Base File command is an internal tool that is used to duplicate certain files from TAATOOL when a CVTxxx TAA command is used. The command is not intended to be used by users except within the CVT programs. The purpose of the tool is to allow files in TAATOOL to be *PUBLIC *USE and still allow the file to be duplicated. The program adopts QSECOFR authority.

FNDOBJTXT

The Find Object Text command searches for a string of characters in the object descriptions in a single library, multiple libraries, or all libraries. Either messages are sent or a spooled file is output. The intent of FNDOBJTXT is to assist you when you cannot remember the object name, but you do remember some string of characters in the object text.

FNDSRCTXT

The Find Source Text command searches for a string of characters in the text description of all source members in a single library, multiple libraries, or all libraries. Either messages are sent or a spooled file is output. The intent of FNDSRCTXT is to assist you when you cannot remember the source member name, but you do remember some string of characters in the member text description.

PRTCPYSPL2

The Print CPYSPL2 command provides an inverse function of the CPYSPLF2 TAA function. CPYSPLF2 creates a data base file from a spooled input file with blank lines and a new page indication. This allows a display of the data using a program rather than DSPSPLF. PRTCPYSPL2 reads the outfile created by CPYSPLF2 and re-generates a spooled file.

PRTJOBQTIM

The Print Job Queue Time tool provides assistance in answering the question 'How much time is spent by batch jobs on a job queue waiting to go active?' You must be using the TAA Job Accounting tool. The CVTJOBQTIM command is used first to select records from the JOBACGP file and create the JOBQTIMP outfile. The PRTJOBQTIM command may then be used to print a listing with various selection and sort criteria.

RCLSYSPRF

The Reclaim System Profiles command is a damage recovery tool that resets the system profiles that are not intended to be signed onto (such as QDBSHR) to their original critical attributes. The API QSYRESPA is used.

New tools as of Dec 15, 2002

APYRMTJRN

The Apply Remote Journal tool provides 'real time' data replication to a remote system using the system remote journaling support. Only data from data base members, data areas, and data queues are supported. The function may be used for a variety of application needs. If used for high availability, you have the responsibility of keeping the environment in synch (such as changes to programs, object attributes, etc).

CHKJRNLIB

The Check Journal Library command checks a library to see if a specified list of object types is journaled to a named journal. Physical data files, data areas, and data queues may be checked. Diagnostic messages are sent for the objects that are not journaled and a final escape message occurs if any objects are not journaled.

CHKPGMRLS

The Check Program Release command allows you to check for programs and modules that were created on a specific release. You may run the command over multiple or all libraries. Options exist to exclude certain releases, omit a list of libraries, and to replace the program or module if the source exists.

CHKRMTJRN

The Check Remote Journal command checks for an *ACTIVE journal state of a remote journal. If the state is not *ACTIVE, different escape messages are sent to describe the current state (*INACTIVE = TAA9895, *FAILED = TAA9896, and *CTLINACT = TAA9897). This provides a simple means of testing for the critical ongoing requirement that allows remote journaling to be successful.

CLCDAYS

The Calculate Days command allows you to determine how many specific days (Sundays, Mondays ... Saturdays) exist between two dates. You may name one or more days in the week to be considered. For example, you can count the number of Tuesdays and Thursdays that exist between two dates (the start and end dates are included).

CLCDBFHSH

The Calculate Data Base File Hash command determines a hash value for the data in a data base member. The intent of the command is to provide a comparison method for large files on different systems without transporting the entire file and making a comparison. An optional outfile HASHP may be written. The CMPDBFHSH command is supported to compare HASHP files in different libraries.

CMPDTAQE

The Compare Data Queue Entries command compares the entries and keys (if any) for two data queues. The intent of the command is to allow a comparison when data queue entries are duplicated such as in a remote journal environment. The date/time values of when an entry was sent are not compared.

CPYBCKDTAQ

The Copy Back Data Queue command is intended for refreshing a data queue or duplicating the entries to a different data queue. You must first convert the entries in the data queue to the DTAQP file with the TAA CVTDTAQ command. CPYBCKDTAQ then reads the data from the DTAQP file and uses the QSNDDTAQ API to send the entries to a named data queue. Both keyed and non-keyed data queues are supported.

CVTDEVDSP

The Convert Device Display command creates an outfile of display devices. The outfile created is named DEVDSPP. The information in the outfile is taken from the device description for each device.

CVTDEVPRT

The Convert Device Printer command creates an outfile of printer devices. The outfile created is named DEVPRTP. The information in the outfile is taken from the device description for each device.

CVTDLTSPC

The Convert Deleted Space command converts member information from one or more files to an outfile. It is intended to be used for queries regarding members with deleted record space. If variable length fields exist, the allocated length is output in addition to the maximum record length. A 'minimum' amount of total deleted space is included. An omit list of libraries may also be specified.

CVTDTAQ

The Convert Data Queue command converts the entries from a keyed or non-keyed TYPE(*STD) data queue to an outfile named DTAQP. One record is written for each entry. The size of the entry field in the outfile is limited to 9,000 bytes. Data is truncated if it exceeds this amount.

CVTGRPPRF

The Convert Group Profiles command creates an outfile of the members of a group profile. The user profile information will appear in the outfile if the user profile is specified as the value for the GRPPRF parameter or is in the list supplied for the SUPGRPPRF parameters. This provides a simple method of reviewing and processing the members of a group. The outfile name is GRPPRFP.

CVTIPDEV

The Convert IP Device command converts the IP devices to the IPDEVP outfile in a named library. TCP must be active. Only TCP/IPv4 network interfaces are supported. One record is written for each IP device. The API QtocLstNetIfc is used. For a description of the field values in the outfile, refer to the API documentation for format NIFC0100.

DLTJOBSPLF

The Delete Job's Spooled Files command deletes the spooled files for a specified job. The major intent of the command is to be used in batch where spooled files may be created that are not needed if the job ends normally. If a user has multiple interactive jobs and one creates excess spooled files, DLTJOBSPLF may be used to cleanup.

DLTOBJTYP

The Delete Object Type command allows you to delete one, generic, or a list of object types in a library. Most popular object types are supported. If *FILE type objects are requested, all non physical files are deleted first. A spooled file describes the results. An escape message will occur if not all of the requested objects can be deleted.

DSPALLSAVF

The Display All Save Files command displays or prints a listing of one, generic, or all save files in one or more libraries. A minimum size may be specified to help determine the large save files that are on the system. A special minimum size value *NONCLR will find all save files that are not empty.

DSPDLTSPC

The Display Deleted Space command displays the amount of deleted record space that exists in one or more libraries. If variable length fields exist, the allocated length is considered rather than the maximum record length. An omit list of libraries may also be specified.

DSPOBJJRNA

The Display Object Journal Attributes command displays or prints the journal attributes for a physical file, a data area, or a data queue. This is the same information that may be seen using DSPOBJD and rolling up several screens.

DSPSRCTYP

The Display Source Type tool displays the standard source types used by the system and a text description for each.

FNDOBJNAM

The Find Object Name command searches for an object name, a generic object name, or a string of characters in a object name. A single object type or all object types may be searched. A single library, multiple libraries, or all libraries may be searched. Either messages are sent or a spooled file is output. The intent of FNDOBJNAM is to assist you when you can remember something about the object name, but not necessarily the full name or where you placed the object.

RSTTAASTMF

The Restore TAA Stream File command is designed to restore the PF528 stream file containing a library for TAA tool source. The stream file is the standard name used when revised TAA source is sent to you via an E mail attachment. You must first copy the E mail attachment into an IFS directory. You may perform the copy by mounting the IFS through 'Network Neighborhood' (Net Server) or by FTP.

RTVRMTJRNA

The Retrieve Remote Journal Attributes command returns information for a single remote journal. The command runs on the source system and the source journal must be specified. If no relational data base entry and no target journal is specified, the information for the first remote journal is retrieved.

New tools as of Sep 15, 2002

CHGIFSOWN

The Change IFS Owner command allows a change of ownership of IFS objects. The list of IFS objects to operate on is created as part of the command. The objects for a specific owner or the ownership of all objects found may be changed. An option exists to check what changes would occur.

CPYUSRPRF3

The Copy User Profile 3 command assists in duplicating a user profile from one system to another. The DSPUSRPRF OUTFILE function must be used to capture the information from one or more profiles on the source system. The outfile must then be transferred to a target system. The CPYUSRPRF3 command may then be used to create a new profile based on the existing information.

CVTSVRAUTE

The Convert Server Authentication Entries command converts the Authentication Entries for one or all servers to an outfile. Each record contains the name of the server and a user. You must have *ALLOBJ and *SECADM special authorities to use CVTSVRAUTE.

DSPCMDAUT

The Display Command Authority command displays the required authorities and typical exceptions for popular system commands. Not all commands are supported. The display describes the authorities (such as *OBJOPR or *READ) that are required to operate on an object. Notes also appear if applicable.

DSPSRCMBR2

The Display Source Member 2 command provides a similar display to STRSEU SRCMBR(*SELECT), but only display or print options exist. The user cannot delete or edit a member. The display of the source may be done using either STRSEU (browse mode) or DSPPFM.

PMTCMD

The Prompt Command command is intended for situations where a command is entered into a field that will be checked by QCMDCHK. If the command to be entered should be prompted, QCMDCHK ensures that all required parameters are entered. PMTCMD allows you to enter just the command name. You may optionally enter some keywords and values and determine if a keyword value should be protected.

RTVOBJJRNA

The Retrieve Object Journal Attributes command retrieves information about an object that is being journaled. Only *FILE (physical files), *DTAARA, and *DTAQ objects may be specified. The information returned includes whether the object is journaled, the journal name, images value, etc.

RTVPGMSTK2

The RTVPGMSTK2 command allows you to extract one or more values from a program stack entry into a CL program. This provides such information as who the caller of your program is. You may 'walk thru' the stack by bumping the stack number each time you use RTVPGMSTK2. If the user has *JOBCTL special authority, the command may be used against any job.

SCNDBFLEN

The Scan Data Base File Record Length command scans one or more libraries for data base files that exceed a specified record length. The record length of a file is specified on the CRTPF command RCDLEN parameter for program described files or is the sum of the field lengths for an externally described file. An omit list of libraries may also be specified.

SCNDTAQLEN

The Scan Data Queue Maximum Length command scans one or more libraries for data queues that are defined with a maximum entry length that exceeds a specified value. The maximum entry length of a data queue is specified on the CRTDTAQ MAXLEN parameter. An omit list of libraries may also be specified.

SCNFLDTYP

The Scan Field Type command scans data base files in one or more libraries for one or more field types. For example, you can determine which files have field types for date (L), timestamp (Z), variable length (W), or BLOB (1).

SCNUPDHEX0

The Scan and Update Hex 00s command replaces X'00' values with blanks (X'40's) and returns them in the same variable. The command can be useful when dealing with system data which frequently uses X'00' in values. The variable must be declared as 5000 bytes.

WRKF2

The Work File 2 command provides a subfile with options to display the attributes, relations, format, and data of a file. These are the same options as on the DSPF2 command. In addition, there are options to change, edit, clear, and delete a file.

WRKMBRS

The Work Members command displays the members of a data base file and provides options to display or change the member level information and the data. The options are similar to the DSPMBRS command with the

WRKSVRAUTE

The Work Server Authentication Entries command provides a display of a user, generic user, all users, or all non-Q users for a named server. A *SELECT option exists to provide a display of the existing servers. When a list of users is displayed for a specific server, options exist to add, change, remove, or display authentication entries.

New tools as of Jul 15, 2002

None. This is the initial release.