How to DELETE all DB2 Application Resources

[WarrenDB2]

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

[Anuj Dhawan]

You can write your DROP statements in a JCLs, copy them and can execute them in different environments. If you are from Application Team, suggest you work with your DBA team.

For DROP this link explains a lot to get you started: https://www.ibm.com/support/knowledgece ... _drop.dita

However, have you involved IBM for this - there are some consideration, you should be taking care about while migrating. See here: http://www-07.ibm.com/events/nz/ibmforu ... df/b17.pdf

[WarrenDB2]

Thanks for your reply Anuj,

I am a consultant hired to both create the deletion plan of the decommissioning project and perform the actual deletion work. DB2 is just one of the resources that require deletion. The application has already be ported to a new platform, the Z/OS version that I am decommissioning is no longer used. I have access to a DBA but only occasionally.

I am definitely going to DROP the databases and am ready to do so but want to know what other commands (if any)  I need to execute (before or after the DROP command) in order to completely remove DB2 resources (for this application only).  I suspect there are other commands besides the Drop Database that I need to execute such as DROP Tablespace, Drop Plans, Drop Storage Groups etc.   I need help with the other commands and the order that I should execute the commands.

Thanks in advance,
Warren