Work with MQ Connections (WRKMQMCONN)

    Where allowed to run
    All environments (*ALL)

    Threadsafe
    Yes

The Work with MQ Connections (WRKMQMCONN) command allows you to work with connection information for applications that are connected to the queue manager.

This enables you to display connection handles and end connections to the queue manager.


Parameters

Keyword Description Choices Notes
CONN Connection Identifier Character value, *ALL Optional, Positional 1
MQMNAME Message Queue Manager name Character value, *DFT Optional, Positional 2
WHERE Filter command Single values: *NONE Other values: Element list Optional, Positional 3
Element 1: Filter keyword *APPLDESC, *APPLTAG, *APPLTYPE, *CHLNAME, *CONNAME, *PID, *TID, *UOWLOGDA, *UOWLOGTI, *UOWSTDA, *UOWSTTI, *URTYPE, *USERID
Element 2: Filter operator *GT, *LT, *EQ, *NE, *GE, *LE, *LK, *NL, *CT, *EX, *CTG, *EXG
Element 3: Filter value Character value


Connection Identifier (CONN)

>

The connection identifiers to work with.

The possible values are:

    *ALL
    All connection identifiers are selected.

    connection-id
    Specify the name of a specific connection identifier. The connection identifier is a 16 character hex string.


Message Queue Manager name (MQMNAME)

>

Specifies the name of the queue manager.

The possible values are:


Filter command (WHERE)

>

This parameter can be used to selectively display only those queue manager connections with particular connection attributes.

The parameter takes three arguments, a keyword, an operator and a value.

Generic strings are allowed for values which are names.

The operator can take one of the following values:

    *GT
    Greater than.

    Applicable to integer and non-generic string values.

    *LT
    Less than.

    Applicable to integer and non-generic string values

    *EQ
    Equal to.

    Applicable to integer and non-generic string values.

    *NE
    Not equal to.

    Applicable to integer and non-generic string values.

    *GE
    Greater than or equal to.

    Applicable to integer and non-generic string values.

    *LE
    Less than or equal to.

    Applicable to integer and non-generic string values.

    *LK
    Like.

    Applicable to generic string values.

    *NL
    Not like.

    Applicable to generic string values.

    *CT
    Contains.

    Applicable to non-generic list values.

    *EX
    Excludes.

    Applicable to non-generic list values.

    *CTG
    Contains generic.

    Applicable to generic list values.

    *EXG
    Excludes generic.

    Applicable to generic list values.

The keyword can take one of the following values:

    *APPLDESC
    The description of the application connected to the queue manager.

    The filter value is the application description string.

    *APPLTAG
    The tag of the application connected to the queue manager.

    The filter value is the application tag string.

    *APPLTYPE
    The type of applcation connected to the queue manager.

    The filter value is one of the following:

      *CICS
      CICS/400 application.

      *MVS
      MVS application.

      *IMS
      IMS application.

      *OS2
      OS/2 application.

      *DOS
      DOS application.

      *UNIX
      UNIX application.

      *QMGR
      Queue manager application.

      *OS400
      IBM i application.

      *WINDOWS
      Windows application.

      *CICS_VSE
      CICS/VSE application.

      *WINDOWS_NT
      Windows NT application.

      *VMS
      VMS application.

      *NSK
      Tandem/NSK application.

      *VOS
      VOS application.

      *IMS_BRIDGE
      IMS bridge application.

      *XCF
      XCF application.

      *CICS_BRIDGE
      CICS bridge application.

      *NOTES_AGENT
      Lotus Notes application.

      *BROKER
      Broker application.

      *JAVA
      Java application.

      *DQM
      DQM application.

      *CHINIT
      Channel initiator.

      *SYSTEM_EXT
      System extension application.

      user-value
      User-defined application.

      The filter value is the integer application type.

    *CHLNAME
    The name of the channel that owns the connection.

    The filter value is the channel name.

    *CONNAME
    The connection name associated with the channel that owns the connection.

    The filter value is the connection name.

    *PID
    The process identifier of the application that is connected to the queue manager.

    The filter value is the process identifier integer.

    *TID
    The thread identifier of the application that is connected to the queue manager.

    The filter value is the thread identifier integer.

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

    The filter value is the date in the form yyyy-mm-dd.

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

    The filter value is the time in the form hh:mm:ss.

    *UOWSTDA
    The date that the transaction associated with the connection was started.

    The filter value is the date in the form yyyy-mm-dd.

    *UOWSTTI
    The time that the transaction associated with the connection was started.

    The filter value is the time in the form hh:mm:ss.

    *URTYPE
    The type of unit of recovery identifier as seen by the queue manager.

    The filter value is one of the following:

      *QMGR
      A queue manager transaction.

      *XA
      An externally coordinated transaction. This includes units of work which have been established using IBM i Start Commitment Control (STRCMTCTL).

    *USERID
    The user identifier associated with the connection.

    The filter value is user identifier name.


Examples

>

None


Error messages

>

Unknown

Parent topic: CL commands reference for IBM i