DB2 Entries Report

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.

Figure 124. The DB2 Entries Report
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
 
------------------------------------------------------------------------------------------------------------------------------------
Table 248. 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

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

Related reference
Back to full list of DFH0STAT reports
The DFH0STAT reports
Interpreting these statistics
Interpreting CICS DB2 statistics
Full listing and DFHSTUP reports for these statistics
CICS DB2 statistics
[[ Contents Previous Page | Next Page Index ]]