| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| comparing LGETTIME with LPUTTIME is not working in QStatus |
« View previous topic :: View next topic » |
| Author |
Message
|
| vicks_mq |
 Posted: Tue Nov 06, 2018 8:08 am Post subject: comparing LGETTIME with LPUTTIME is not working in QStatus |
 |
|
Disciple
Joined: 03 Oct 2017
Posts: 162
|
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 |
|
 |
| hughson |
| Posted: Tue Nov 06, 2018 3:10 pm Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
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 |
|
|
| vicks_mq |
| Posted: Mon Nov 12, 2018 10:00 am Post subject: |
|
|
Disciple
Joined: 03 Oct 2017
Posts: 162
|
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 |
|
|
| hughson |
| Posted: Mon Nov 12, 2018 2:36 pm Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
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 |
|
|
| bruce2359 |
| Posted: Mon Nov 12, 2018 5:59 pm Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
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.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| hughson |
| Posted: Mon Nov 12, 2018 7:42 pm Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
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 |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
