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 » WebSphere Message Broker (ACE) Support » what IBM docs list all the values of MQRFH2.psc.??

Post new topic  Reply to topic
 what IBM docs list all the values of MQRFH2.psc.?? « View previous topic :: View next topic » 
Author Message
beth_carlin
PostPosted: Wed Jul 14, 2010 8:56 am    Post subject: what IBM docs list all the values of MQRFH2.psc.?? Reply with quote

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
View user's profile Send private message
lancelotlinc
PostPosted: Wed Jul 14, 2010 9:12 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
smdavies99
PostPosted: Wed Jul 14, 2010 9:58 am    Post subject: Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Wed Jul 14, 2010 10:18 am    Post subject: Re: what IBM docs list all the values of MQRFH2.psc.?? Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Wed Jul 14, 2010 10:23 am    Post subject: Reply with quote

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
View user's profile Send private message
lancelotlinc
PostPosted: Wed Jul 14, 2010 10:38 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Vitor
PostPosted: Wed Jul 14, 2010 10:44 am    Post subject: Reply with quote

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
View user's profile Send private message
beth_carlin
PostPosted: Wed Jul 14, 2010 11:27 am    Post subject: Reply with quote

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
View user's profile Send private message
mqjeff
PostPosted: Wed Jul 14, 2010 12:39 pm    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

You want to read this:
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/aq06950_.htm
Back to top
View user's profile Send private message
beth_carlin
PostPosted: Wed Jul 14, 2010 1:25 pm    Post subject: Reply with quote

Acolyte

Joined: 08 Jun 2004
Posts: 64

mqjeff wrote:
You want to read this:
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/aq06950_.htm



THANK YOU. This is exactly what I need. THANKs again
Back to top
View user's profile Send private message
beth_carlin
PostPosted: Wed Jul 14, 2010 2:01 pm    Post subject: Reply with quote

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
View user's profile Send private message
fjb_saper
PostPosted: Wed Jul 14, 2010 3:53 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
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
View user's profile Send private message Send e-mail
beth_carlin
PostPosted: Wed Jul 14, 2010 7:05 pm    Post subject: Reply with quote

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
View user's profile Send private message
smdavies99
PostPosted: Wed Jul 14, 2010 9:22 pm    Post subject: Reply with quote

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
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 » WebSphere Message Broker (ACE) Support » what IBM docs list all the values of MQRFH2.psc.??
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.