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

book

Article ID: 49068

calendar_today

Updated On:

Products

CA Compress Data Compression for MVS CA Compress Data Compression for Fujitsu CA Datacom CA Datacom - AD CA Mainframe Software Manager (Chorus Software Manager) CA MICS Resource Management CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware CA Datacom/AD

Issue/Introduction

Removing unwanted users from CA CSM.

Environment

Release:
Component: MSM

Resolution

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';             
/*