ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General IBM MQ Support » Filters on PCF Commands

Post new topic  Reply to topic
 Filters on PCF Commands « View previous topic :: View next topic » 
Author Message
72dolfan
PostPosted: Wed Aug 02, 2006 8:55 am    Post subject: Filters on PCF Commands Reply with quote

Acolyte

Joined: 02 May 2006
Posts: 53

Can you put filters on PCF Commands like only returning info on queues with Depth OR queues with Input Processors?

I want info back on queues form a Inquire_Q_Status that either have depth, or, if they don't have depth, they have one or more input processors. Is this possible? Or is it handled more like a "AND" vs OR"

Thanks,
Bill
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Wed Aug 02, 2006 9:21 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

MQSC doesn't let you specify more than one filter on a where clause.

PCF doesn't either.

The where clause is implemented with http://publib.boulder.ibm.com/infocenter/wmqv6/v6r0/index.jsp?topic=/com.ibm.mq.csqzac.doc/mqcfsf.htm

You'll have to filter these yourself after you do the Inq Queue Status.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
72dolfan
PostPosted: Wed Aug 02, 2006 10:34 am    Post subject: Reply with quote

Acolyte

Joined: 02 May 2006
Posts: 53

Thanks for replying. I read through the link and related issues but did not see anything that said only one filter could be used per PCF. Are you aware of a link that talks about this?

Also, I assume that I can filter the Inquire_Q_Status so that it only returns stats for queues with Depth, correct?

Thanks,
Bill
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Wed Aug 02, 2006 11:01 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

I haven't been able to find anything that tells me how to specify an AND or an OR or any other kind of conjuction to specify more than one filter. And it is not possible to specify more than one WHERE clause.

That is, in absence of anything that says you CAN do it, and in a failure to be successfull with my best guesses, the reasonable conclusion is that it is not possible.

So you can specify a single filter condition on inquire queue stats, perhaps depth gt 0.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
72dolfan
PostPosted: Wed Aug 02, 2006 11:11 am    Post subject: Reply with quote

Acolyte

Joined: 02 May 2006
Posts: 53

Okay. Thanks for your help!!!!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » Filters on PCF Commands
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.