| Author |
Message
|
| broker_new |
 Posted: Fri Oct 05, 2012 5:20 am Post subject: WMBv8.0.0.1-> Record and Replay |
 |
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Hi Guys,
I am trying to understand how the record and replay works in new version of message broker. After we set all the dataStore, dataSource and dataDestination ..how would the broker know which table to populate...All we just give in the configurable properties is the schema name...we never mention the table name anywhere....am I missing something? 
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Fri Oct 05, 2012 5:25 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| broker_new |
| Posted: Fri Oct 05, 2012 5:40 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
I am using the oracle database for recording the data.
how would the flow knows or you point the flow to populate which table from the database?
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Oct 05, 2012 5:43 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| broker_new wrote: |
I am using the oracle database for recording the data.
how would the flow knows or you point the flow to populate which table from the database? |
Did you not see this ?
| Quote: |
1. Use the script that is provided with WebSphere Message Broker to create and
configure a database to store your recorded data.
a. Locate the script for your operating system:
v Windows: install_dir\ddl\db2\DataCaptureSchema.sql
v UNIX: install_dir/ddl/db2/DataCaptureSchema.sql
v z/OS® : the JCL script is located in the data set and member
SBIPPROC(BIPRRDB)
install_dir is the location of your WebSphere Message Broker installation.
b. Optional: To specify your own database or schema, customize the provided
DataCaptureSchema script, and save your changes.
If you modify the SQL to specify a particular schema, you must also set the
same schema name in the DataCaptureStore configurable service.
You might also want to edit the script for the following reasons:
v If you have run the script once, and want to run it again, you must drop
the database MBRECORD first. Insert the command drop database
MBRECORD before the line that reads create database MBRECORD.
v The maximum message body size that you can record (after encoding has
taken place) is 5 MB (which is also the default size). You can increase this
size by editing the script to make the value in the
WMB_BINARY_DATA.DATA column larger. |
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Oct 05, 2012 5:49 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Where is it documented that you get to choose the names of the tables in question? |
|
| Back to top |
|
|
| broker_new |
| Posted: Fri Oct 05, 2012 5:52 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
I understand all of it and was able to implement it using an example from the developer works...everything looks perfect..
I am interested in knowing where the link is created from the flow to the specific tables "WMB_MSGS", "WMB_EVENT_TYPES".........
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Oct 05, 2012 6:07 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| broker_new wrote: |
I understand all of it and was able to implement it using an example from the developer works...everything looks perfect..
I am interested in knowing where the link is created from the flow to the specific tables "WMB_MSGS", "WMB_EVENT_TYPES"......... |
You can create any table names you want. Set Triggers on the WMB tables and point the Triggers to any of your own tables.
You could also create a view with your own names. Talk with your DBA, he or she could help you with this.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| broker_new |
| Posted: Fri Oct 05, 2012 6:29 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
I would like to here from the experts..as a developer i would like to understand where exactly the flow is mapped to the tables created for record and replay...in other words..where we specify in the flow or any configuration that we need to use the specific tables.
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Oct 05, 2012 6:36 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The flow is NOT mapped to tables.
You configure the flow for monitoring, this creates monitoring events. Those events are captured by the record and replay manager in the background, which then writes them into the database, mapping the contents of the message into tables.
http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/topic/com.ibm.etools.mft.doc/bj23700_.htm
This includes information that identifies the specific flow, because monitoring events include specific information that identifies the flow the event relates to. |
|
| Back to top |
|
|
|
|
