Home

 

Conn attrs

 

If TYPE is set to CONN, the following information is always returned for each connection that satisfies the selection criteria, except where indicated:

The following parameters can be specified for TYPE(CONN) to request additional information for each connection. If a parameter is specified that is not relevant for the connection, operating environment, or type of information requested, that parameter is ignored.

APPLTAG

A string containing the tag of the application connected to the queue manager. It is one of the following:

  • z/OS batch job name

  • TSO USERID

  • CICS APPLID

  • IMS™ region name

  • Channel initiator job name

  • i5/OS job name

  • UNIX process

  • Windows process

    This consists of the full program path and executable file name. If it is more than 28 characters long, only the last 28 characters will be shown.

  • Internal queue manager process name

APPLTYPE

A string indicating the type of the application that is connected to the queue manager. It is one of the following:

BATCH

Application using a batch connection

RRSBATCH

RRS-coordinated application using a batch connection

CICS

CICS transaction

IMS

IMS transaction

CHINIT

Channel initiator

i5/OS

An i5/OS application

SYSTEM

Queue manager

UNIX

A UNIX application

USER

A user application

WINDOWSNT

A Windows application

ASID

A 4-character address-space identifier of the application identified by APPLTAG. It distinguishes duplicate values of APPLTAG.

This parameter is returned only on z/OS when the APPLTYPE parameter does not have the value SYSTEM.

This parameter is valid only on z/OS.

CHANNEL

The name of the channel that owns the connection. If there is no channel associated with the connection, this parameter is blank.

CONNAME

The connection name associated with the channel that owns the connection. If there is no channel associated with the connection, this parameter is blank.

CONNOPTS

The connect options currently in force for this application connection. Possible values are:

  • MQCNO_HANDLE_SHARE_BLOCK

  • MQCNO_HANDLE_SHARE_NO_BLOCK

  • MQCNO_HANDLE_SHARE_NONE

  • MQCNO_SHARED_BINDING

  • MQCNO_STANDARD_BINDING

  • MQCNO_ISOLATED_BINDING

  • MQCNO_FASTPATH_BINDING

  • MQCNO_SERIALIZE_CONN_TAG_Q_MGR

  • MQCNO_SERIALIZE_CONN_TAG_QSG

  • MQCNO_RESTRICT_CONN_TAG_Q_MGR

  • MQCNO_RESTRICT_CONN_TAG_QSG

  • MQCNO_ACCOUNTING_Q_ENABLED

  • MQCNO_ACCOUNTING_Q_DISABLED

  • MQCNO_ACCOUNTING_MQI_ENABLED

  • MQCNO_ACCOUNTING_MQI_DISABLED

We cannot use the value MQCNO_STANDARD_BINDING as a filter value with the CT and EX operators on the WHERE parameter.

EXTURID

The external unit of recovery identifier associated with this connection. Its format is determined by the value of URTYPE.

We cannot use EXTURID as a filter keyword.

NID

Origin identifier, set only if the value of UOWSTATE is UNRESOLVED. This is a unique token identifying the unit of work within the queue manager. It is of the form origin-node.origin-urid where

  • origin-node identifies the originator of the thread, except in the case where APPLTYPE is set to RRSBATCH, when it is omitted.

  • origin-urid is the hexadecimal number assigned to the unit of recovery by the originating system for the specific thread to be resolved.

This parameter is valid only on z/OS.

PID

Number specifying the process identifier of the application that is connected to the queue manager.

This parameter is not valid on Compaq NSK and z/OS.

PSBNAME

The 8-character name of the program specification block (PSB) associated with the running IMS transaction. We can use the PSBNAME and PSTID to purge the transaction using IMS commands. It is valid on z/OS only.

This parameter is returned only when the APPLTYPE parameter has the value IMS.

PSTID

The 4-character IMS program specification table (PST) region identifier for the connected IMS region. It is valid on z/OS only.

This parameter is returned only when the APPLTYPE parameter has the value IMS.

QMURID

The queue manager unit of recovery identifier. On z/OS, this is a 6–byte log RBA, displayed as 12 hexadecimal characters. On platforms other than z/OS, this is an 8–byte transaction identifier, displayed as m.n where m and n are the decimal representation of the first and last 4 bytes of the transaction identifier.

We can use QMURID as a filter keyword. On z/OS, specify the filter value as a hexadecimal string. On platforms other than z/OS, specify the filter value as a pair of decimal numbers separated by a period (.). We can only use the EQ, NE, GT, LT, GE, or LE filter operators.

TASKNO

A 7-digit CICS task number. This number can be used in the CICS command "CEMT SET TASK(taskno) PURGE" to end the CICS task. This parameter is valid on z/OS only.

This parameter is returned only when the APPLTYPE parameter has the value CICS.

TID

Number specifying the thread identifier within the application process that has opened the specified queue.

This parameter is not valid on z/OS.

TRANSID

A 4-character CICS transaction identifier. This parameter is valid on z/OS only.

This parameter is returned only when the APPLTYPE parameter has the value CICS.

UOWLOG

The filename of the extent to which the transaction associated with this connection first wrote.

This parameter is valid only on platforms other than z/OS.

UOWLOGDA

The date that the transaction associated with the current connection first wrote to the log.

UOWLOGTI

The time that the transaction associated with the current connection first wrote to the log.

UOWSTATE

The state of the unit of work. It is one of the following:

NONE

There is no unit of work.

ACTIVE

The unit of work is active.

PREPARED

The unit of work is in the process of being committed.

UNRESOLVED

The unit of work is in the second phase of a two-phase commit operation. WebSphere MQ holds resources on its behalf and external intervention is required to resolve it. This might be as simple as starting the recovery coordinator (such as CICS, IMS, or RRS) or it might involve a more complex operation such as using the RESOLVE INDOUBT command. The UNRESOLVED value can occur only on z/OS.

UOWSTDA

The date that the transaction associated with the current connection was started.

UOWSTTI

The time that the transaction associated with the current connection was started.

URTYPE

The type of unit of recovery as seen by the queue manager. It is one of the following:

  • CICS (valid only on z/OS)

  • XA

  • RRS (valid only on z/OS)

  • IMS (valid only on z/OS)

  • QMGR

URTYPE identifies the EXTURID type and not the type of the transaction coordinator. When URTYPE is QMGR, the associated identifier is in QMURID (and not EXTURID).

USERID

The user identifier associated with the connection.

This parameter is not returned when APPLTYPE has the value SYSTEM.

 

Parent topic:

Parameter descriptions


sc11970_


 

Home