![[IBM i]](ngibmi.gif)
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:
- *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.
- *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.