Bulk deletion of multiple users from the OM View DEF USER list

Products

• OM View

Issue/Introduction

How to perform a bulk deletion of multiple users from the OM View DEF USER list without manual entry.

Resolution

There is no single "one-click" utility for mass user deletion. However, the process can be automated using the **SARBCH** utility. Follow these steps to perform a mass deletion:

1. Prerequisites
   - **Backup:** Perform a full database backup before proceeding. This operation cannot be undone.
   - **Authorization:** The user executing the batch job must have **MASTER** authority in the CA View DEF USER screen and **ALTER** authority to the database high-level qualifier (HLQ) in your external security manager (e.g., RACF, ACF2, or Top Secret).
   
   
2. Generate Control Statements
   Create a flat file (sequential dataset) containing a `/DELETE USER=userid` statement for every ID to be removed.
   
   **Command Syntax:**
   /DELETE USER=userid
*Note: You can use the **SARGRW** utility or a standard text processor to generate these statements from a source list of UserIDs.*
   
   
3. Execute the Deletion via SARBCH
   Submit a batch job running the **SARBCH** utility, referencing the file created in Step 2 in the `SYSIN` DD statement. SARBCH will process each delete command sequentially.
   
   **Sample JCL:**
   //DELEUSER JOB ...
//*
//STEP1    EXEC PGM=SARBCH,PARM='VIEW.DB.PREFIX'
//STEPLIB  DD DISP=SHR,DSN=your.hlq.CVDELOAD
//SYSPRINT DD SYSOUT=*
//REPORT   DD SYSOUT=*
//SYSIN    DD DISP=SHR,DSN=your.dataset.with.delete.cards