Bind Statistics attributes

Use these attributes to view information about bind statistics.

Autobind Phasein Attempts Number of autobind phase-in attempts.

Autobind Phasein Queued Number of autobind phase-in attempts that were queued.

Autobind Phasein Succeeds Number of autobind phase-in attempts that succeeded.

Closed Infreq Access Number of infrequently accessed data sets that were physically closed (Field name: QTPCGBP).

Closed Utility Access Number of utility-access-only data sets that were physically closed (Field name: QTPCUT).

Curr Not Inuse Data Sets Number of data sets that are not currently used but are not closed because of deferred close. QTDSOPN - QTSLWDD = number of "In Use" data sets. (Field name: QTSLWDD).

Curr Open Data Sets Number of data sets that are currently open (Field name: QTDSOPN).

Data Set Closes (DSMAX) The number of data sets that were closed because the total number of open data sets reached the deferred close threshold value. The deferred close value is based on the value of DSMAX or the MVS DD limit (whichever is smaller). (Field name: QTDSDRN).

Data Sharing Group The Data Sharing Group Name (Field name: GROUP).

DB2 Subsystem The Db2 subsystem ID (Field name: DB2ID).

DB2 Version The DB2 Version (Field name: DB2VER).

DSG Member Name The Data Sharing Group Member Name (Field name: MEMBER).

HWM Not Inuse Data Sets Maximum number of page sets on the deferred close queue. This count represents the maximum number of data sets that are not in use and are not physically closed. (Field name: QTMAXPB).

HWM Open Data Sets Maximum number of data sets concurrently open since the time Db2 was last started. This represents the high water mark. This value can be greater than QWP4DSMX in IFCID 106, which results in Db2 abends caused by a storage shortage. If storage shortage occurs frequently, increase the value specified for DSMAX in macro DSN6SPRM. For more information about DSMAX, see the "Performance, Monitoring, and Tuning" section of Administration Guide. (Field name: QTMAXDS).

Interval Start The start time of this interval (Field name: TIMESTAMP).

MVS System ID The MVS identifier (Field name: MVSID).

Originating System The managed system name of the agent. Valid format is alphanumeric, with a maximum of 32 characters; example, DB91:SYS1:DB2. (Field name: ORIGINNODE).

Pkg Add Commands Number of bind add package subcommands issued. Both successful and unsuccessful commands are counted. The sum of QTBINDPA and QTBINDPR is the total number of bind package subcommands. (Field name: QTBINDPA).

Pkg Allocation Attempts Number of attempts to allocate a package (Field name: QTPKALLA).

Pkg Allocation Succeeds Number of packages successfully allocated. This field contains the number of allocation attempts (QTPKALLA) that were successful. Package allocation failure can be caused by an unavailable or nonexistent package. A high count of the number of packages unsuccessfully allocated (QTPKALLA - QTPKALL) typically occurs when the following conditions are true: A package list with multiple collections is used and frequently-used packages are at the end of a package list, rather than at the beginning. For example, when Db2 finds a package in the tenth collection, QTPKALLA is incremented by 10, once for each collection searched, but QTPKALL is incremented by 1. A high number of packages unsuccessfully allocated might be accompanied by a high value of QTPACNOT (the count of the number of unsuccessful checks for package execution authority made using the package authorization cache because an application entry was not found in the cache). When the value of QTPACNOT is high, the number of getpage requests by buffer manager to catalog or directory table spaces is also high. To reduce the number of buffer manager getpage requests to catalog or directory table spaces, put frequently-used packages at the beginning of package lists. (Field name: QTPKALL).

Pkg AuthChk Cache Number of successful checks for package execute authority made using the package authorization cache. This number includes public authorization checks. (Field name: QTPACAUT).

Pkg AuthChk Not Found Number of unsuccessful checks for package execute authority made using the package authorization cache because an applicable entry was not found in the cache (Field name: QTPACNOT).

Pkg AuthChk Public Number of successful checks for package execute authority held by public (Field name: QTPACPUB).

Pkg Authid Overwrites Number of times Db2 overwrote an authorization ID in the cache (Field name: QTPACOW1).

Pkg Autobind Attempts Number of automatic bind attempts. For reasons why an automatic bind occurs, see section 4 of Application Programming and SQL Guide. (Field name: QTAUTOBA).

Pkg Autobind Succeeds Number of successful automatic bind packages. This field is the number of automatic bind attempts that were successful. (Field name: QTPKABND).

Pkg Binds Number of packages successfully bound and kept for future package allocations. This field is the sum of successful bind add package and bind replace package subcommands; it does not equal QTBINDPA + QTBINDPR unless all bind add package and bind replace package subcommands are successful. (Field name: QTPKGBD).

Pkg Entry Overwrites Number of times Db2 overwrote an entry for a package or collection in the cache (Field name: QTPACOW2).

Pkg Frees Number of free package subcommands issued. You can try to free more than one package in a single subcommand. If this field is 1, QTFREEAP shows the number of packages you are trying to free. (Field name: QTFREEP).

Pkg Free Attempts Number of attempts to free a package. This number can be larger than QTFREEP because you can free multiple packages in a single command. (Field name: QTFREEAP).

Pkg Free Succeeds Number of times a package was successfully freed. This field is the number of free package attempts (QTFREEAP) that were successful. This field cannot be larger than QTFREEAP. If all specified packages were freed successfully, this field is equal to QTFREEAP. (Field name: QTPKGFRD).

Pkg Rebinds Number of rebind package subcommands issued. You can try to rebind more than one package in a single subcommand. If this field is 1, QTRBNDPA shows the number of packages you are trying to rebind. (Field name: QTRBINDP).

Pkg Rebind Attempts Number of attempts to rebind a package. This number can be larger than QTRBINDP because you can rebind multiple packages in a single subcommand. (Field name: QTRBNDPA).

Pkg Rebind Succeeds Number of times a package was successfully rebound. This field is the number of rebind package attempts (QTRBNDPA) that were successful. This field cannot be larger than QTRBNDPA. If all specified packages were rebound successfully, this field is equal to QTRBNDPA. (Field name: QTPKGRBD).

Pkg Replace Commands Number of bind replace package subcommands issued. Both successful and unsuccssful commands are counted. The sum of QTBINDPA and QTBINDPR is the total number of bind package subcommands. (Field name: QTBINDPR).

Plan Add Commands Number of bind add subcommands issued. These commands can be either successful or unsuccessful. Both are counted. The sum of QTBINDA, QTBINDR, and QTTESTB equals the total number of bind subcommands. (Field name: QTBINDA).

Plan Allocation Attempts Plan Allocation Attempts. These are requests to allocate a bound plan for an agent. This field represents the number of times the attachment facility requested that Db2 create a thread for the user. This number does not include allocations for Db2 system agents. (Field name: QTALLOCA).

Plan Allocation Succeeds Number of successful bound plan allocations. This field represents the number of allocation attempts identified by QTALLOCA that completed successfully. Plan allocation failure can occur if the plan was unavailable or nonexistent. (Field name: QTALLOC).

Plan AuthChk Attempts Total number of authorization check attempts that were performed (Field name: QTAUCHK).

Plan AuthChk Not Found Number of checks for the plan execute privilege that were made using the plan authorization cache and were unsuccessful because an applicable entry was not found in the cache (Field name: QTAUCNOT).

Plan AuthChk Public Number of successful plan authorization checks for plan execute authority held by public (Field name: QTAUPUB).

Plan AuthChk Succeeds Total number of successful authorization checks that were performed (Field name: QTAUSUC).

Plan AuthChk w/o Catalog Number of successful plan authorization checks made by using a plan cache or public authorization check (Field name: QTAUCCH).

Plan Authid Overwrites Number of times that Db2 overwrote an authorization ID in the plan authorization ID in the plan authorization cache (Field name: QTAUCOW1).

Plan Autobind Attempts Number of times automatic bind was attempted. This occurs when the plan was invalidated by modifications to the declarations of the data referenced by the programs bound as part of the plan. For example, dropping an index when it is used in the plan results in automatic bind. For information about automatic bind, see "Automatic Rebinding" in Application Programming and SQL Guide. (Field name: QTABINDA).

Plan Autobind Invalid ID Automatic bind with invalid resource IDs. This field represents the sum of all plan and package allocation attempts that failed because a resource was unavailable or the object did not exist (Field name: QTINVRID).

Plan Autobind Succeeds Number of successful automatic binds. This represents the number of automatic bind attempts (QTABINDA) that completed successfully (Field name: QTABIND).

Plan Bind No Plan ID Number of bind subcommands issued without a plan ID. The sum of QTBINDA, QTBINDR, and QTTESTB equals the total number of bind subcommands. (Field name: QTTESTB).

Plan Binds Number of plans successfully bound and kept for future agent allocations. This field represents the sum of successful bind add (QTBINDA) and successful bind replace (QTBINDR). This counter does not increment for bind subcommands that do not specify a plan ID, as identified by QTTESTB. QTBINDA + QTBINDR is not necessarily equal to this field. It is equal only if all bind-all and bind-replace commands are successful. (Field name: QTPLNBD).

Plan Frees Number of free subcommands issued. You can try to free more than one plan in a single free subcommand. If this field is 1, then the number of plans you are trying to free is shown in QTFREEA. (Field name: QTFREE).

Plan Free Attempts Number of attempts to free a plan. This number can be larger than QTFREE because multiple plan IDs can be specified on a single free subcommand. (Field name: QTFREEA).

Plan Free Succeeds Number of plans freed. This field represents the number of attempts (QTFREEA) that complete successfully. This value in this field cannot be greater than QTFREEA. It can be equal if all specified plans were freed successfully. Freeing a plan can fail if someone else is using the plan and holds a lock on it. (Field name: QTPLNFRD).

Plan Rebinds Number of rebind subcommands issued. You can try to rebind more than one plan in a single rebind subcommand. If this field is 1, then the number of plans you are trying to rebind is shown in field QTRBINDA. (Field name: QTREBIND).

Plan Rebind Attempts Number of attempts to rebind a plan. This number can be larger than QTREBIND because multiple plan IDs can be specified on a single rebind subcommand. (Field name: QTRBINDA).

Plan Rebind Succeeds Number of times a plan was successfully rebound. This represents the number of rebind attempts (QTRBINDA) that complete successfully. This field cannot be greater than QTRBINDA. It can be equal if all speified plans rebound successfully. (Field name: QTPLNRBD).

Plan Replace Commands Number of bind replace subcommands issued. These commands can be either successful or unsuccessful. Both are counted. The sum of QTBINDA, QTBINDR, and QTTESTB equals the total number of bind subcommands. (Field name: QTBINDR).

Rtn AuthChk Cache Number of successful authorization checks for user-defined functions or stored procedures that use the routine authorization cache. This number includes the number of public authorization checks (QTRACPUB). (Field name: QTRACAUT).

Rtn AuthChk Public Number of successful authorization checks for user-defined function or stored procedure execution authority when that authority is held by public (Field name: QTRACPUB).

Rtn Authid Overwrites Number of times that Db2 wrote over an authorization ID in the routine authorization cache (Field name: QTRACOW1).

Rtn Cache Not Added Number of times that Db2 could not add an entry to the routine authorization cache (Field name: QTRACNAC).

Rtn Entry Overwrites Number of times that Db2 wrote over a routine entry in the routine authorization cache (Field name: QTRACOW2).

RW to RO Data Sets Number of infrequently updated data sets that are converted from R/W to R/O state. An updated data set is considered to be infrequently updated when it has not been updated for the number of consecutive Db2 checkpoints that is specified by system parameter PCLOSEN, or the number of minutes that is specified by system parameter PCLOSET. The default for PCLOSEN is 5 checkpoints, and the default for PCLOSET is 10 minutes. For table space data sets, switching from the R/W to R/O state means that the SYSLGRNX or SYSLGRNG entry is closed. (Field name: QTPCCT).