This blog entry is about a problem that was found recently when monitoring data from "Queue Handle Status".
It may happen that you have a lot of queues and you want to filter them by name, anyway when you do this for queries on table "Queue Handle Status" using "Return a subset of the string" or "Scan for string within a string", no data are returned.
This has been recognized as a code defect and will be fixed in APAR IV83641.
Anyway as a workaround, for a situation or query against this table that wants to use SUBSTR or STRSCN against queue name attribute, just add another OR clause that will NOT match any queues.
For example, to return data for all queues that start with SYSTEM.ADMIN (and when no queues have name 'xxxxx'):
STR(QMQ_HDL_ST.QNAME) == 1,SYSTEM.ADMIN
(QMQ_HDL_ST.QNAME = 'xxxxx')
Subscribe and follow us for all the latest information directly on your social feeds: