CA CSM Products Tab / Edit Filter / Cannot Delete Obsolete Site IDs

Products

• Mainframe Software Manager (Chorus Software Manager)

Issue/Introduction

Cannot delete obsolete Site ID from filtered products. 

Circumvented by defining a new filter for legitimate Site ID. However, this is done on a user-by-user basis. Each user must define a unique filter. 

How to delete obsolete accounts from the global list of Site IDs?

Environment

Release: MSMNGR00200-6.0-Chorus Software Manager
Component:

Resolution

Run the following JCL to remove the obsolete site ids from CA CSM:
//STEP05A  EXEC PGM=DBSQLPR,                               
//       PARM='PRTWIDTH=1000,INPUTWIDTH=72,ROWLIMIT=4000'  
//STEPLIB  DD DSN=hlq.CUSLIB,                 
//         DISP=SHR                                        
//         DD DSN=hlq.CAAXLOAD,               
//         DISP=SHR                                        
//CXX      DD DSN=hlq.CXX,         
//         DISP=SHR                                        
//SYSUDUMP DD  SYSOUT=*                                    
//SYSPRINT DD  SYSOUT=*                                    
//STDERR   DD  SYSOUT=*                                    
//STDOUT   DD  SYSOUT=*                                    
//OPTIONS  DD  *                                           
AUTHID=CASWMGT                                             
/*                                                         
//SYSIN    DD  *                                           
DELETE FROM SITEID 
WHERE SITE = 'nnnn'; 
/* 
The hlq for CXX, CAAXLOAD and CUSLIB is in the msmmufs startup. 
After this is done you will need to recycle msmtc, no need to recycle msmdbsrv or msmmufs. 

nnnn is an obsolete site id. You can stack these in SYSIN. If these site ids are still
assigned in supportservices.ca.com an update complete product list will add them back . 
You can open a case with CA CSM support to have these site ids removed from 
the user accounted in supportservices.ca.com.