| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [SOLVED] Broker v6.1 on z/Linux working with DB2 on z/OS |
« View previous topic :: View next topic » |
| Author |
Message
|
| alechko |
 Posted: Tue Sep 16, 2008 2:44 am Post subject: [SOLVED] Broker v6.1 on z/Linux working with DB2 on z/OS |
 |
|
Apprentice
Joined: 12 Jan 2005
Posts: 37
|
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Sep 16, 2008 3:30 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| mqsicreatebroker will create the tables and the tablespaces and everything the broker needs, inside the datasource you have configured and passed to mqsicreatebroker. |
|
| Back to top |
|
|
| alechko |
| Posted: Tue Sep 16, 2008 10:19 pm Post subject: |
|
|
Apprentice
Joined: 12 Jan 2005
Posts: 37
|
I'm not sure you are correct regarding using a remote DB2 on z/OS.
In a "regular" configuration, when using oracle or db2 udb, the mqsicreatebroker command creates the tables.
Even when installing the broker entirely in z/OS environment, you have to first submit the job BIPCRDB to create a database, storage group and the tablespaces.
Afterwards, the job BIPCRBK (mqsicreatebroker in z/OS) creates tables inside the tablespaces created before.
I'm pessimistic that mqsicreatebroker in a non z/OS environment will create all the objects needed in the z/OS DB2. How would it know which objects to define? which tablespace sizes? bufferpools? etc ...
I think that the way to create this configuration is using BIPCRBK (mqsicreatebroker) in z/OS with the option -3 which will only create the tables without creating the broker. The problem is that you need the WMB product installed in z/OS which is not my case.
What I'm considering to do, is to create the default configuration broker in linux/windows environment, export all the tables created as DDL statements, modify the commands and execute them in the z/OS DB2.
Any opinions?
Does anyone have any experience working with such configuration?
Thanks,
Alik |
|
| Back to top |
|
|
| jsquibb |
| Posted: Wed Sep 17, 2008 12:17 am Post subject: Broker v6.1 on z/Linux working with DB2 on z/OS |
|
|
Newbie
Joined: 16 Sep 2008
Posts: 2
|
Apologies for any confusion that you have had regarding this matter - I probably should have made the following explicit in my DeveloperWorks article.
WebSphere Message Broker on z/Linux is able to access DB2 on z/OS but only for user data. You are not able to host the broker tables for a non-z/OS broker in DB2 on z/OS.
In summary, you can access user tables in a remote z/OS DB2 in your message flows but you must have a non-z/OS DB2 (or other supported) database for the broker tables, which would typically reside locally on the z/Linux system. |
|
| Back to top |
|
|
| jsquibb |
| Posted: Wed Sep 17, 2008 12:19 am Post subject: Broker v6.1 on z/Linux working with DB2 on z/OS |
|
|
Newbie
Joined: 16 Sep 2008
Posts: 2
|
|
| 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
|
|
|
|
