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.

Table 1. Fields in the DB2 Entries report
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



dfht3_stats_db2_entry_0stat.html | Timestamp icon Last updated: Monday, 5 June 2017