How to find out which users are defined for TPX and STX.

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

Description:

You can define/update/delete TPX users with Administrators in TPXADMIN. If you are also using STX, some users might also have been defined a STX structure. This document explains how you can get a list of all users being defined for TPX and STX.

Solution:

You can define/update/delete TPX users with Administrators in TPXADMIN. If you are also using STX, some users might also have been defined a STX structure. Now how can you find out all users having both, a TPX and a STX structure?

For that you use the two fields VUSR$TPX and XU$STX. They indicate whether the user is authorized to use TPX (field VUSR$TPX) or authorized to use STX (field XU$STX). With that in mind, the batch job looks like:


//EXTFILA  DD UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(MOD)                
//RPTFILA  DD SYSOUT=*                                               
//SYSIN    DD  *                                                     
EXTRACT GIVING(EXTFILA) USER AND NO SESSIONS (VUSR$TPX(Y) XU$STX(Y)) 
SET RTITLE1 '1USERID'                                                
SET RTITLE2 ' ------'                                                
REPORT GIVING(RPTFILA) USING(EXTFILA)                                
    ((' &UIDXNAME'))               

The result is a list of all users having both, TPX and STX definitions, looking like this:


USERID
------
ADMINA
NVIADMIN
XXUSER