Delete a model, its generation and SQL libraries

Products

• CA 2E

Issue/Introduction

How I can delete a model, its generation and SQL libraries?

 

Environment

Ca 2E 8.7 and higher

Resolution

1. Find the SQL library for this model - DSPDTAARA DTAARA(mdl-lib/YSQLLIBRFA)
2. Check for any *JRNs - WRKOBJPDM LIB(sql-lib) OBJTYPE(*JRN)  
3. Delete the *JRNs
4. If a *JRN cannot be deleted and you receive error: CPF7021 Cannot delete journal in sql-lib, then perform steps 5 to 7; otherwise go to step 8
5. End journalling for any access paths - ENDJRNAP FILE(*ALL) JRN(sql-lib/journal) 
6. End journalling for any physical files - ENDJRNPF FILE(*ALL) JRN(sql-lib/journal) 
7. Delete the *JRNs
8. Check for any *JRNRCVs - WRKOBJPDM LIB(sql-lib) OBJTYPE(*JRNRCV)
9. Delete the *JRNRCVs
10. If you receive error: CPA7025 Receiver jrnrcv in sql-lib never fully saved - it is safe to reply I for Ignore
11. Delete the SQL library - DLTLIB LIB(sql-lib)
12. Find the generation library for this model - DSPDTAARA DTAARA(mdl-lib/YGENLIBRFA)
13. Check for any *JRNs - WRKOBJPDM LIB(gen-lib) OBJTYPE(*JRN)  
14. Delete the *JRNs
15. If a *JRN cannot be deleted and you receive error: CPF7021 Cannot delete journal in gen-lib, then perform steps 16 to 18; otherwise go to step 19
16. End journalling for any access paths - ENDJRNAP FILE(*ALL) JRN(gen-lib/journal) 
17. End journalling for any physical files - ENDJRNPF FILE(*ALL) JRN(gen-lib/journal) 
18. Delete the *JRNs
19. Check for any *JRNRCVs - WRKOBJPDM LIB(gen-lib) OBJTYPE(*JRNRCV)
20. Delete the *JRNRCVs
21. If you receive error: CPA7025 Receiver jrnrcv in gen-lib never fully saved - it is safe to reply I for Ignore
22. Delete the generation library - DLTLIB LIB(gen-lib)
23. Delete the model library - DLTLIB LIB(mdl-lib)
24. Check for any related library lists - YWRKLIBLST, use F17 for Referenced library mdll-lib
25. Delete the library list(s)