search cancel

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

book

Article ID: 49068

calendar_today

Updated On:

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