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

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® Session Management for z/OS

Resolution

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)