| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Record and replay support for other databases |
« View previous topic :: View next topic » |
| Author |
Message
|
| petervh1 |
 Posted: Fri Oct 04, 2013 4:17 am Post subject: Record and replay support for other databases |
 |
|
Centurion
Joined: 19 Apr 2010
Posts: 135
|
Can someone clear up a confusing point regarding Record and Replay functionality in WMB V8.0.0.2?
The IBM documentation says that only DB2 and Oracle databases are supported. However I have just read a transcript at ftp://ftp.software.ibm.com/software/integration/wbimessagebroker/wmb-transcript.pdf that indicates (for a customer) that "any of our supported databases can be used, such as Oracle, SQL Server, and DB2".
Is SQL Server officially supported as a database for Record and Replay?
TIA |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Fri Oct 04, 2013 4:37 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You'll need to open a PMR to find out what is and is not supported in this area, alas.
Also, you'll want to open a PMR and get an iFix for an APAR....
http://www.mqseries.net/phpBB2/viewtopic.php?t=65436
And you need to modify the supplied scripts for Db2 and Oracle to work with SQLServer. |
|
| Back to top |
|
|
| gs |
| Posted: Tue Oct 22, 2013 5:16 am Post subject: |
|
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
petervh1,
Did you get an answer from IBM?
Thanks |
|
| Back to top |
|
|
| Simbu |
| Posted: Tue Oct 22, 2013 7:26 am Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
|
| Back to top |
|
|
| gs |
| Posted: Wed Oct 23, 2013 1:34 am Post subject: |
|
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
Great Simbu, voted on it!
I did some playing around yesterday and got it to work with Microsoft SQL Server 2008. Some minor adjustments were needed in the DataCaptureSchema file. It seems to work fine but official script and support from IBM would of course be nice. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Oct 23, 2013 1:39 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| gs wrote: |
Great Simbu, voted on it!
I did some playing around yesterday and got it to work with Microsoft SQL Server 2008. Some minor adjustments were needed in the DataCaptureSchema file. It seems to work fine but official script and support from IBM would of course be nice. |
It works fine until you try to read or replay data, then you need the APAR, unless you didn't use any VARCHAR(MAX) fields, you just set the fields to a very small size. At least, for some versions of SQLServer....
Again, if you want an official statement from IBM, you need to open a PMR and ask for one. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
