VSAM DELETE using IDCAMS with Examples

VSAM cluster should be deleted using IDCAMS utility. VSAM DELETE command can be used to delete the VSAM or non-VSAM objects such as CLUSTER, GDG, Alternate Index, Alias, CATALOG, PS file, SPACE, USERCATALOG, etc. DELETE command removes the entry of the VSAM cluster from the catalog and optionally removes the file & freeing up the space. If the VSAM is not expired then it will not be deleted. To delete non-expired datasets use the PURGE option.

DELETE (entryname[/password][ entryname[/password] ...])
[object-type] 
    [ALIAS  |
    ALTERNATEINDEX  |
    CLUSTER  |
    GENERATIONDATAGROUP  |
    NONVSAM  |
    PAGESPACE  |
    PATH  |
    SPACE  |
    USERCATALOG]
[optional-paramter]
    [ERASE  |  NOERASE]
    [FILE(ddname)]
    [FORCE  |  NOFORCE]
    [PURGE  |  NOPURGE]
    [SCRATCH  |  NOSCRATCH]
    [CATALOG(catname[/password])] 

Entry-name – The dataset name which needs to be deleted and the dataset name which needs to exist. If a single entry needs to be deleted then no parentheses are required. You can delete multiple file entries with the single DELETE command

Object-type – It can be ALIAS, ALTERNATEINDEX, CLUSTER, GENERATIONDATAGROUP, LIBRARYENTRY, NONVSAM, NVR, PAGESPACE, PATH, TRUENAME, USERCATALOG, VOLUMERNTRY or VVR.

Optional Parameters –

VSAM DELETE to delete KSDS file

//VSAMDELT JOB (1234),'INDUS',CLASS=A,MSGCLASS=A,MSGLEVEL=(1,1),
//             NOTIFY=&SYSUID,REGION=6M                         
//*************************************************************
//* SAMPLE JCL DELETE VSAM DATASET
//*************************************************************
//STEP01  EXEC PGM=IDCAMS
//SYSPRINT  DD SYSOUT=*
//INPUT    DD   DSNAME=userid.KSDS.INPUT,DISP=SHR
//SYSIN    DD   *
   DELETE FILE (INPUT)   -
   PURGE
/*

VSAM DELETE to delete ESDS file

//VSAMDELT JOB (1234),'INDUS',CLASS=A,MSGCLASS=A,MSGLEVEL=(1,1),
//             NOTIFY=&SYSUID,REGION=6M                         
//*************************************************************
//* SAMPLE JCL DELETE ESDS DATASET
//*************************************************************
//STEP01   EXEC PGM=IDCAMS                             
//SYSPRINT DD SYSOUT=*                                 
//SYSIN    DD *                                        
     DELETE XXXXXX.YYYYYY.VSAMFILE.MSTR           
/*  

The above code snippet will delete cluster ‘XXXXXX.YYYYYY.VSAMFILE.MSTR’ and associated data component ‘XXXXXX.YYYYYY.VSAMFILE.MSTR.DATA’ (even if we have not specified it explicitly). Similarly, using the same code structure, you can delete ESDS, RRDS datasets

Note: When you delete this CLUSTER all associated data components and index components will be deleted automatically.

VSAM Tutorials

• VSAM DEFINE CLUSTER using IDCAMS with Examples
• VSAM Alternate Index using IDCAMS with Examples
• VSAM REPRO using IDCAMS with Examples
• VSAM PRINT using IDCAMS with Examples
• VSAM VERIFY EXAMINE using IDCAMS with Examples
• VSAM DELETE using IDCAMS with Examples
• VSAM EXPORT-IMPORT using IDCAMS with Examples

VSAM Define Cluster: Click Here IBM Reference : Click Here