After doing a RC/Query for Db2 for z/OS (RCQ) PK/L option to list all packages and issuing the LFREE line command on the first package,
the user would like a method to replicate the LFREE command on every package selected.
One easy solution is to use the RCQ "=" line command which works for a small number of packages selected.
Example:
RQPKL R15 -------- RC/Q Application Package List -------- COMMAND ===>
DB2 Object ===> PK Option ===> L Wh Package ===> * > Creator ===> USER001 Collection ===> * > Grantor ===> * Version ===> * > Loc: LOCAL ---------- SSID: ssid ----------USER002 - L CMD NAME CREATOR COLLECTION V O E lfree___ ACTIVE USER001 xxxxxx Y Y N =_______ ACTIVE USER001 xxxxxx Y Y N =_______ ACTIVE1 USER001 xxxxxx Y Y N =_______ ACTIVEA USER001 xxxxxx Y Y N
The required statements will be generated.
When the list is longer, the Plan Analyzer for Db2 for z/OS (PPA) product would be the preferred method.
From the Plan Analyzer main menu Select Option 13) Plan/Package Utilities.
Provide the Selection criteria for the plan/package list.
Once the list is displayed, issue the FREEPACK or FREEPLAN primary command.
The required statements will be generated.