Filter command (WHERE)
This parameter can be used to selectively display only those queue manager connections with particular connection attributes.
- *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
- iSeries 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.
- 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
- Queue manager transaction.
- *XA
- XA transaction.
- *USERID
- The user identifier associated with the connection.
The filter value is user identifier name.