Bind Statistics Detail
This panel shows detailed information about bind activity during a selected report interval.
________________ ZHBND VTM O2 V540./I SN13 07/11/13 17:11:02 2
> Help PF1 Back PF3 Up PF7 Down PF8
>
> Enter a selection letter on the top line.
>
> A-SUBSYSTEM SUPPORT *-BIND C-BUFFER POOL D-GROUP BP
> E-DISTRIBUTED DATABASE F-EDM POOL G-LOG MANAGER H-OPEN/CLOSE
> I-SQL/RID/PARALLEL/PROC J-LOCK/CLAIM/DRAIN K-GLOBAL LOCK L-DB2 COMMANDS
> M-THREAD HISTORY
===============================================================================
> BIND STATISTICS DETAIL
HBND
+ Collection Interval: 2 min Start: 07/11 17:04
+ Report Interval: 2 min Combine Level: NONE End: 07/11 17:06
+
+ INTERVAL /MINUTE /THREAD /COMMIT
+ QUANTITY ( 2) ( 1) ( 0)
+ -------- ------- ------- -------
+ Automatic Bind Plan Attempts 0 .00 .00 .00
+ Automatic Bind Plan Successes 0 .00 .00 .00
+ Automatic Bind Pkg Attempts 0 .00 .00 .00
+ Automatic Bind Pkg Successes 0 .00 .00 .00
+
+ Static Bind Plan Attempts 0 .00 .00 .00
+ Static Bind Plan Successes 0 .00 .00 .00
+ Static Bind Pkg Attempts 0 .00 .00 .00
+ Static Bind Pkg Successes 0 .00 .00 .00
+
+ Rebind Plan Attempts 0 .00 .00 .00
+ Rebind Plan Successes 0 .00 .00 .00
+ Rebind Pkg Attempts 0 .00 .00 .00
+ Rebind Pkg Successes 0 .00 .00 .00
+
+ Free Plan Attempts 0 .00 .00 .00
+ Free Plan Successes 0 .00 .00 .00
+ Free Pkg Attempts 0 .00 .00 .00
+ Free Pkg Successes 0 .00 .00 .00
+
+ Plan Allocation Attempts 1 .50 1.00 .00
+ Plan Allocation Successes 1 .50 1.00 .00
+ Package Allocation Attempts 0 .00 .00 .00
+ Package Allocation Successes 0 .00 .00 .00
+ Auth Check Attempts 2 1.00 2.00 .00
+ Auth Check Successes 2 1.00 2.00 .00
+ Auth Check Using Cache 1 .50 1.00 .00
+ Auth Check Public Authority 1 .50 1.00 .00
+ Test Binds (No Plan ID) 0 .00 .00 .00
=============================================================================== Navigation
For additional information about
- related topics, select one of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- Collection Interval
- The time interval specified for the collection of near-term history data. This unit of time was specified when the Near-Term History Data Collector was started.
- Start
- The start time of the interval currently displayed.
- Report Interval
- This field determines the report interval. It is set on the Near-Term History Report Option panel.
- Combine Level
- This field reflects the selected combine level.
If Combine Level is NONE, the report interval is the same as the collection
interval. Possible values:
- HOURLY
- Data will be reported in hourly intervals.
- NONE
- Data will be reported in the time unit specified by the collection interval.
- End
- The end time of the interval currently displayed.
For each of the following fields, the
following statistics are provided:
- INTERVAL QUANTITY
- The amount of activities that occur during the interval.
- /MINUTE
- Rate per minute. The number under /MINUTE (in parentheses) is the number of minutes in the interval.
- /THREAD
- Rate per thread. The number under /THREAD (in parentheses) is the number of Create Threads during the interval.
- /COMMIT
- Rate per Commit. The number under /COMMIT (in parentheses) is the number of Commit requests (including abort requests) during the interval.
- Automatic Bind Plan Attempts
- The attempts of Db2 to perform an automatic bind of a plan.
- Automatic Bind Plan Successes
- The successful attempts of DB2 to perform an automatic bind of a plan.
- Automatic Bind Pkg Attempts
- The attempts of Db2 to perform an automatic bind of a package.
- Automatic Bind Pkg Successes
- The successful attempts of DB2 to perform an automatic bind of a package.
- Static Bind Plan Attempts
- Represents the bind plan subcommands issued, including the Bind Plan Add and Bind Plan Replace subcommands.
- Static Bind Plan Successes
- Represents the bind plan subcommands that succeeded.
- Static Bind Pkg Attempts
- Represents the bind package subcommands issued, including the Bind Package Add and Bind Package Replace subcommands.
- Static Bind Pkg Successes
- Represents the bind package subcommands that succeeded.
- Rebind Plan Attempts
- Attempts to rebind a plan.
- Rebind Plan Successes
- Successful attempts to rebind a plan.
- Rebind Pkg Attempts
- Attempts to rebind a package.
- Rebind Pkg Successes
- Successful attempts to rebind a package.
- Free Plan Attempts
- Attempts to free a plan.
- Free Plan Successes
- Successful attempts to free a plan.
- Free Pkg Attempts
- Attempts to free a package.
- Free Pkg Successes
- Successful attempts to free a package.
- Plan Allocation Attempts
- The requests from the attachment facility to DB2 to allocate a bound plan for a user.
- Plan Allocation Successes
- Successful plan allocation attempts.
- Package Allocation Attempts
- The requests from the attachment facility to DB2 to allocate a bound package for a user.
- Package Allocation Successes
- Successful package allocation attempts.
- Auth Check Attempts
- Authorization checks for all plans.
- Auth Check Successes
- Successful authorization checks.
- Auth Check Using Cache
- Successful authorization checks that were performed using cache.
- Auth Check Public Authority
- Successful authorization checks that were performed based upon execute authority granted to public.
- Test binds (No Plan ID)
- Bind subcommands that were issued without a plan ID.