How to run a TPX extract batch job, export the report to a data set for editing and run a separate batch job to import the edited dataset to use in deleting userids.

Products

• TPX - Session Management
• Vman Session Management for z/OS

Issue/Introduction

Introduction:

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. 

 

Environment:

TPX V5.4 

 

Instructions:

1. Both, the EXTFILE and RPTFILE would need to be sequential flat files and make the record length of the EXTFILE 2000 so that no information is lost. 

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 ')) 

 

2. Then run the delete after editing YOUR.EXTFILE.FLAT.FILE. 

BATCHADM EXEC TPXPROC,VNODE='*BATCH*' 
//EXTFILE DD DSN='YOUR.EXTFILE.FLAT.FILE',DISP=SHR 
//SYSIN DD * 
C 
DELETE USER USING(EXTFILE)

 

 

Environment

Release: NVINAM00200-5.3-TPX-Session Management-Access Management package
Component: