Input field description for Process Packages function

The Process Packages function requires several input fields that define which package will be processed and how the SQL statements should be filtered. The fields below describe the required and optional values used to control package selection and reporting behavior.

Collection ID

Specifies the name of the collection that contains the packages to be processed. This field is required.

You may specify the complete Collection ID or use the wildcard characters % or *. For example, entering ANLX% selects all collections whose names begin with ANLX.
If the value exceeds the visible field width, use pF10 (scroll left) and pF11 (scroll right) to view or enter the full text.

To display prompt with a list of valid Collection IDs, place the cursor in the Collection ID field and press pF4. This helps you quickly select the appropriate value.

ANLPSELC -------------- List existing Collections ---------- Row 1 to 4 of 4
Line commands:                                                              
  S - Select Collection ID                                                   
S Collection  Package     Version       Bindtime            Contoken        
  ANL05693  > PKG05693  >               %                                   
- *********** *********** ************* ******************* ****************
_ ANL05693  > PKG05693  > VERYLONGVE  > 2025-12-15-05.20.48 1C3E167F1111B  >
_ ANL05693  > PKG05693  > VERSION2    > 2025-12-15-05.20.48 1C3E167F10A5D  >
_ ANL05693  > PKG05693  > VERSION1    > 2025-12-15-05.20.48 1C3E167F0EC9F  >
_ ANL05693  > PKG05693  > LONGVERSIO  > 2019-02-20-10.50.05 1AB6CB3100C25  >
****************************** Bottom of data ******************************

Package Name

Specifies the name of the package stored in the Db2 catalog. This field is required and identifies the package to be processed.

You may enter the full name or use % or * as wildcard characters.
If the name exceeds the field width, use PF10/PF11 to scroll.

Version ID

Specifies the version identifier of the package. This field is optional

You may enter a specific Version ID or use a numeric value representing the package generation to be processed (0 = current version, –1 = previous version, and so on).

To display a list of valid Version IDs, place the cursor in the field and press PF4

ANLPSELV ---------- Select necessary version ID -------- Row 1 to 3 of 3
          Collection:  ANL05693                                        
          Package   :  PKG05693                                        
Line commands: 
  S - Select version                                                     
S Bindtime            Contoken         Version ID                       
- ******************* **************** ******************************** 
_ 2025-12-15-05.20.48 1C3E167F10A5D0F1 VERSION2                       > 
_ 2025-12-15-05.20.48 1C3E167F0EC9F768 VERSION1                       > 
_ 2025-12-15-05.20.48 1C3E167F1111B632 VERYLONGVERSION064PH05693VER   >
**************************** Bottom of data ****************************

Generations

Defines the number of generations (versions) of plan table information to include in the reports on which reports should be produced. The default value is 1. Enter the number of generations you want the reports to cover.

Force

Forces EXPLAIN processing even if more than one package matches the criteria or if the package contains more than 300 SQL statements. This parameter is optional, and the default value is N

Specify Y to process all matching packages regardless of count or SQL volume.
Specify N to process them only when a single package matches or when the total SQL count is below 300.

To limit processing to SQL statements that reference a specific Db2 table, enter values in both the Table Owner and Table Name fields. If one field is entered, the other must also be provided. For values longer than the field width, use PF10/PF11 to scroll.

Table Owner: Specifies the creator (owner) of the table. This field is optional and defaults to blank.
Table Name: Specifies the name of the table. This field is optional and defaults to blank.

To limit processing to a range of query numbers, enter the query range:

Beginning QUERYNO: The first query number. The default value is 1.
Ending QUERYNO: The last query number. The default value is 999999999.

To specify the use of a remote location for gathering the package for running the EXPLAIN, enter the remote location:

Package location: DB2 location where the package information is stored. The default is the current server.
Explain location: DB2 location to be used to explain the package. The default is the current server.
Case Sensitive Version ID: Controls whether the Collection ID, Package Name, and Version ID fields are treated as case‑sensitive. This optional setting defaults to N (case‑insensitive). Specify Y to make these fields case‑sensitive; specify N to process them without case sensitivity.