| Author |
Message
|
| sumit |
 Posted: Mon Apr 29, 2013 10:45 pm Post subject: Record and replay tables |
 |
|
Partisan
Joined: 19 Jan 2006
Posts: 398
|
Hi All,
Config
OS: Win XP
WMB: 8.0.0.2
WMQ: 7.0.1.7
We've done necessary setup for Record and Replay as given in Infocenter and the data is coming in the DB tables. I want to capture some unique fields (eg, Order id, transaction id, etc) from the data and want to put that in the DB tables as well. We know that WMB_MSGS table stores the subscribed data but strange enough, there is no information about this and other tables anywhere in infocenter or on IBM site (I think I searched almost everywhere  ). There are few fields like KEY_FLD_1_NM, KEY_FLD_2_NM in the table which currently don't have data and I am wondering if I can use these fields to store the unique values from the event message.
I checked the linkhttp://www.mqseries.net/phpBB2/viewtopic.php?t=61617&highlight=record+replay which says record and replay doesn't/didn't record event payload. May I know this is resolved in v8.0.0.2 or if anyone is able to store the unique details from message (in addition to the whole payload).
Also if some can point me to a link from where I can get information about the DB table and it's fields.
_________________
Regards
Sumit |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Tue Apr 30, 2013 3:14 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| sumit |
| Posted: Wed May 01, 2013 10:14 pm Post subject: |
|
|
Partisan
Joined: 19 Jan 2006
Posts: 398
|
Thanks lancelotlinc. I read the respective sections earlier and then read again. Yet I am not able to find anything related to table definition and significance of the columns.
Also, I don't know why I am not able to see any data in the DB table from the hierarchy which I gave in 'Event Payload' under Monitoring.
_________________
Regards
Sumit |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu May 02, 2013 3:22 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Create a message flow which processes the event messages and creates the data the way you want. In other words, capture and process your own data from the event messages.
IBM makes a product called Message Broker for just that purpose.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu May 02, 2013 3:38 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
That thread you quoted is very old.
Read this |
|
| Back to top |
|
|
| mb8_learner |
| Posted: Mon Jun 30, 2014 10:04 pm Post subject: |
|
|
Novice
Joined: 28 May 2013
Posts: 22
|
| I have added one more column in WMB_MSGS table used in Record and replay scenario. is it possible to make it visible in Web console. Kindly advice.. |
|
| Back to top |
|
|
| manoj5007 |
| Posted: Tue Jul 01, 2014 8:23 am Post subject: |
|
|
Acolyte
Joined: 15 May 2013
Posts: 64
|
Though I havent used Record/Replay in WMB v8, in IIB 9 we can't display any columns added explicitly to the Record/Replay Tables. I have also been trying to get some information on the usage of all the four tables defined in ddl provided with the IIB9. So far no luck.
When it comes to recording data, we can only record the entire exception message or the entire inputBody. We can't record portion of the message. Though under event Payload in event properties we can declare the XPath of the part of message to be recorded, the message doesn't get recorded while it is available in the event message emitted/published.
As per my analysis, the data under binary format and under <ExceptionList> tag in the event message published is inserted into the WMB_BINARY table.
If you want to store unique ids, you can use any of the below three fields:
LocalTransactionId
ParentTransactionId
GlobalTransactionId. |
|
| Back to top |
|
|
|
|
