Figure 124 shows the format of the DB2® Entries Report. This report is produced using a combination of the EXEC CICS® INQUIRE DB2ENTRY and EXEC CICS COLLECT STATISTICS DB2ENTRY commands. The statistics data is mapped by the DFHD2RDS DSECT. The field headings and contents are described in Table 248.
Applid IYK2Z2G1 Sysid JOHN Jobname CI13JTD5 Date 12/17/2004 Time 10:38:50 CICS 6.4.0 PAGE 3
DB2 Entries
DB2Entry Name. . . . . . . . . . . . . . : XP05 DB2Entry Status . . . . . . . . . . . . : ENABLED
DB2Entry Static Plan Name. . . . . . . . : TESTP05 DB2Entry Disabled Action. . . . . . . . : POOL
DB2Entry Dynamic Plan Exit Name. . . . . : DB2Entry Deadlock Resolution. . . . . . : ROLLBACK
DB2Entry Authtype. . . . . . . . . . . . : N/A DB2Entry Accounting records by. . . . . : NONE
DB2Entry Authid. . . . . . . . . . . . . : JTILLI1
Number of Calls using DB2Entry. . . . . . . : 16,500
DB2Entry Thread Wait Setting . . . . . . : WAIT Number of DB2Entry Signons. . . . . . . . . : 10
Number of DB2Entry Partial Signons. . . . . : 0
DB2Entry Thread Priority . . . . . . . . : N/A Number of DB2Entry Commits. . . . . . . . . : 0
DB2Entry Thread Limit. . . . . . . . . . : 10 Number of DB2Entry Aborts . . . . . . . . . : 0
Current number of DB2Entry Threads . . . : 0 Number of DB2Entry Single Phase . . . . . . : 5,500
Peak number of DB2Entry Threads. . . . . : 10 Number of DB2Entry Thread Reuses. . . . . . : 5,031
Number of DB2Entry Thread Terminates. . . . : 464
DB2Entry Protected Thread Limit. . . . . . . . . : 5 Number of DB2Entry Thread Waits/Overflows . : 306
Current number of DB2Entry Protected Threads . . : 5
Peak number of DB2Entry Protected Threads. . . . : 5
Current number of DB2Entry Tasks . . . . . . . . : 0
Peak number of DB2Entry Tasks. . . . . . . . . . : 28
Current Total number of DB2Entry Tasks . . . . . : 5,500
Current number of Tasks on DB2Entry Readyq . . . : 0
Peak number of Tasks on DB2Entry Readyq. . . . . : 18
------------------------------------------------------------------------------------------------------------------------------------
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 |
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 or not 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 had to 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 |