Global command for all users to select all rows returned on a screen to populate the LFREE command for 2500 packages.

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

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.

Resolution

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.