INQUIRE DB2TRAN

Description

A DB2TRAN is identified by the name with which it is defined in CEDA. Alternatively, if a TRANSID is specified on a DB2ENTRY when the DB2ENTRY is installed, CICS® installs a DB2TRAN named DFHtttt, where tttt is the TRANSID.

Browsing

You can also browse through all of the DB2TRAN associations installed in your system by using the browse options, START, NEXT, and END, on INQUIRE DB2TRAN commands. See Browsing resource definitions for general information about browsing, including syntax, exception conditions, and examples.

The resource signature

You can use this command to retrieve 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 BUNDLE, 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.

Options

DB2ENTRY

Returns the name of the DB2ENTRY to which this DB2TRAN refers; that is, the DB2ENTRY with which this additional transaction is associated.

CHANGEAGENT(cvda)

Returns a CVDA value that identifies the agent that made the last change to the resource definition. 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(data-area)

Returns a 4-digit number of the CICS release that was running when the resource definition was last changed.

CHANGETIME(data-area)

Returns an ABSTIME value that represents the time stamp when the resource definition was last changed. For more information about the format of the ABSTIME value, see FORMATTIME.

CHANGEUSRID(data-area)

Returns the 8-character user ID that ran the change agent.

DEFINESOURCE(data-area)

Returns the 8-character source of the resource definition. The DEFINESOURCE value depends on the CHANGEAGENT value. For more information, see Summary of the resource signature field values.

DEFINETIME(data-area)

Returns an ABSTIME value that represents the time stamp when the resource definition was created.

INSTALLAGENT(cvda)

Returns a CVDA value that identifies the agent that installed the resource. 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(data-area)

Returns an ABSTIME value that represents the time stamp when the resource was installed.

INSTALLUSRID(data-area)

Returns 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 associated DB2ENTRY, or if 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 if 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 for information about use of wildcard characters.

Conditions

NOTAUTH

RESP2 values:

100

Command authorization failure

101

Resource authorization failure

NOTFND

RESP2 values:

1

The DB2TRAN definition cannot be found.