DB2 entry definitions - DB2EDEF

The DB2 entry definition (DB2EDEF) views display information about the attributes of entry thread definitions used by the CICS DB2 attachment facility.

Supplied views

To access from the main menu, click:

Administration views > CICS resource definitions > DB2 entry definitions

Table 1. Views in the supplied DB2 entry definitions (DB2EDEF) view set
View Notes
DB2 entry definitions

EYUSTARTDB2EDEF.ADDTOGRP

 Add one or more entry definitions to a resource group.
DB2 entry definitions

EYUSTARTDB2EDEF.CREATE

 Create an entry definition and add it to the data repository.
DB2 entry definitions

EYUSTARTDB2EDEF.DETAILED

 Detailed information about a selected entry definition.
DB2 entry definitions

EYUSTARTDB2EDEF.INSTALL

 Install an entry definition in an active system.
DB2 entry definitions

EYUSTARTDB2EDEF.REMOVE

 Remove an entry definition from the data repository.
DB2 entry definitions

EYUSTARTDB2EDEF.TABULAR

 Tabular information about all DB2 entry definitions for the current context.

Actions

Table 2. Actions available for DB2EDEF views
Action Description
ADDTOGRP Add one or more entry definitions to a resource group.
CREATE Create an entry definition and add it to the data repository.
CSDCOPY Copy a CICS CSD resource definition.
CSDINSTALL Install a CICS CSD resource definition into an active system.
INSTALL Install an entry definition in an active system.
REMOVE Remove an entry definition from the data repository.
UPDATE Update an entry definition in the data repository.

Fields

Table 3. Fields in DB2EDEF views
Field Attribute name Description
Accounting record option ACCOUNTREC This defines whether the CICS DB2 attachment will produce a DB2 accounting record per unit of work (UOW), transid, transaction or not at all for transactions using pool threads.
  • NONE - No accounting records to be cut.
  • TXID - The CICS attachment facility will cut an accounting record only when the transid using the thread changes.
  • TASK - The CICS attachment facility will cut a minimum of one accounting record per task.
  • UOW - The CICS attachment facility will cut an accounting record per UOW provided the thread has been released at syncpoint.
Thread authorization ID AUTHID The user identifier to be used for security checking when using pool threads. 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 when using pool threads. 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 Thread authorization ID.
  • SIGN - The SIGNID parameter of DB2 connection is used as the Thread authorization ID.
  • TERM - The terminal identification is used as the Thread authorization ID.
  • TX - The transaction identification is used as the Thread authorization ID.
  • OPID - The user operator identification is used as the Thread authorization ID.
  • ID - The eight character user ID associated with the CICS transaction is used as the Thread authorization ID.
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 - Resource was last changed by a CICSPlex SM API command.
  • N_A - Resource was created or last updated prior to CICS TS Version 4 Release 1 and support for resource signatures.
Last modification agent release CHANGEAGREL The CICS release level of the agent that made the last modification.
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.
Time created CREATETIME The local date and time when the definition was created.
CSD group CSDGROUP The name of the CSD group for this CICS resource definition. This field is ignored for BAS definitions.
Version DEFVER The version number of the BAS resource definition, from 1 to 15. This field is ignored for CICS CSD resource definitions.
Description code page DESCCODEPAGE The code page of the description field. This field is ignored for CICS CSD resource definitions.
Description DESCRIPTION A description of the DB2 entry definition.
Deadlock rollback option DROLLBACK Indicates whether or not the CICS DB2 attachment will initiate a syncpoint rollback in the event of a transaction being selected as a victim of a deadlock resolution.
  • YES - 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.
  • NO - 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.
Name NAME The name of the DB2 entry definition.
Plan name PLAN The name of the plan to be used for all pool threads. If a Plan name is specified, the Dynamic plan exit name field is set to blank. If neither PLAN nor PLANEXITNAME is specified, then CICS will set PLANEXITNAME to 'DSNCUEXT' at installation time.
Dynamic plan exit name PLANEXITNAME The name of the dynamic plan exit used for pool threads. If a Dynamic plan exit name is specified, the Plan name field is set to blank. If neither PLAN nor PLANEXITNAME is specified, then CICS will set PLANEXITNAME to 'DSNCUEXT' at installation time.
TCB priority PRIORITY The priority of the db2 entry TCBs relative to the CICS main task.
  • HIGH - The TCB will attain a higher priority then the CICS (QR TCB)
  • EQUAL - The TCB will have an equal priority to the CICS (QR TCB)
  • LOW - The TCB will have a lower priority to the CICS (QR TCB)
Maximum number of protected threads PROTECTNUM The current maximum number of protected threads allowed for this DB2 entry.
Sharelocks option SHARELOCKS Indicates whether or not the DB2 should share locks between multiple threads in multiple regions involved in the same distributed unit of work.
  • YES - DB2 should share locks.
  • NO - DB2 should not share locks.
Maximum number of active threads THREADLIMIT The current maximum number of pool threads that the CICS DB2 attachment facility allows to be active before requests are made to wait or are rejected (subject to the THREADWAIT attribute). The default threadlimit (3) is also the minimum you can specify. The maximum value must not be greater than the value specified for TCBLIMIT.
Thread wait option THREADWAIT 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.
  • YES - If all threads are busy, a transaction will wait until one becomes available.
  • NO - If all threads are busy, a transaction will be terminated with abend code AD2P.
  • POOL - 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.
Transaction ID TRANSID The transaction ID associated with the entry. Only one transaction can be specified here. However, the use of one or more wildcard characters allows a group of transactions to be represented. Additional transactions can be defined for this entry by defining a DB2 transaction that refers to this DB2 entry. This field is optional on a DB2 entry. All transactions can be associated with a DB2 entry means of DB2 transactions instead. However, if only one transaction is associated with a DB2 entry it is easier to specify it on the DB2 entry. Note: Specifying a transaction ID here causes a 'ghost' DB2 transaction object to be created when the DB2 entry definition is installed, and such DB2 transaction objects may appear on SYSRES and RDSCPROC views.
User data area 1 USERDATA1 Optional string of up to 8 characters that allows you to provide additional site-specific data related to the BAS resource definition. This field is ignored for CICS CSD resource definitions.
User data area 2 USERDATA2 Optional string of up to 8 characters that allows you to provide additional site-specific data related to the BAS resource definition. This field is ignored for CICS CSD resource definitions.
User data area 3 USERDATA3 Optional string of up to 8 characters that allows you to provide additional site-specific data related to the BAS resource definition. This field is ignored for CICS CSD resource definitions.