Freeing inactive packages for Db2 REST service
Removing the unneeded inactive package copies for Db2 REST services is a good practice, which can help to provide storage relief.
About this task
Db2 native REST services are created by invoking the REST service manager API with a create Service request, or by using the DSN BIND SERVICE command. This action inserts a row that define this service in he REST services table and creates an application package.
The application package for a REST service can then be rebound using various options by using the DSN REBINDPACKAGE command. During rebind, inactive package copies, for example the original and previous copies, can be generated based on the PLANMGMT option. Phased-out copies of packages can be generated if already running threads have the package allocated when the rebind occurs. Invalid package copies can occur when a dependent object is changed or dropped. These types of inactive packages can build up over time when many rebinds are done.
Procedure
For example, the following command frees all original, previous, and phased-out package copies for a REST service, regardless of whether they are invalid. The REST service definition and active package are unaffected.
FREE PACKAGE("SYSIBMSERVICE"."simpleSelect1".(V1)) PLANMGMTSCOPE(INACTIVE)