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:

CICS operations views > DB2, DBCTL and WebSphere MQ operations views > Entries

Table 1. Views in the supplied DB2 entries (DB2ENTRY) view set
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

Table 2. Actions available for DB2ENTRY views
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

Table 3. Fields in DB2ENTRY views
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.
  • UOW - The CICS DB2 attachment facility causes an accounting record to be produced by DB2 for each UOW, assuming that the thread is released at the end of the UOW.
  • TASK - The CICS DB2 attachment facility causes a minimum of one accounting record to be produced by DB2 for each CICS task.
  • TXID - The CICS DB2 attachment facility causes an accounting record to be produced by DB2 when the transid using the thread changes.
  • NONE - No accounting records are required for transactions using threads from 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.
  • GROUP - Eight character ID and the connected group name are used as the authorization ID
  • SIGN - The SIGNID parameter of DB2 connection is used as the authorization ID
  • TERM - The terminal identification is used as the authorization ID
  • TX - The transaction identification is used as the authorization ID
  • OPID - The user operator identification is used as the authorization ID
  • USERID - The eight character user ID associated with the CICS transaction is used as the authorization ID
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.
  • CSDAPI - The resource was last changed by a CEDA transaction, by the programmable interface to DFHEDAP or by an EXEC CICS CSD command.
  • CSDBATCH - The resource was last changed by a DFHCSDUP job.
  • DREPAPI - The resource was last changed by a CICSPlex SM BAS API command.
  • DREPBATCH - The resource was last changed by a CICSPlex SM utility.
  • CREATESPI - The resource was last changed by an EXEC CICS CREATE command.
  • NOTAPPLIC - This is not applicable for this resource.
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.
  • POOL - The CICS DB2 attachment facility routes the request to the pool. Message DFHDB2072 is sent to the transient data destination specified by MSGQUEUEn on the DB2CONN for each transaction routed to the pool.
  • ABEND - The CICS DB2 attachment facility abends the transaction.The abend code is AD26.
  • SQLCODE - An SQLCODE is returned to the application indicating that the DB2ENTRY is disabled.
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.
  • ROLLBACK - The attachment facility will issue a syncpoint rollback before returning control to the application. An SQL code of -911 will be returned to the application indicating the current UOW has been rolled back.
  • NOROLLBACK - The attachment facility will NOT initiate a rollback for a transaction. An SQL code of -913 will be returned to the application indicating an unsuccessful execution caused by deadlock or timeout.
Enabled status ENABLESTATUS This indicates whether the DB2 entry can be accessed by application programs.
  • ENABLED - The DB2 entry can be accessed by applications. DB2 entry is installed in an enabled state.
  • DISABLED - The DB2 entry cannot be accessed by applications.
  • DISABLING - The DB2 entry is in the process of being disabled. New transactions cannot access the entry. However, existing transactions using the entry will be allowed to complete unless the DB2 entry is being disabled using the FORCE option.
Installation agent INSTALLAGENT The install agent identifier that made the installation.
  • CSDAPI - The resource was installed by a CEDA transaction, by the programmable interface to DFHEDAP or by an EXEC CICS CSD command.
  • CREATESPI - The resource was installed by an EXEC CICS CREATE command.
  • GRPLIST - The resource was installed by GRPLIST INSTALL.
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.
  • HIGH - The TCB will attain a higher priority than the CICS (QR TCB) task.
  • EQUAL - The TCB will have an equal priority to the CICS (QR TCB) task.
  • LOW - The TCB will have a lower priority to the CICS (QR TCB) 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.
  • TWAIT - If all threads are busy, a transaction will wait until one becomes available.
  • NOTWAIT - If all threads are busy, a transaction will be terminated with abend code AD2P.
  • TPOOL - If all threads are busy a transaction will be diverted to use a pool thread. If the pool is also busy and NOTWAIT has been specified for the threadwait parameter on DB2 connection, the transaction is terminated with abend code AD3T.
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.


eyua3sc.html | Timestamp icon Last updated: Sunday, 4 June 2017