Deleting all Generations of a GDG
Question: How delete multiple(all) versions of GDG just by providing base version. Any utility available or thru IDCAM...then how?
Dhananjay
Answer: You reference an entire GDG by not soecifying a version number on the end. To delete all of the generations of a GDG you just run an IEFBR14 step referencing the GDG base name and disp=old,delete. For example if your GDG is called PROD.MYGDG.FILE then you can use the following JCL.
//S1 EXEC PGM=IEFBR14
//F1 DD DSN=PROD.MYGDG.FILE,DISP=(OLD,DELETE)
//F1 DD DSN=PROD.MYGDG.FILE,DISP=(OLD,DELETE)
You only need to use IDCAMS if you want to delete the GDG base itself.
Related Articles
- Structured Programming
- Database Locking Levels
- Testing Which Function Key was Pressed
- DB2 Cursors
- Difference between RENAMES and REDEFINES
Copyright © Felgall Pty Ltd