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.