How to DELETE all DB2 Application Resources
Posted: Thu Apr 14, 2016 1:58 am
Hello All,
I am tasked with decommissioning an mainframe application which has DB2 component. At the end of the project, all application resources such as databases, datasets, RACF groups need to be deleted.
I need to delete all DB2 related objects (in all Dev, Educ, Test & Prod environments) such as but not limited to: Storage Groups, Packages, Plans, Table Spaces, Database/Tables/Views/Stored Procedures/Triggers/Indexes etc.
I have identified the application databases and have JCL ready with database drop commands but I need help with removing the other components not deleted with the drop database and also need help with determining the order of my drop/delete process.
For example, can I do the following, is this the right order and will this delete all DB2 resource belonging to the application in question?
1) Drop Database
2) Drop Table spaces
3) Drop Storage Groups
Finally, it would be best if I could do this work in batch mode so I could reuse the JCL or REXX etc. in each environment.
Thanks in Advance,
Warren
I am tasked with decommissioning an mainframe application which has DB2 component. At the end of the project, all application resources such as databases, datasets, RACF groups need to be deleted.
I need to delete all DB2 related objects (in all Dev, Educ, Test & Prod environments) such as but not limited to: Storage Groups, Packages, Plans, Table Spaces, Database/Tables/Views/Stored Procedures/Triggers/Indexes etc.
I have identified the application databases and have JCL ready with database drop commands but I need help with removing the other components not deleted with the drop database and also need help with determining the order of my drop/delete process.
For example, can I do the following, is this the right order and will this delete all DB2 resource belonging to the application in question?
1) Drop Database
2) Drop Table spaces
3) Drop Storage Groups
Finally, it would be best if I could do this work in batch mode so I could reuse the JCL or REXX etc. in each environment.
Thanks in Advance,
Warren