CEMT INQUIRE DB2ENTRY
Returns the attributes of the DB2ENTRY that defines resources to be used by a specific transaction or by a group of transactions when accessing DB2.
In the CICS Explorer, the DB2 entries operations view provides a functional equivalent to this command.
Description
The entry is identified by the name with which it was defined in CEDA.
The resource signature
You can use this command to display the resource signature fields. You can use these fields to manage resources by capturing details of when the resource was defined, installed, and last changed. For more information, see Auditing resources. The resource signature fields are CHANGEAGENT, CHANGEAGREL, CHANGETIME, CHANGEUSRID, DEFINESOURCE, DEFINETIME, INSTALLAGENT, INSTALLTIME, and INSTALLUSRID. See Summary of the resource signature field values for detailed information about the content of the resource signature fields.
Displayed fields
- ACCOUNTREC
- Returns the minimum amount of DB2 accounting record required
for transactions using this DB2ENTRY. The specified minimum might
be exceeded, as described in the following options. The values are
as follows:
- UOW
- The CICS DB2 attachment facility causes an accounting record to be produced 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 for each CICS task to be produced.
A transaction containing multiple UOWs may use a different thread for each of its UOWs (assuming the thread is released at sync point). The result may be an accounting record produced for each UOW.
- TXID
- The CICS DB2 attachment facility causes an accounting record to be
produced when the transid using the thread changes.
This option applies to DB2ENTRY inquiries that are used by more than one transaction ID. Because threads are typically released at sync point, a transaction containing multiple UOWs can use a different thread for each UOW. The result may be that an accounting record is produced for each UOW.
- NONE
- No accounting records are required for transactions using threads
from this DB2ENTRY.
DB2 does, however, produce at least one accounting record for each thread when the thread is ended. Additionally, authorization changes cause accounting records to be produced.
- AUTHID
- Returns an ID to be used for security checking when using pool threads. If an AUTHID is returned, AUTHTYPE is not applicable.
- AUTHTYPE
- Returns the type of ID to be used for security checking
for threads on this DB2ENTRY. If an AUTHTYPE is returned, AUTHID is
blank. The values are as follows:
- GROUP
- The 8-character user ID and the connected group name are used as
the authorization ID. The following table shows how these two values
are interpreted by DB2.
IDs passed to DB2 How DB2 interprets values CICS sign-on user ID (USERID) Represents the primary DB2 authorization ID. RACF connected group name If the RACF list of group options is not active, then DB2 uses the connected group name supplied by the CICS attachment facility as the secondary DB2 authorization ID. If the RACF list of group options is active, DB2 ignores the connected group name supplied by the CICS attachment facility, but the value appears in the DB2 list of secondary DB2 authorization IDs. If no RACF group ID is available for this user ID, an 8-character field of blanks is passed to DB2 as the group ID.
- SIGN
- The SIGNID parameter of the DB2CONN is used as the resource authorization ID.
- TERM
- The terminal identification (four characters padded to eight) is
used as an authorization ID. An authorization ID cannot be obtained
in this manner if a terminal is not connected with the transaction.
If a transaction is started using a CICS command and has no terminal associated with it, do not use AUTHTYPE(TERM).
- TX
- The transaction identification (four characters padded to eight) is used as the authorization ID.
- OPID
- The operator identification associated with the user ID that is associated with the CICS transaction is used as the authorization ID (three characters padded to eight).
- USERID
- The 8-character user ID associated with the CICS transaction is used
as the authorization ID.
When the DB2 sample sign-on exit DSN3@SGN is used with AUTHTYPE(USERID), the exit sends the user ID to DB2 as the primary authorization ID and the RACF group ID to DB2 as the secondary ID. When the sample sign-on exit is used, there is no difference between AUTHTYPE(USERID) and AUTHTYPE(GROUP).
- CHANGEAGENT(value)
- Displays a value that identifies the agent that made the last change to the resource definition.
You cannot use CEMT to filter on some of these values because they are duplicated. The possible
values are as follows:
- CREATESPI
- The resource definition was last changed by an EXEC CICS CREATE command.
- CSDAPI
- The resource definition was last changed by a CEDA transaction or the programmable interface to DFHEDAP.
- CSDBATCH
- The resource definition was last changed by a DFHCSDUP job.
- DREPAPI
- The resource definition was last changed by a CICSPlex SM BAS API command.
- CHANGEAGREL(value)
- Displays the 4-digit number of the CICS release that was running when the resource definition was last changed.
- CHANGETIME(date time)
- Displays the date and time when the resource definition was last changed. The format of the date depends on the value that you selected for the DATFORM system initialization parameter for your CICS region. The format of the time is hh:mm:ss.
- CHANGEUSRID(value)
- Displays the 8-character user ID that ran the change agent.
- DEFINESOURCE(value)
- Displays the source of the resource definition. The DEFINESOURCE value depends on the CHANGEAGENT option. For details, see Summary of the resource signature field values.
- DEFINETIME(date time)
- Displays the date and time when the resource was created. The format of the date depends on the value that you selected for the DATFORM system initialization parameter for your CICS region. The format of the time is hh:mm:ss.
- DISABLEDACT
- Returns a value showing what CICS is to do with new transactions
accessing DB2ENTRY when it has been disabled or is disabling. If DISABLEDACT
is not specified, and DB2ENTRY is disabled, new requests are routed
to the pool by default. The values are as follows:
- 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 stops the transaction.The abend code is AD26.
- SQLCODE
- An SQLCODE is returned to the application indicating that the DB2ENTRY is disabled.
- DROLLBACK
- Returns a value showing whether the CICS DB2 attachment
should initiate a sync point rollback if a transaction is adversely
affected by a deadlock resolution. The values are as follows:
- ROLLBACK
- The attachment facility issues a sync point rollback before returning control to the application. An SQL return code of -911 is returned to the program.
- NOROLLBACK
- The attachment facility does not initiate a rollback for this transaction. An SQL return code of -913 is returned to the application.
- ENABLESTATUS
- Indicates whether the DB2ENTRY can be accessed by applications.
The values are as follows:
- ENABLED
- The DB2ENTRY can be accessed by applications. DB2ENTRY is installed in an ENABLED state.
- DISABLED
- The DB2ENTRY cannot be accessed by applications.
- DISABLING
- The DB2ENTRY is in the process of being disabled. New transactions cannot access the DB2ENTRY. Existing transactions using the DB2ENTRY are allowed to complete unless the DB2ENTRY is being disabled with the FORCE option.
- INSTALLAGENT(value)
- Displays a value that identifies the agent that installed the resource. You cannot use CEMT to
filter on some of these values because they are duplicated. The possible values are as follows:
- CREATESPI
- The resource was installed by an EXEC CICS CREATE command.
- CSDAPI
- The resource was installed by a CEDA transaction or the programmable interface to DFHEDAP.
- GRPLIST
- The resource was installed by GRPLIST INSTALL.
- INSTALLTIME(date time)
- Displays the date and time when the resource was installed. The format of the date depends on the value that you selected for the DATFORM system initialization parameter for your CICS region. The format of the time is hh:mm:ss.
- INSTALLUSRID(value)
- Displays the 8-character user ID that installed the resource.
- PLAN
- Returns the name of the plan to be used for this DB2ENTRY. If PLAN is returned, PLANEXITNAME is blank.
- PLANEXITNAME
- Returns the name of the dynamic plan exit (if any) to be used for this DB2ENTRY. If PLANEXITname is returned, PLAN is blank.
- PRIORITY
- Returns the priority of the pool thread
TCBs relative to the CICS main TCB (QR TCB). The thread TCBs are CICS
open L8 TCBs.
- HIGH
- Thread TCBs have a higher priority than the CICS QR TCB.
- EQUAL
- Thread TCBs have equal priority with the CICS QR TCB.
- LOW
- Thread TCBs have a lower priority than the CICS QR TCB.
- PROTECTNUM
- Returns the maximum number of protected threads allowed for this DB2ENTRY.
- PTHREADS
- Returns the current number of protected threads for this DB2ENTRY. A protected thread is an inactive thread available for reuse by a new transaction. If no transaction has reused the thread by the time it has been processed by two purge cycles, the thread is ended.
- THREADLIMIT
- Returns the current maximum number of threads for this DB2ENTRY that the CICS DB2 attachment allows active before requests are made to wait, overflow to the pool, or are rejected. See the Threadwait field.
- THREADS
- Returns the current number of threads active for this DB2ENTRY.
- THREADWAIT
- Indicates whether transactions wait for a DB2ENTRY thread
to be abended, or overflow to the pool if the number of active DB2ENTRY
threads reach the Threadlimit number. The values are as follows:
- TWAIT
- If all threads are busy, a transaction waits until one becomes available.
- NOTWAIT
- If any threads are busy, a transaction is stopped with an abend code AD2P.
- TPOOL
- If all threads are busy, a transaction is diverted to use a pool thread. If the pool is also busy, and NOTWAIT has been specified for the THREADWAIT parameter on the DB2CONN, the transaction is ended with abend code AD3T.