How to cleanup MSM user ids that are no longer being used.

Document ID : KB000049068
Last Modified Date : 15/01/2019
Show Technical Document Details
Introduction:
Removing unwanted users from CA CSM.
Instructions:

Run the following DBSQLPR JCL to delete a user id from MSM where 'XXXXXXX' is the user id. The HLQ for CUSLIB, CAAXLOAD and CXX can be found in the MSMMUF startup PROC.

//STEP05A  EXEC PGM=DBSQLPR,
//       PARM='PRTWIDTH=1500,INPUTWIDTH=72'                  
//STEPLIB     DD DSN=.......CUSLIB,                             
//                    DISP=SHR                                          
//                    DD DSN=........CAAXLOAD,                          
//                    DISP=SHR                                          
//CXX              DD DSN=........CXX,                                   
//                    DISP=SHR                                          
//SYSUDUMP DD  SYSOUT=*                                      
//SYSPRINT   DD  SYSOUT=*                                      
//STDERR      DD  SYSOUT=*                                      
//STDOUT      DD  SYSOUT=*                                      
//OPTIONS    DD  *                                             
AUTHID=CASWMGT                                               
/*                                                           
//SYSIN         DD  *  
DELETE FROM CSISCHEDULEINFO  WHERE USERID='XXXXXXX';     
DELETE FROM SWSITELOGIN WHERE USERID='XXXXXXX';          
DELETE FROM  TASKJOURNAL WHERE USERID ='XXXXXXX';        
DELETE FROM USERINFO WHERE USERID='XXXXXXX';             
/*