| Author |
Message
|
| beth_carlin |
 Posted: Wed Jul 14, 2010 8:56 am Post subject: what IBM docs list all the values of MQRFH2.psc.?? |
 |
|
Acolyte
Joined: 08 Jun 2004
Posts: 64
|
Hello
I am refering to this link:
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp?
topic=/com.ibm.etools.mft.doc/ac16910_.htm
Could you please tell me what IBM documents that list ALL the values of
MQRFH2.psc.??
MQRFH2.psc.??
MQRFH2.psc.
MQRFH2.psc.
MQRFH2.psc.
and ALL values of its children and grandchildren
SET OutputRoot.MQRFH2.psc.Command = 'RegSub';
for example
what are all the possible values for psc.Command and is there a value to
unregister/unsubscribe ?
THANKs for helping |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Wed Jul 14, 2010 9:12 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Quote: |
| Could you please tell me what IBM documents that list ALL the values... |
IMHO, IBM docs talk about concepts and are not intended to be comprehensive listings. As things change from version to version, the commands change also, which would render lists of command out of date pretty quickly. Therefore, rather than comprehensively list every little detail, IBM docs provide a general principle and leave the programmer the task of looking at source code, source examples, and discussion groups to come up with something that works.
That being said, there is growing frustration in the non-IBM employee developer community for lack of comprehensive docs. The tricks of the trade are what bring value to the product through consulting engagements.
The answer you will likely get here based on how you asked your question is: what have you tried, what doesn't work, post your source code, post your logs. This is reasonable given the current state, as my commentary above states. For the moderators, please read my commentary in a positive light. It is not a critique in any way. It is an observation of the state of affairs. Some marketers would consider it a barrier-to-entry for competing products. In that light, its a brilliant strategy.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jul 14, 2010 9:58 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
As we are dealing with WMQ here rather than Broker alone, I'd head for the WMQ documentation, especially those about Pub/Sub.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 14, 2010 10:18 am Post subject: Re: what IBM docs list all the values of MQRFH2.psc.?? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| beth_carlin wrote: |
| Could you please tell me what IBM documents that list ALL the values of and ALL values of its children and grandchildren |
I think you want this
| beth_carlin wrote: |
what are all the possible values for psc.Command and is there a value to
unregister/unsubscribe ? |
That link appears to be the list, & I believe you're looking for "deregister subscriber"
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 14, 2010 10:23 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| IMHO, IBM docs talk about concepts and are not intended to be comprehensive listings. |
Some docs are; some (like the APR) are comprehensive.
| lancelotlinc wrote: |
| As things change from version to version, the commands change also, which would render lists of command out of date pretty quickly. |
And the docs are revised for each version. Though I'm the first to admit the occassional error creeps in.
| lancelotlinc wrote: |
| Therefore, rather than comprehensively list every little detail, IBM docs provide a general principle and leave the programmer the task of looking at source code, source examples, and discussion groups to come up with something that works. |
No they don't.
| lancelotlinc wrote: |
| That being said, there is growing frustration in the non-IBM employee developer community for lack of comprehensive docs. The tricks of the trade are what bring value to the product through consulting engagements. |
As a member of the community you describe, I'm not frustrated & find the docs which are intended to be comprehensive to be so.
| lancelotlinc wrote: |
| The answer you will likely get here based on how you asked your question is: what have you tried, what doesn't work, post your source code, post your logs. |
Wrong! 
| lancelotlinc wrote: |
| It is not a critique in any way. |
I'd enjoy reading a critique of yours then! 
| lancelotlinc wrote: |
| It is an observation of the state of affairs. Some marketers would consider it a barrier-to-entry for competing products. In that light, its a brilliant strategy. |
How does the quality of documentation provide a barrier to entry? Surely dubious docs put off prospective clients and assist compeditors.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 14, 2010 10:38 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
@Vitor:
The balance between short, concise commentary and getting a solid point across without offending anyone is very challenging to say the least.
First let me heap praise on WebSphere MQ, WebSphere Message Broker, WebSphere Transformation Extender and the people that support these products. By light years, these are superior products in this market niche and are very well supported through WORLD CLASS technical support with feet on-the-ground in all world continents. In my 30 years of IT experience, I have never received such excellent support from a product support team as I have with these products. period. bar none.
| Quote: |
How does the quality of documentation provide a barrier to entry? Surely dubious docs put off prospective clients and assist compeditors.
|
I would highly recommend a good book to read, that may bring new thinking and new concepts to help you see why I reference the marketing strategy the way I did. In fact, if you PM me, I'll Amazon it to your door-step on my dime.
http://en.wikipedia.org/wiki/Crossing_the_Chasm
As more deeper discussion is needed, maybe we continue our conversation in the General Discussion forum. Feel free to start a thread, and I will reply.
Lance
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 14, 2010 10:44 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| The balance between short, concise commentary and getting a solid point across without offending anyone is very challenging to say the least. |
Certainly something I usually fail to achieve.
| lancelotlinc wrote: |
| First let me heap praise on WebSphere MQ, WebSphere Message Broker, WebSphere Transformation Extender and the people that support these products. By light years, these are superior products in this market niche and are very well supported through WORLD CLASS technical support with feet on-the-ground in all world continents. In my 30 years of IT experience, I have never received such excellent support from a product support team as I have with these products. period. bar none. |
You also seem to have more luck with PMRs than I do.
| lancelotlinc wrote: |
| I'll Amazon it to your door-step on my dime. |
It's a kind offer, but I must decline.
| lancelotlinc wrote: |
| As more deeper discussion is needed, maybe we continue our conversation in the General Discussion forum. Feel free to start a thread, and I will reply. |
I'll read the book first. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| beth_carlin |
| Posted: Wed Jul 14, 2010 11:27 am Post subject: |
|
|
Acolyte
Joined: 08 Jun 2004
Posts: 64
|
| smdavies99 wrote: |
| As we are dealing with WMQ here rather than Broker alone, I'd head for the WMQ documentation, especially those about Pub/Sub. |
Thanks you for your response.
I am writing a WMB V6 pubsub msgflow to register and unregister large number of topics and queue due to the limitation of the gui rhfutil tool V42 allowing a maximum of 3 topics at a time.
I believe this line of code is the pubsub 'register' func from the above link I posted
set OutputRoot.MQRFH2.psc.Command='RegSub';
I tried to look for other IBM docs in this link
http://www-01.ibm.com/software/integration/wbimessagebroker/library/6.0/books.html
especially the ESQL PDF but the link IBM posted for this ESQL is no good
ftp://ftp.software.ibm.com/software/integration/wbibrokers/docs/V6.0/messagebroker_ESQL.pdf
In IBM RAS or RAD, the tool can tell me the children field (data and/or method) of the object by me doing the control + space right after the object name. For example
MQMessage message = new MQMessage();
...
message.characterSet = 1208;
If I don't know the field name 'characterSet', all I need to do is to position the cursor after the dot '.' then press control + space, RAD or RAS will list all the (children ) fields.
The same cannot be said for WMB toolkit which I understand is not an IDE.
My questions are:
1) If I want to unsubscribe/unregister a topic, what command value for xxxx should I use
set OutputRoot.MQRFH2.psc.Command='xxxx';
2) I'd like to add a description to the topic I register, what field after psc should I use
MQRFH2.psc.????
Sorry to bother you with these questions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jul 14, 2010 12:39 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| beth_carlin |
| Posted: Wed Jul 14, 2010 1:25 pm Post subject: |
|
|
Acolyte
Joined: 08 Jun 2004
Posts: 64
|
THANK YOU. This is exactly what I need. THANKs again |
|
| Back to top |
|
|
| beth_carlin |
| Posted: Wed Jul 14, 2010 2:01 pm Post subject: |
|
|
Acolyte
Joined: 08 Jun 2004
Posts: 64
|
Hello
I'd like to ask one more question:
I register succesfully a topic-> queue and the data flows to the subscriber queue correctly
using this format per your recommended link
<psc>
<Command>RegSub</Command>
<Topic>app/test/testtopic</Topic>
<QMgrName>devqmgr</QMgrName>
<QName>testq</QName>
<SubUserData>testtopic is for application xyz,site abc</SubUserData>
</psc>
what I'd like to know is in what table and what col is the content of <SubUserData>
stored? bez I plan to use this field later on for some other purposes so I have
to query it from the broker database
If if use this command
mqsibrowse brkdev -t BSUBSCRIPTIONS
it will return readable information about topic named 'testtopic' but WITHOUT the <SubUserData>
If is bring up wmb toolkit, and look at the 'testtopic', wmb toolkit does not list
<SubUserData> as one of the returned cols
WMB toolkit will returns readable values for the following cols:Topic, user, broker,
subscription point, registration date, clien(queue name) and content filter |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Jul 14, 2010 3:53 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
We are keeping the information in a spreadsheet under version control
- spreadsheet --> file name with data to load to rfhutilc --> topic and subscription queue
-- RFHUtilc loads an xml document that the flow(a) does a global publish on
-- a subscriber flow(b) then puts in a local subscription for each broker...
The subscription flow sends a Request message with reply to queue.
In the reply to queue you will then find a message with full reply from the broker specifying the result of the subscription (success, failure with error code) (psr folder in RFHUtil).
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| beth_carlin |
| Posted: Wed Jul 14, 2010 7:05 pm Post subject: |
|
|
Acolyte
Joined: 08 Jun 2004
Posts: 64
|
| beth_carlin wrote: |
Hello
I'd like to ask one more question:
I register succesfully a topic-> queue and the data flows to the subscriber queue correctly
using this format per your recommended link
<psc>
<Command>RegSub</Command>
<Topic>app/test/testtopic</Topic>
<QMgrName>devqmgr</QMgrName>
<QName>testq</QName>
<SubUserData>testtopic is for application xyz,site abc</SubUserData>
</psc>
what I'd like to know is in what table and what col is the content of <SubUserData>
stored? bez I plan to use this field later on for some other purposes so I have
to query it from the broker database
If if use this command
mqsibrowse brkdev -t BSUBSCRIPTIONS
it will return readable information about topic named 'testtopic' but WITHOUT the <SubUserData>
If is bring up wmb toolkit, and look at the 'testtopic', wmb toolkit does not list
<SubUserData> as one of the returned cols
WMB toolkit will returns readable values for the following cols:Topic, user, broker,
subscription point, registration date, clien(queue name) and content filter |
Hi
I did some more research but still gets stuck. I appreciate any help I can get.
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/aq06950_.htm
and the IBM doc says that
<SubUserData> (MQPSC_SUBSCRIPTION_USER_DATA)
This is a variable-length text string. The value is stored by the broker with the subscription, but has no influence on publication delivery to the subscriber. The value can be altered by re-registering to the same subscription with a new value. This attribute is there for the use of the application.
The SubUserData is returned in the Metatopic information (MQCACF_REG_SUB_USER_DATA) for a subscription if present.
I look at the db2 table BSUBSCRIPTIONs
> db2 describe table BSUBSCRIPTIONS
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- -
-----
BROKERUUID SYSIBM CHARACTER 16 0 No
CLIENTID SYSIBM VARCHAR 254 0 No
SUBSCRIPTIONID SYSIBM CHARACTER 60 0 No
TOPIC SYSIBM BLOB 1073741824 0 Yes
SUBPOINT SYSIBM VARCHAR 128 0 Yes
FILTER SYSIBM BLOB 1073741824 0 Yes
EXPIRATION SYSIBM CHARACTER 38 0 Yes
CREATION SYSIBM CHARACTER 38 0 Yes
OPTIONS SYSIBM INTEGER 4 0 Yes
SUBINFO SYSIBM BLOB 1073741824 0 Yes
I can see the topic 'testtopic' in table BSUBSCRIPTIONs
db2 "select * from BSUBSCRIPTIONS where varchar(TOPIC)='testtopic' "
and it returns the topic correctly
at first I suspect SubUserData might map to SUBINFO (blob)
but
db2 "select * from BSUBSCRIPTIONS where varchar(subinfo) = 'testtopic is for application xyz,site abc' "
returns nothing
so I still don't know what SubUserData maps to what column in what table ?
THANKs |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jul 14, 2010 9:22 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Look at the data types for the fields you are selecting on.
You are supplying a string to search for a match on a blob column.
That is why a select * works.
Remember this all changes for V7 and WMQ does it all.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
