How to run a TPX extract batch job, export the report to a dataset for editing and run a separate batch job to import the edited dataset to use in deleting userids.
TPX® Session Management for z/OS
Here is a batch example that will list all users:
//BATCHADM EXEC TPXPROC,VNODE='*BATCH*'
//EXTFILE DD DSN='YOUR.EXTFILE.FLAT.FILE',DISP=SHR
//RPTFILE DD DSN='YOUR.RPTFILE.FLAT.FILE',DISP=SHR
//SYSIN DD *
//EXTFILE DD UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(MOD)
//RPTFILE DD SYSOUT=*
//SYSIN DD *
C
C List all users and the date they last logged on.
C
C VUSRDACC The date on which the user last signed on to CA TPX.
C
EXTRACT GIVING(EXTFILE) USER AND NO SESSIONS (UIDXNAME(--------))
SET RTITLE1
' USERID LAST TPX LOGON'
SET RTITLE2
' ======== =============='
REPORT GIVING(RPTFILE) USING(EXTFILE)
(( ' &UIDXNAME' ' &VUSRDACC '))
BATCHADM EXEC TPXPROC,VNODE='*BATCH*'
//EXTFILE DD DSN='YOUR.EXTFILE.FLAT.FILE',DISP=SHR
//SYSIN DD *
C
DELETE USER USING(EXTFILE)