Option K. Packages
The Packages (ADB21K) panel displays the packages in the Db2 catalog. To display this panel, select option K on the System Catalog (ADB21) 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: 
- 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.]
- 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.
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.
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.
- KC
- Displays previous or original copies of the package.
- LP
- Lists PLAN_TABLE rows for the last BIND with
EXPLAIN(YES).
- LPA
- Lists all the PLAN_TABLE rows that are associated with the
package.
- 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.
- RS
- Shows the REST services associated with the package.
- 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.