Entries - DB2ENTRY
The DB2 entries (DB2ENTRY) views display information about entry threads used by the CICS DB2 attachment facility in active CICS systems being managed by CICSPlex SM.
Supplied views
To access from the main menu, click:
| View | Notes |
|---|---|
| DB2 entries EYUSTARTDB2ENTRY.DETAIL1 |
Detailed entry statistics information about selected DB2 entries. |
| DB2 entries EYUSTARTDB2ENTRY.DETAIL2 |
Detailed information about the resource signature. |
| DB2 entries EYUSTARTDB2ENTRY.DETAILED |
Detailed information about a selected DB2 entries. |
| DB2 entries EYUSTARTDB2ENTRY.DISABLE |
Display the Disable view, which lets you specify how to handle a DB2 entry if it is still in use. |
| DB2 entries EYUSTARTDB2ENTRY.DISCARD |
Discard a DB2 entry from the CICS system where it is installed. The DB2 entry must be disabled before the discard is allowed. |
| DB2 entries EYUSTARTDB2ENTRY.ENABLE |
Enable a DB2 entry on the CICS system where it is installed. |
| DB2 entries EYUSTARTDB2ENTRY.SET |
Set the attributes according to new values you specify in the overtype fields. |
| DB2 entries EYUSTARTDB2ENTRY.TABULAR |
Tabular information about DB2 entries. |
Actions
| Action | Description |
|---|---|
| DISABLE | Display the Disable view, which lets you specify how to handle a DB2 entry if it is still in use. |
| DISCARD | Discard a DB2 entry from the CICS system where it is installed. The DB2 entry must be disabled before the discard is allowed. |
| ENABLE | Enable a DB2 entry on the CICS system where it is installed. |
| SET | Set the attributes according to new values you specify in the overtype fields. |
Fields
| Field | Attribute name | Description |
|---|---|---|
| Number of aborts | ABORTS | This field indicates the number of units of work using this DB2 entry that were rolled back. |
| Accounting record option | ACCOUNTREC | This defines whether the CICS DB2 attachment will produce a DB2 accounting record per unit of work (UOW), transaction, transid
or not at all for transactions using this DB2 entry.
|
| Thread authorization ID | AUTHID | This defines the user identifier to be used for security checking for threads on this DB2 entry. If Thread authorization ID is specified, then Authorization type is not applicable |
| Authorization type | AUTHTYPE | This indicates the type of user identifier to be used for security checking for threads on this DB2 entry. If
Authorization type is specified then Thread authorization ID is set to blanks.
|
| BAS resource definition version | BASDEFINEVER | The BAS version number of this definition. |
| Number of calls | CALLS | This field indicates the number of SQL calls made using this DB2 entry. |
| Last modification agent | CHANGEAGENT | The change agent identifier that made the last modification.
|
| Last modification agent release | CHANGEAGREL | The CICS release level of the agent that made the last modification to the resource definition. |
| Last modification time | CHANGETIME | The local date and time when the definition was last changed. |
| Last modification user ID | CHANGEUSRID | The user ID that made the last modification to the resource definition. |
| Number of commits | COMMITS | This field indicates the number of two phase commits performed for units of work using this DB2 entry. |
| Source of the resource definition | DEFINESOURCE | The source of the definition, depending on which agent made the last change. |
| Creation time | DEFINETIME | The local date and time when the resource definition record was created on DFHCSD or EYUDREP. |
| Disabled action | DISABLEDACT | This defines what CICS is to do with new transactions accessing DB2 entry when it has been disabled or is
disabling. If this is not specified and DB2 entry is disabled, new requests are routed to the pool by default.
|
| Deadlock rollback option | DROLLBACK | This field indicates whether or not the CICS DB2 attachment will initiate a syncpoint rollback in the event of transaction
being selected as a victim of a deadlock resolution.
|
| Enabled status | ENABLESTATUS | This indicates whether the DB2 entry can be accessed by application programs.
|
| Installation agent | INSTALLAGENT | The install agent identifier that made the installation.
|
| Installation time | INSTALLTIME | The local date and time when the definition was installed. |
| Installation user ID | INSTALLUSRID | The user ID that installed the resource definition. |
| DB2 entry name | NAME | This is the name of the DB2 entry which defines the resources to be used by a specific transaction or by a group of transactions when accessing DB2. |
| Plan name | PLAN | This indicates the name of the plan to be used for this entry. If a plan name is specified then the Dynamic plan exit name field is set to blank. |
| Dynamic plan exit name | PLANEXITNAME | This indicates the name of the dynamic plan exit used for this entry. If a Dynamic plan exit name is specified then the Plan name field is set to blank. |
| TCB priority | PRIORITY | This field indicates the priority of the DB2 entry TCBs relative to the CICS main task.
|
| Maximum number of protected threads | PROTECTNUM | This field indicates the current maximum number of protected threads allowed for this DB2 entry. |
| Number of partial signons | PSIGNONS | This field indicates the number of DB2 partial signons performed for this DB2 entry. |
| Current number of protected threads | PTCURR | This field indicates the current number of protected threads for this DB2 entry. |
| Number of protected threads | PTHREADS | This field indicates the current number of protected threads. |
| Peak number of protected threads | PTHWM | This field indicates the peak number of protected threads for this DB2 entry. |
| Maximum number of protected threads | PTLIM | This field indicates the current maximum number of protected threads allowed for this DB2 entry. |
| Number of times a DB2ENTRY thread reached REUSELIMIT | REUSELIMCT | This field indicates the number of times a DB2ENTRY thread reached reuselimit and had to be terminated. |
| Current number of tasks waiting for thread | RQCUR | This field indicates the current number of CICS tasks waiting for a thread to become available on this DB2 entry. |
| Peak number of tasks waiting for thread | RQHWM | This field indicates the peak number of CICS tasks that waited for a thread to become available on this DB2 entry. |
| Number of signons | SIGNONS | This field indicates the number of DB2 signons performed for this DB2 entry. |
| Number of UOWs with single phase commit | SPHASE | This field indicates the number of units of work using the DB2 entry that used single phase commit, either because they were read-only UOWs, or because DB2 was the only recoverable resource updated in the UOW. |
| Number of times threads created | TCREATE | This field indicates the number of create thread requests made to DB2 for threads of this DB2 entry. |
| Current number of threads | TCURR | This field indicates the current number of active threads for this DB2 entry. |
| Maximum number of active threads | THREADLIMIT | This field indicates the current maximum number of pool threads the CICS DB2 attachment allows to be active before requests are made to wait, overflow to the pool, or are rejected. |
| Number of active threads | THREADS | This field indicates the current number of threads active for this DB2 entry. |
| Thread wait option | THREADWAIT | This field indicates whether or not transactions should wait for a pool thread or be abended if the number of
active pool threads reaches the threadlimit number.
|
| Peak number of active threads | THWM | This field indicates the peak number of active threads for this DB2 entry |
| Maximum number of threads | TLIMIT | This field indicates the current maximum number of threads allowed for the DB2 entry. |
| Number of times threads reused | TREUSE | This field indicates the number of times CICS transactions using the DB2 entry were able to reuse an already created DB2 thread. |
| Number of times threads terminated | TTERM | This field indicates the number of terminate thread requests made to DB2 for threads of this DB2 entry. |
| Number of thread waits or overflows | TWORO | This field indicates the number of times all available threads in the DB2 entry were busy and a transaction had to wait for a thread to become available, or overflow to the pool and use a pool thread instead. |
| Current number of tasks | XCURR | This field indicates the current number of CICS tasks that are using this DB2 entry. |
| Peak number of tasks | XHWM | This field indicates the peak number of CICS tasks that have used this DB2 entry. |
| Total number of tasks | XTOTAL | This field indicates the total number of completed tasks that have used this DB2 entry. |