Is there a global command for all users to select all rows returned on a screen to populate the LFREE command for 2500 packages?

book

Article ID: 49349

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Description:

After doing a 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.

Solution:

One easy solution is to use the "=" 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: D91A ----------USER002 - L CMD NAME CREATOR COLLECTION V O E lfree___ ACTIVE USER001 JELSP2 Y Y N =_______ ACTIVE USER001 JELSP3 Y Y N =_______ ACTIVE1 USER001 JELSP3 Y Y N =_______ ACTIVEA USER001 JELSP2 Y Y N

The required statements will be generated.

When the list is longer, the Plan Analyzer 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.

Environment

Release:
Component: RCQ