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

Products

• Compress Data Compression for MVS
• Compress Data Compression for Fujitsu
• Datacom
• DATACOM - AD
• Mainframe Software Manager (Chorus Software Manager)
• MICS Resource Management
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

Removing unwanted users and their associated tasks 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';             
/*