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 IndexGeneral IBM MQ Supportcomparing LGETTIME with LPUTTIME is not working in QStatus

Post new topicReply to topic
comparing LGETTIME with LPUTTIME is not working in QStatus View previous topic :: View next topic
Author Message
vicks_mq
PostPosted: Tue Nov 06, 2018 8:08 am Post subject: comparing LGETTIME with LPUTTIME is not working in QStatus Reply with quote

Apprentice

Joined: 03 Oct 2017
Posts: 39

Hello Everyone, I tried comparing LGETTIME with LPUTTIME for a local queue , the purpose is I want to see any delays happening in any module of the transactions and it didn't work in MQSC.
I tried all the below but none worked.

Quote:
dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime eq lputtime)
10 : dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime eq lputtime)
AMQ8569: Error in filter specification
dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime eq lputtime

AMQ8427: Valid syntax for the MQSC command:

DISPLAY display_cmd
WHERE( filter_keyword operator filter_value )

operator := [ LT | GT | EQ | NE | LE | GE | CT | EX | LK | NL | CTG | EXG ]
dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime NE lputtime)
11 : dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime NE lputtime)
AMQ8569: Error in filter specification
dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime NE lputtime

AMQ8427: Valid syntax for the MQSC command:

DISPLAY display_cmd
WHERE( filter_keyword operator filter_value )

operator := [ LT | GT | EQ | NE | LE | GE | CT | EX | LK | NL | CTG | EXG ]
dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime LK lputtime)
12 : dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime LK lputtime)
AMQ8569: Error in filter specification
dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime LK lputtime

AMQ8427: Valid syntax for the MQSC command:

DISPLAY display_cmd
WHERE( filter_keyword operator filter_value )

operator := [ LT | GT | EQ | NE | LE | GE | CT | EX | LK | NL | CTG | EXG ]
dis qs(UBR.LYT.ZIPC.QUEUE) [color=yellow]where(lgettime EX lputtime)[/color]
13 : dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime EX lputtime)
AMQ8569: Error in filter specification
dis qs(UBR.LYT.ZIPC.QUEUE) where(lgettime EX lputtime

AMQ8427: Valid syntax for the MQSC command:

DISPLAY display_cmd
WHERE( filter_keyword operator filter_value )

operator := [ LT | GT | EQ | NE | LE | GE | CT | EX | LK | NL | CTG | EXG ]

Does anyone knows how to fix it or a better way to do it?
Back to top
View user's profile Send private message
hughson
PostPosted: Tue Nov 06, 2018 3:10 pm Post subject: Reply with quote

Sentinel

Joined: 09 May 2013
Posts: 860
Location: Bay of Plenty, New Zealand

IBM MQ WHERE clause:-
Code:
WHERE(filter-keyword operator filter-value)

With the WHERE clause in IBM MQ, you cannot use an attribute name in the filter-value. This is why it is failing for you.

With the MQSCX tool from MQGem, such restrictions are lifted. MQSCX has it's own =WHERE clause which would allow you to do this.

Code:
DISPLAY QSTATUS(*) =WHERE(LGETTIME EQ LPUTTIME)

It can also do ANDs and ORs so you could also do this:-

Code:
DISPLAY QSTATUS(*) =WHERE(LGETTIME EQ LPUTTIME AND LGETDATE EQ LPUTDATE)

You can remove all those where both are empty (and thus match) to show you the real data by extending the command thus.

Code:
DISPLAY QSTATUS(*) =WHERE(LGETTIME AND LGETDATE AND LGETTIME EQ LPUTTIME AND LGETDATE EQ LPUTDATE)


Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
vicks_mq
PostPosted: Mon Nov 12, 2018 10:00 am Post subject: Reply with quote

Apprentice

Joined: 03 Oct 2017
Posts: 39

Thanks Morag, will do manually one by one, can't purchase the tool.
Employer says NO

hughson wrote:
IBM MQ WHERE clause:-
Code:
WHERE(filter-keyword operator filter-value)

With the WHERE clause in IBM MQ, you cannot use an attribute name in the filter-value. This is why it is failing for you.

With the MQSCX tool from MQGem, such restrictions are lifted. MQSCX has it's own =WHERE clause which would allow you to do this.

Code:
DISPLAY QSTATUS(*) =WHERE(LGETTIME EQ LPUTTIME)

It can also do ANDs and ORs so you could also do this:-

Code:
DISPLAY QSTATUS(*) =WHERE(LGETTIME EQ LPUTTIME AND LGETDATE EQ LPUTDATE)

You can remove all those where both are empty (and thus match) to show you the real data by extending the command thus.

Code:
DISPLAY QSTATUS(*) =WHERE(LGETTIME AND LGETDATE AND LGETTIME EQ LPUTTIME AND LGETDATE EQ LPUTDATE)


Cheers,
Morag
Back to top
View user's profile Send private message
hughson
PostPosted: Mon Nov 12, 2018 2:36 pm Post subject: Reply with quote

Sentinel

Joined: 09 May 2013
Posts: 860
Location: Bay of Plenty, New Zealand

vicks_mq wrote:
Thanks Morag, will do manually one by one, can't purchase the tool.
Employer says NO

Sorry to hear that - it is a really great tool (and yes I'm sure I am biased! but I use it every day and couldn't live without it), and is very cheap.

In case it helps with making the case to your employer - have a read of our Business Case document. You have just demonstrated to yourself already a time saver!

Have a great day!
Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
bruce2359
PostPosted: Mon Nov 12, 2018 5:59 pm Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8219
Location: US: west coast, almost. Otherwise, enroute.

Morag:

Does your tool come with a 30-, 60-, 90-day free trial? If so, perhaps the OP can install it briefly to demonstrate to management its value to the organization.
_________________
There are two types of people in this world:
1) Those that can extrapolate from incomplete data
Back to top
View user's profile Send private message
hughson
PostPosted: Mon Nov 12, 2018 7:42 pm Post subject: Reply with quote

Sentinel

Joined: 09 May 2013
Posts: 860
Location: Bay of Plenty, New Zealand

bruce2359 wrote:
Morag:

Does your tool come with a 30-, 60-, 90-day free trial? If so, perhaps the OP can install it briefly to demonstrate to management its value to the organization.
Yes indeed. You may request a month long trial licence to use any of our tools for free to try them out. Further details on our website and in the previously linked PDF.

Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexGeneral IBM MQ Supportcomparing LGETTIME with LPUTTIME is not working in QStatus
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.