Problem:
doing some clean up, been through several versions of APS, wishes to find the names of old db2 plans so he can clean them up
Resolution:
The DB2 plan names will have a 4 digit prefix on each name. The plan prefix is defined by the customer we would not know what they are. However, we should be able to look at the last 3-4 characters of the plan name and identify them. To start with, lets check the values of your current plan names. If you go to any APS screen and do TSO VCHG A1DPPLAN, this will show you the current plan prefix. Your DB2 plans for the APS product will all have those 4 characters at the start of the plan name. For example, if you take all defaults at installation of APS version 5.0 the plan names would all start with Q500. You can also check the DB2 subsystem ID by doing TSO VCHG SSMBSYSN.
#MFDS
#EnterpriseDeveloper
