Filter command (WHERE)
This parameter can be used to selectively display only those queues with particular queue attributes.
- *ACCTQ
- Queue Accounting.
The filter value is one of the following:
- *QMGR
- Accouting data collection is based upon the setting of the queue manager attribute ACCTQ.
- *OFF
- Accounting data collection for this queue is switched off.
- *ON
- Accounting data collection is switched on for this queue.
- *ALTDATE
- The date on which the definition or information was last altered.
The filter value is the data in the form yyyy-mm-dd.
- *ALTTIME
- The time at which the definition or information was last altered.
The filter value is the time in the form hh:mm:ss.
- *BKTTHLD
- Backout threshold.
The filter value is the integer threshold value.
- *BKTQNAME
- Backout requeue name.
The filter value is the name of the queue.
- *CLUSDATE
- The date on which the definition became available to the local queue manager.
The filter value is the date in the form yyyy-mm-dd.
- *CLUSNL
- The namelist that defines the clusters that the queue is in.
The filter value is the name of the namelist.
- *CLUSQMGR
- The name of the queue manager that hosts the queue.
The filter value is the name of the queue manager.
- *CLUSQTYPE
- Cluster queue type.
The filter value is one of the following:
- *LCL
- The cluster queue represents a local queue.
- *ALS
- The cluster queue represents an alias queue.
- *RMT
- The cluster queue represents a remote queue.
- *MQMALS
- The cluster queue represents a queue manager alias.
- *CLUSTER
- The name of the cluster that the queue is in.
The filter value is the name of the cluster.
- *CLUSTIME
- The time at which the definition became available to the local queue manager.
The filter value is the time in the form hh:mm:ss.
- *CLWLPRTY
- Cluster workload priority.
The filter value is the integer priority.
- *CLWLRANK
- Cluster workload rank.
The filter value is the integer rank.
- *CLWLUSEQ
- Cluster workload queue use.
The filter value is one of the following:
- *QMGR
- The value is inherited from the Queue Manager CLWLUSEQ attribute.
- *LOCAL
- The local queue will be the sole target of the MQPUT.
- *ANY
- The queue manager will treat such a local queue as another instance of the cluster queue for the purposes of workload distribution.
- *CRDATE
- The date on which the queue was created.
The filter value is the date in the form yyyy-mm-dd.
- *CRTIME
- The time at which the queue was created.
The filter value is the time in the form hh:mm:ss.
- *CURDEPTH
- Current depth of queue.
The filter value is the integer depth value.
- *DEFBIND
- Default message binding.
The filter value is one of the following:
- *OPEN
- The queue handle is bound to a specific instance of the cluster queue when the queue is opened.
- *NOTFIXED
- The queue handle is not bound to any particular instance of the cluster queue.
- *DFNTYPE
- Queue definition type.
The filter value is one of the following:
- *PREDEF
- Predefined queue.
- *PERMDYN
- Permanent dynamic queue.
- *TEMPDYN
- Temporary dynamic queue.
- *DFTMSGPST
- Default persistence of the messages put on this queue.
The filter value is one of the following:
- *NO
- Messages on this queue are lost across a restart of the queue manager.
- *YES
- Messages on this queue survive a restart of the queue manager.
- *DFTPTY
- Default priority of the messages put on the queue.
The filter value is the integer priority value.
- *DFTSHARE
- Default share option on a queue opened for input.
The filter value is one of the following:
- *NO
- The open request is for exclusive input from the queue.
- *YES
- The open request is for shared input from the queue.
- *DISTLIST
- Whether distribution lists are supported by the partner queue manager.
The filter value is one of the following:
- *NO
- Distribution lists are not supported by the partner queue manager.
- *YES
- Distribution lists are supported by the partner queue manager.
- *FULLEVT
- Whether Queue Depth Full events are generated.
The filter value is one of the following:
- *NO
- Queue Depth Full events are not generated.
- *YES
- Queue Depth Full events are generated.
- *GETDATE
- The date on which the last message was got from the queue since queue manager start. This field is only present when Queue Monitoring is not set to *OFF.
The filter value is the data in the form yyyy-mm-dd.
- *GETENBL
- Whether applications are permitted to get messages from the queue.
The filter value is one of the following:
- *NO
- Applications cannot retrieve messages from the queue.
- *YES
- Authorized applications can retrieve messages from the queue.
- *GETTIME
- The time at which the last message was got from the queue since queue manager start. This field is only present when Queue Monitoring is not set to *OFF.
The filter value is the time in the form hh:mm:ss.
- *HDNBKTCNT
- Whether the backout count is hardened.
The filter value is one of the following:
- *NO
- The backout count is not hardened.
- *YES
- The backout count is hardened.
- *HIGHEVT
- Whether Queue Depth High events are generated.
The filter value is one of the following:
- *NO
- Queue Depth High events are not generated.
- *YES
- Queue Depth High events are generated.
- *HIGHTHLD
- Queue Depth High event generation threshold.
The filter value is the integer threshold value.
- *INITQNAME
- Initiation queue.
The filter value is the name of the queue.
- *IPPROCS
- Number of handles indicating that the queue is open for input.
The filter value is the integer number of handles.
- *JOBS
- The current number of jobs that have the queue open.
The filter value is the integer number of jobs.
- *LOWEVT
- Whether Queue Depth Low events are generated.
The filter value is one of the following:
- *NO
- Queue Depth Low events are not generated.
- *YES
- Queue Depth Low events are generated.
- *LOWTHLD
- Queue Depth Low event generation threshold.
The filter value is the integer threshold value.
- *MAXDEPTH
- Maximum depth of queue.
The filter value is the integer number of messages.
- *MAXMSGLEN
- Maximum message length.
The filter value is the integer message length.
- *MEDIAREC
- The journal receiver containing the last media recovery image. This field is only present for local queues.
The filter value is the journal receiver string.
- *MONQ
- Online Monitoring Data.
The filter value is one of the following:
- *QMGR
- The collection of Online Monitoring Data is inherited from the setting of the queue manager attribute MONQ.
- *OFF
- Online Monitoring Data collection for this queue is switched off.
- *LOW
- Monitoring data collection is turned on with a low ratio of data collection.
- *MEDIUM
- Monitoring data collection is turned on with a moderate ratio of data collection.
- *HIGH
- Monitoring data collection is turned on with a high ratio of data collection.
- *MSGAGE
- The age in seconds of the oldest message on the Queue. This field is only present when Queue Monitoring is not set to *OFF.
The filter value is the integer message age.
- *MSGDLYSEQ
- Message delivery sequence.
The filter value is one of the following:
- *PTY
- Messages are delivered in FIFO order within priority.
- *FIFO
- Messages are delivered in FIFO order regardless of priority.
- *NPMCLASS
- Non-persistent message class.
The filter value is one of the following:
- *NORMAL
- Non-persistent message class is normal.
- *HIGH
- Non-persistent message class is high.
- *OPPROCS
- Number of handles indicating that the queue is open for output.
The filter value is the integer number of handles.
- *PRCNAME
- Process name.
The filter value is the name of the process.
- *PUTDATE
- The date on which the last message was put to the queue since queue manager start. This field is only present when Queue Monitoring is not set to *OFF.
The filter value is the data in the form yyyy-mm-dd.
- *PUTENBL
- Whether applications are permitted to put messages to the queue.
The filter value is one of the following:
- *NO
- Messages cannot be added to the queue.
- *YES
- Messages can be added to the queue by authorized applications.
- *PUTTIME
- The time at which the last message was put to the queue since queue manager start. This field is only present when Queue Monitoring is not set to *OFF.
The filter value is the time in the form hh:mm:ss.
- *QMID
- Internally generated unique name of the queue manager that hosts the queue.
The filter value is the name of the queue manager.
- *QTYPE
- Queue type.
The filter value is one of the following:
- *LCL
- Local queue.
- *ALS
- Alias queue.
- *RMT
- Remote queue.
- *MDL
- Model queue.
- *RMTMQMNAME
- Remote queue manager name.
The filter value is the name of the queue manager.
- *RMTQNAME
- Name of the local queue, as known by the remote queue manager.
The filter value is the name of the queue.
- *RTNITV
- Retention interval.
The filter value is the integer interval value.
- *SHARE
- Whether the queue can be shared.
The filter value is one of the following:
- *NO
- Only a single application instance can open the queue for input.
- *YES
- More than one application instance can open the queue for input.
- *SRVEVT
- Whether service interval events are generated.
The filter value is one of the following:
- *HIGH
- Service Interval High events are generated.
- *OK
- Service Interval OK events are generated.
- *NONE
- No service interval events are generated.
- *SRVITV
- Service interval event generation threshold.
The filter value is the integer threshold value.
- *STATQ
- Statistics data.
The filter value is one of the following:
- *QMGR
- Statistics data collection is based upon the setting of the queue manager attribute STATQ.
- *OFF
- Statistics data collection for this queue is switched off.
- *ON
- Statistics data collection is switched on for this queue.
- *TEXT
- Descriptive comment.
The filter value is the text description of the queue.
- *TGTQNAME
- Target queue for which this queue is an alias.
The filter value is the name of the queue.
- *TMQNAME
- Transmission queue name.
The filter value is the name of the queue.
- *TRGDATA
- Trigger data.
The filter value is the text of the trigger message.
- *TRGDEPTH
- Trigger depth.
The filter value is the integer number of messages.
- *TRGENBL
- Whether triggering is enabled.
The filter value is one of the following:
- *NO
- Triggering is not enabled.
- *YES
- Triggering is enabled.
- *TRGMSGPTY
- Threshold message priority for triggers.
The filter value is the integer priority value.
- *TRGTYPE
- Trigger type.
The filter value is one of the following:
- *FIRST
- When the number of messages on the queue goes from 0 to 1.
- *ALL
- Every time a message arrives on the queue.
- *DEPTH
- When the number of messages on the queue equals the value of the TRGDEPTH attribute.
- *NONE
- No trigger messages are written.
- *USAGE
- Whether the queue is a transmission queue.
The filter value is one of the following:
- *NORMAL
- The queue is not a transmission queue.
- *TMQ
- The queue is a transmission queue.