CICS Db2 resource statistics: Resource information
The resource information gives details of various attribute settings of each DB2ENTRY resource.
| DFHSTUP name | Field name | Description |
|---|---|---|
| DB2Entry Name | D2R_DB2ENTRY_NAME | The name of the installed DB2ENTRY Reset characteristic: not reset |
| Plan Name | D2R_PLAN_NAME | The name of the plan used for this DB2ENTRY. If a dynamic plan exit is used for
the DB2Entry, this DSECT field will be nulls (which are shown as N/A in the reports). Reset characteristic: not reset |
| PlanExit name | D2R_PLANEXIT_NAME | The name of the dynamic plan exit to be used for this DB2ENTRY. If a static plan
is used for the DB2ENTRY this DSECT field is nulls, which are shown as N/A in the reports.
Reset characteristic: not reset |
| Auth Id | D2R_AUTHID | The static ID to be used for Db2® security checking for this
DB2ENTRY. If an Authtype is used for the DB2ENTRY this DSECT field is nulls, which are shown as N/A
in the reports. Reset characteristic: not reset |
| Auth Type | D2R_AUTHTYPE | The type of ID to be used for Db2 security checking for this
DB2ENTRY. If an Authid is used for the DB2ENTRY this DSECT field contains nulls, which are shown as
N/A in the reports. Reset characteristic: not reset |
| Account Records | D2R_ACCOUNTREC | Specifies the frequency of Db2 accounting records to be
produced for transactions using this DB2ENTRY. Reset characteristic: not reset |
| Share Locks | D2R_SHARELOCKS | Specifies whether CICS® will pass an XID to Db2 to allow Db2 to share locks with any other
thread that passes the same XID. Reset characteristic: not reset |
| Thread Wait | D2R_THREADWAIT | Specifies whether transactions wait for a thread, stop or overflow to the pool,
if the number of active threads for this DB2ENTRY exceeds its thread limit. Reset characteristic: not reset |
| Thread Prty | D2R_PRIORITY | The priority of the DB2ENTRY thread subtasks relative to the CICS main task (QR TCB). If CICS is connected to Db2 Version 6 or later, this field contains zero,
representing not applicable, which is shown as N/A in the reports. Reset characteristic: not reset |
| Not in DFHSTUP report | D2R_DEFINE_SOURCE | The source of the resource definition. Its value depends on the change agent.
For more information, see Summary of the resource signature field values. Reset characteristic: not reset |
| Not in DFHSTUP report | D2R_CHANGE_TIME | The time stamp (STCK) in local time of CSD record change. Reset characteristic: not reset |
| Not in DFHSTUP report | D2R_CHANGE_USERID | The user ID that ran the change agent. Reset characteristic: not reset |
| Not in DFHSTUP report | D2R_CHANGE_AGENT | The agent that made the last change. Reset characteristic: not reset |
| Not in DFHSTUP report | D2R_INSTALL_AGENT | The agent that installed the resource. Reset characteristic: not reset |
| Not in DFHSTUP report | D2R_INSTALL_TIME | The time stamp (STCK) in local time when the resource was installed.
Reset characteristic: not reset |
| Not in DFHSTUP report | D2R_INSTALL_USERID | The user ID that installed the resource. Reset characteristic: not reset |
The resource statistics fields for the resource signature
The resource signature captures details about when the resource is defined, installed, and last changed. The resource statistics field names for the resource signature end in CHANGE_AGENT, CHANGE_TIME, CHANGE_USERID, DEFINE_SOURCE, INSTALL_AGENT, INSTALL_TIME, and INSTALL_USERID. For detailed information about the content of the resource signature fields, see Summary of the resource signature field values.