Option K. Packages

The Packages (ADB21K) panel displays the packages in the Db2 catalog.

To display the Packages (ADB21K) panel, select option K on the System Catalog (ADB21) panel.

Figure 1. Packages (ADB21K) panel
ADB21K in                      DC1Q Packages                Row 38 to 42 of 42 
Command ===>                                                  Scroll ===> CSR  
                                                                     More:    >
Commands:  BIND  REBIND  FREE  BINDOPT  VERSIONS  GRANT  ALL  PLANMGMT         
           DROP  DET  BET                                                      
Line commands:                                                                 
 DP - Depend  A - Auth  T - Tables  V - Views  X - Indexes                     
 S - Table spaces  Y - Synonyms  Q - Sequences  RB - Rebind  F - Free  B - Bind
 ? - Show all line commands                                                    
                                                         V I V O Quali-   R E D
S   Collection        Name     Owner    Bind Timestamp   D S A P fier     L X R
    *                 *        *        *                * * * * *        * * *
--- ----------------- -------- -------- ---------------> - - - - -------- - - -
?   FGRCOLID          ADB2RGC  TS5776   2018-06-19-21.14 B S Y Y SYSIBM   C N  
    FGRCOLID          ADB2RIP  TS5776   2018-06-19-21.14 B S Y Y SYSIBM   C N  
    FGRCOLID          ADB2SQL  TS5776   2018-06-19-21.14 B S Y Y SYSIBM   C N  
    FGRCOLID          ADB2WCL  TS5776   2018-06-19-21.14 B S Y Y SYSIBM   C N  
    FGRCOLID          ADB2ZP   TS5776   2018-06-19-21.14 B S Y Y SYSIBM   C N  
******************************* END OF DB2 DATA *******************************
Notes: Start of change
  1. Panel ADB21K can also have the title Packages Copy. This alternate title is used if the panel displays information about copies of the package. [To display information about package copies, specify the KC line command on the Packages (ADB21K) panel.]
  2. Panel ADB21K can also include the applicable plan name in the title (Packages for Plan plan_name). The plan name is included if this panel is displayed after specifying K on the Application Plans (ADB21P) panel or Package List (ADB21PL) panel.
End of change

Panel columns

This panel includes the following columns:

S
An input field where you can enter one of the line commands that are listed on the panel.
Collection
The name of the package collection.
Name
The name of the package.
Owner
The authorization ID of the package owner.
Version
The version of the package.

Alternatively, one of the following columns might be displayed instead of Version: (The value that is displayed is controlled by the VERSIONS command.)

Con Token
The consistency token for the package.
Bind Timestamp
The timestamp of when the package was last bound.

Depending on the value that was specified with the VERSIONS command, the version and consistency token might be displayed below the bind timestamp.

VD
An indication of whether validity checking can be deferred until run time. This field contains one of the following values:
B
All validity checking must be done during the bind.
R
Validity checking is done at run time for tables, views, and privileges that do not exist at bind time.
IS
The isolation level, which can be one of the following values:
R
Repeatable read.
S
Cursor stability.
T
Read stability.
U
Uncommitted read.
Blank
Not specified; therefore, the isolation level of the plan is used.
VA
An indication of whether the package is valid. A valid plan can be run without being rebound. This field contains one of the following values:
Y
Yes.
N
No.
A
An ALTER statement changed the description of the table or base table of a view, but the package is still valid.
H
An ALTER TABLE statement changed the description of the table or base table of a view. For releases of Db2 prior to Version 5, the change invalidates the package.
OP
An indication of whether the package can be allocated. This field contains one of the following values:
Y
Yes.
N
No. An explicit bind or rebind operation is required before the package can be allocated.
Qualifier
The qualifier that was specified at bind time to resolve names.
RL
The time at which resources for the package are released. This field contains one of the following values:
C
Commit time.
D
Deallocation time.
Blank
Not specified; therefore, the value that is specified for the plan is used.
EX
An indication of whether the package was bound using EXPLAIN. This field contains one of the following values:
Y
Yes.
N
No.
Only
EXPLAIN was run, EXPLAIN tables were populated, and the BIND process completed; however, the existing package was not affected.
DR
The DYNAMICRULES option that was used when the package was last bound. Possible values are any valid value for the DYNAMICRULES column of the Db2 SYSIBM.SYSPACKAGE catalog table, as described in SYSPACKAGE catalog table (Db2 12 for z/OS).

You can scroll to view additional columns. Those columns display information from the SYSIBM.SYSPACKAGE catalog table. For information about those column values, see SYSPACKAGE catalog table (Db2 12 for z/OS).

Panel primary commands

Tip: The primary commands operate only on rows that are listed on the panel. To omit some of the rows before you issue one of these commands, use the minus (-) line command to remove rows from the display.

The following primary commands are valid on this panel:

BIND
Issues a BIND command on multiple packages.
Restriction: You cannot BIND a trigger package by using the Packages (ADB21K) panel.
BINDOPT
Lets you choose bind and rebind options that are not in the Db2 catalog.
REBIND
Issues a REBIND command on multiple packages.

When you specify REBIND, the resulting BIND command contains only the package name. If you want the resulting BIND command to contain the package name and all of the parameters, specify REBIND FULL.

FREE
Issues a FREE command on multiple packages.
Notes for BIND, REBIND, and FREE:
  • When you attempt to bind, rebind, or free more than 20 packages, Db2 Admin Tool prompts you to specify either a work statement list or a batch job to complete the required processing.
  • If you activated prompting (see Changing Db2 Admin Tool prompt options), the Statement Execution Prompt (ADB2PSTM) panel is displayed. Select option 1A to execute all statements. The stacked output is displayed after the commands are processed.
VERSIONS
Displays the package version, bind timestamp, and consistency token in the fifth column. You can issue one of the following variations of the VERSIONS command:
VER ON
Displays the bind timestamp, with the version and consistency token listed below it.
VER SHORT
Displays only the package version.
VER OFF
Displays only the bind timestamp.
VER CON
Displays only the consistency token.
VER
Cycles between the VER SHORT, VER ON, VER CON, and VER OFF displays each time that you issue this command.
GRANT
Issues a GRANT command on multiple application packages.
ALL T
Displays all tables for the listed packages.
ALL X
Displays all tables for the listed packages.
PLANMGMT
Displays the plan management attributes for the package. When the PLANMGMT command is issued, the panel includes the QUALIFIER command.
QUALIFIER
Displays the qualifier for the package. You must first issue the PLANMGMT command to use the QUALIFIER command.
DROP
Drops the selected packages.
DET
Displays the detail package report for the selected packages.
BET
Generates a detail report in batch for the selected packages.
Start of change

Panel line commands

The following line commands are valid on this panel:

.
Selects multiple packages for the REBIND, BIND, FREE, ALL, GRANT, and DROP commands.
/
Displays all of the columns for the selected row.
A
Displays authorizations for the packages.
B
Binds the packages.
BC
Binds and copies the packages.
BET
Generates a detailed report in batch for the package.
D
Shows databases that are associated with the package.
DET
Generates a detailed report online for the package.
DP
Shows dependencies.
DRP
Drops the packages.
EN
Displays enabled and disabled connections for the packages.
F
Frees the packages.
GR
Grants package privileges.
I
Displays details about the packages.
Start of changeKCEnd of change
Start of changeDisplays previous or original copies of the package.End of change
LP
Start of changeLists PLAN_TABLE rows for the last BIND with EXPLAIN(YES).End of change
LPA
Start of changeLists all the PLAN_TABLE rows that are associated with the package.End of change
O
Displays stored procedures that are associated with the package.
P
Displays application plans that are associated with the package.
PL
Displays the package list items.
Q
Displays sequences that are associated with the package.
RB
Rebinds the packages.
RD
Regenerate a DBRM member.
RO
Shows the owner roles.
Start of changeRSEnd of change
Start of changeShows the REST services associated with the package.End of change
S
Shows that table spaces that are associated with the package.
SQ
Shows the SQL statements in the package.
T
Shows the tables that are associated with the package.
V
Shows the views that are associated with the package.
VE
Shows the version and consistency tokens.
X
Shows the indexes that are associated with the package.
Y
Shows the synonyms that are associated with the package.
End of change