Bind Statistics
Use this panel to view information about bind activities, for example, the number of automatic binds, automatic bind failures, static binds, and static bind failures.
________________ ZBIND VTM O2 V550./I SN13 07/11/13 16:57:00 2
> Help PF1 Back PF3 Up PF7 Down PF8
> R.D
>
> H-HISTORICAL
===============================================================================
> BIND STATISTICS
BIND
+ Collection Interval: REALTIME Start: 07/11 15:30:17
+ Report Interval: 5 sec End: 07/11 16:57:00
+
+ TOTAL INTERVAL /SECOND /THREAD /COMMIT
+ QUANTITY QUANTITY ( 5) (36017) (36151)
+ -------- -------- ------- ------- -------
+ Automatic Bind Plan Attempts 1 0 .00 .00 .00
+ Automatic Bind Plan Successes 1 0 .00 .00 .00
+ Automatic Bind Pkg Attempts 0 0 .00 .00 .00
+ Automatic Bind Pkg Successes 0 0 .00 .00 .00
+
+ Static Bind Plan Attempts 2 0 .00 .00 .00
+ Static Bind Plan Successes 1 0 .00 .00 .00
+ Static Bind Pkg Attempts 78335 33538 6707.60 .93 .93
+ Static Bind Pkg Successes 70961 30538 6107.60 .85 .84
+
+ Rebind Plan Attempts 0 0 .00 .00 .00
+ Rebind Plan Successes 0 0 .00 .00 .00
+ Rebind Pkg Attempts 6 0 .00 .00 .00
+ Rebind Pkg Successes 6 0 .00 .00 .00
+
+ Free Plan Attempts 0 0 .00 .00 .00
+ Free Plan Successes 0 0 .00 .00 .00
+ Free Pkg Attempts 20556 12210 2442.00 .34 .34
+ Free Pkg Successes 20555 12210 2442.00 .34 .34
+
+ Plan Allocation Attempts 89407 36017 7203.40 1.00 1.00
+ Plan Allocation Successes 89406 36017 7203.40 1.00 1.00
+ Package Allocation Attempts 20405 229 45.80 .01 .01
+ Package Allocation Successes 20165 215 43.00 .01 .01
+ Auth Check Attempts 649630 175166 35033.2 4.86 4.85
+ Auth Check Successes 649618 175162 35032.4 4.86 4.85
+ Auth Check Using Cache 19542 85 17.00 .00 .00
+ Auth Check Public Authority 8066 85 17.00 .00 .00
+ Test Binds (No Plan ID) 0 0 .00 .00 .00
=============================================================================== Fields
- Collection Interval
- Shows the
REALTIMEto indicate that you are looking at the realtime version of this panel and not at the corresponding near-term history panel. The collection interval and the report interval are the same in this panel. - Start
- The start time of the report interval currently displayed.
- Report Interval
- The time in the last cycle (for example, between two presses of the Enter key).
- End
- The end time of the report interval currently displayed.
For each of the following fields, the
following statistics values are provided:
- TOTAL QUANTITY
- Total quantity, which reflects the amount of activities since Db2 was started.
- INTERVAL QUANTITY
- Interval quantity, which reflects the amount of activities during the last cycle.
- /SECOND
- Rate per second during the last cycle. The number under /SECOND (in parentheses) is the number of seconds in the interval.
- /THREAD
- Rate per thread during the last cycle. The number under /THREAD (in parentheses) is the number of Create Threads during the interval.
- /COMMIT
- Rate per Commit during the last cycle. 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 subcommands issued, including the Bind Plan Add and Bind Plan Replace subcommands.
- Static Bind Plan Successes
- Represents the Bind 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.