![[IBM i]](ngibmi.gif)
WRKMQMCONN (Work with MQ Connections)
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.
- Where allowed to run
- All environments (*ALL)
- Threadsafe
- Yes
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, *APPTYPE, *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:
- *DFT
- Use the default queue manager.
- queue-manager-name
- The name of a message queue manager.
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.
- *APPTYPE
- The type of the application to start. The possible values are:
- *CHINIT
- Channel initiator.
- *CICS
- Represents a CICS®/400 application.
- *DEF
- The attribute is unchanged.
- integer
- User-defined application type in the range 65536 through 999999999.
- *OS400
- Represents an IBM® i application.
- *SYSTEM
- Queue manager
- *SYSTEM_EXT
- System extension application.
- *UNIX
- A UNIX or Linux® application.
- user-value
- User-defined application.
The filter value is the integer application type.
- *WINDOWS
- Represents a Windows application.
- *WINDOWS_NT
- Represents a Windows NT application.
- *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.