DB2 Entries report
The DB2® Entries Report is produced using a combination of the EXEC CICS INQUIRE DB2ENTRY and EXEC CICS EXTRACT STATISTICS DB2ENTRY commands. The statistics data is mapped by the DFHD2RDS DSECT.
| Field Heading | Description |
|---|---|
| DB2Entry Name | The name of the installed DB2ENTRY.
Source field: EXEC CICS INQUIRE DB2ENTRY |
| DB2Entry Static Plan Name | The name of the plan to be used for
this DB2ENTRY. Source field: D2R-PLAN-NAME |
| DB2Entry Dynamic Plan Exit Name | The name of the dynamic plan exit
used by this DB2ENTRY. Source field: D2R-PLANEXIT-NAME |
| Dynamic Plan Exit Concurrency Status | Whether the dynamic plan exit used
by this DB2ENTRY is defined as QUASIRENT, THREADSAFE, or REQUIRED.
Source field: EXEC CICS INQUIRE PROGRAM CONCURRENCY |
| DB2Entry Status | The current enabled status of this
DB2ENTRY. Source field: EXEC CICS INQUIRE DB2ENTRY ENABLESTATUS |
| DB2Entry Disabled Action | The action to be taken for new CICS® tasks
that attempt to use this DB2ENTRY when it is disabled or being disabled.
Source field: EXEC CICS INQUIRE DB2ENTRY DISABLEDACT |
| DB2Entry Deadlock Resolution | The action to be taken for a transaction
using a thread from this DB2ENTRY that has been selected by DB2 as
a victim of deadlock resolution. Source field: EXEC CICS INQUIRE DB2ENTRY DROLLBACK |
| DB2Entry Authtype | The type of id to be used for security
checking for threads of this DB2ENTRY. Source field: D2R-AUTHTYPE |
| DB2Entry Accounting records by | specifies the frequency of DB2 accounting
records to be produced for transactions using this DB2ENTRY. Source field: D2R-ACCOUNTREC |
| DB2Entry Authid | The id to be used for security checking
for threads of this DB2ENTRY. Source field: D2R-AUTHID |
| Number of Calls using DB2Entry | The number of SQL calls made using
a thread from this DB2ENTRY. Source field: D2R-CALLS |
| DB2Entry Thread Wait Setting | specifies whether transactions should
wait for a DB2ENTRY thread, be abended, or overflow to the pool should
the number of active threads reach the thread limit for this DB2ENTRY.
Source field: D2R-THREADWAIT |
| Number of DB2Entry Signons | The number of DB2 signons
performed for threads of this DB2ENTRY. Source field: D2R-SIGNONS |
| Number of DB2Entry Partial Signons | The number of DB2 partial
signons performed for threads of this DB2ENTRY. Source field: D2R-PARTIAL-SIGNONS |
| DB2Entry Thread Priority | The priority of the thread subtasks
for this DB2ENTRY 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". Source field: D2R-PRIORITY |
| Number of DB2Entry Commits | The number of two phase commits performed
for units of work using threads from this DB2ENTRY. Source field: D2R-COMMITS |
| DB2Entry Thread Limit | The maximum number of threads allowed
for this DB2ENTRY. Source field: D2R-THREAD-LIMIT |
| Number of DB2Entry Aborts | The number of units of work using
threads from this DB2ENTRY that were rolled back. Source field: D2R-ABORTS |
| Current number of DB2Entry Threads | The current number of active threads
using this DB2ENTRY. Source field: D2R-THREAD-CURRENT |
| Number of DB2Entry Single Phase | The number of units of work using
threads from this DB2ENTRY that used single-phase commit, either because
they were read-only UOWs, or because DB2 was
the only recoverable resource updated in the UOW. Source field: D2R-SINGLE-PHASE |
| Peak number of DB2Entry Threads | The peak number of active threads
for this DB2ENTRY. Source field: D2R-THREAD-HWM |
| Number of DB2Entry Thread Reuses | The number of times CICS transactions
using this DB2ENTRY were able to reuse an already created DB2 thread.
Source field: D2R-THREAD-REUSE |
| Number of DB2Entry Thread Terminates | The number of terminate thread requests
made for threads for this DB2ENTRY. Source field: D2R-THREAD-TERM |
| DB2Entry Protected Thread Limit | The maximum number of protected threads
allowed for this DB2ENTRY. Source field: D2R-PTHREAD-LIMIT |
| Number of DB2Entry Thread Waits/Overflows | The number of times all available
threads for this DB2ENTRY were busy and a transaction must wait for
a thread to become available or overflow to the pool and use a pool
thread. Source field: D2R-THREAD-WAIT-OR-OVERFL |
| Current number of DB2Entry Protected Threads | The current number of inactive threads
of this DB2ENTRY that are protected. Source field: D2R-PTHREAD-CURRENT |
| Peak number of DB2Entry Protected Threads | The peak number of inactive threads
of this DB2ENTRY that were protected. Source field: D2R-PTHREAD-HWM |
| Current number of DB2Entry Tasks | The current number of CICS tasks
using this DB2ENTRY. Source field: D2R-TASK-CURRENT |
| Peak number of DB2Entry Tasks | The peak number of CICS tasks
using this DB2ENTRY. Source field: D2R-TASK-HWM |
| Current Total number of DB2Entry Tasks | The current total number of tasks
that have used this DB2ENTRY. Source field: D2R-TASK-TOTAL + D2R-TASK-CURRENT |
| Current number of Tasks on DB2Entry Readyq | The current number of CICS tasks
waiting for a thread to become available for this DB2ENTRY. Source field: D2R-READYQ-CURRENT |
| Peak number of Tasks on DB2Entry Readyq | The peak number of CICS tasks
that waited for a thread to become available for this DB2ENTRY. Source field: D2R-READYQ-HWM |