CEMT INQUIRE DB2TRAN

Returns attributes of a particular DB2TRAN that associates a transaction or group of transactions with a DB2ENTRY.

In the CICS Explorer, the DB2 transactions operations view provides a functional equivalent to this command.

Description

If a TRANSID is specified on a DB2ENTRY when the DB2ENTRY is installed, CICS installs a DB2TRAN named DFHtttt, where tttt is the TRANSID.

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.

CEMT INQUIRE DB2TRAN

Read syntax diagramSkip visual syntax diagramCEMT INQUIRE DB2TRAN ( data-area)DB2ENTRY( data-area)PLAN( data-area)PLANEXITNAME( data-area)TRANSID( data-area)INSTALLTIME( date time)INSTALLUSRID( value) CREATESPICSDAPIDYNAMICGRPLIST DEFINESOURCE( value)DEFINETIME( date time)CHANGETIME( date time)CHANGEUSRID( value) CREATESPICSDAPICSDBATCHDREPAPIDYNAMIC CHANGEAGREL( value)

Displayed fields

DB2ENTRY
Returns the name of the DB2ENTRY to which this DB2TRAN refers. This is the DB2ENTRY with which this additional transaction should be associated.
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.
DYNAMIC
The resource was defined as a result of the installation of a DB2ENTRY with TRANSID specified.
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.
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.
DYNAMIC
The resource was installed as a result of the installation of a DB2ENTRY with TRANSID specified.
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 retrieved from the associated DB2ENTRY if it exists. If there is no DB2ENTRY, or the DB2ENTRY is disabled with DISABLEDACT(POOL), the pool plan name is returned if it exists. If PLAN is returned, PLANEXITNAME is blank.
PLANEXITNAME
Returns the name of the dynamic plan exit to be used, if any, from the associated DB2ENTRY if it exists. If there is no associated DB2ENTRY, or the DB2ENTRY is disabled with DISABLEDACT(POOL), the pool plan exit name is returned if it exists. If PLANEXITNAME is returned, PLAN is blank.
TRANSID
Specifies the transaction ID to be associated with the entry. The transaction ID can include wildcard characters. See Wildcard characters for transaction IDs.