TPX batch - How to print all profiles assigned to a user

Document ID : KB000009359
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

All profiles assigned to a user are available in one variable created exclusively for batch reporting purposes, VUSR$PRF.

This document outlines several considerations for successfully displaying VUSR$PRF in a batch report.

The information in this document can also be applied to the other variable length reporting-only variables:

  • VUSR$MAG - A list of all the administration groups that the user is authorized to administer. The length of the value depends upon the number of groups in the list.

  • VUSR$PRF - A list of all the profiles assigned to the user. The length of the value depends upon the number of profiles assigned to the user.

  • VUSR$VAG - A list of all the administration groups that the user is authorized to view. The length of the value depends upon the number of groups in the list.
Background:

The Batch component of TPX allows you to report on and update information in the administration database.

Environment:
TPX for z/OS
Instructions:

All profiles assigned to a user are available in one variable created exclusively for batch reporting purposes, VUSR$PRF.

  • The length of VUSR$PRF is variable, depending upon the number of profiles assigned to the user.

  • There is no way to break up a single variable over multiple lines, so you must define a REPORT statement long enough to accommodate the entire length of the variable. This is achieved by using a SYSIN control file with an LRECL greater than 80 so that you can create a REPORT statement long enough to accommodate the entire length of the variable.

  • The maximum length of batch variables is 255 bytes. This means that VUSR$PRF will contain a maximum of 26 profiles.

  • In the event that a user has more profiles than this, you would need to create your own report outside of TPX that displays the values stored on the ADMIN2 VSAM file.

    • The list of profiles assigned are appended to the VINDEX record for a user in ADMIN2. You can assemble member VINDEX in CB0VMAC for the record layout.
    • It may be easier to work with a flat file backup of ADMIN2. (Create with IDCAMS REPRO.)
    • Possible tools are: CA-File Master, SAS, FileAid.
Additional Information:

The TPX 5.4 Batch Administration Guide contains several sections that are relevant to these conditions worth reviewing that relate to this: