| Author |
Message
|
| harshvajra |
 Posted: Wed Aug 29, 2007 1:34 am Post subject: Broker database on Unix/AIX platform |
 |
|
Apprentice
Joined: 23 Apr 2007
Posts: 46
Location: India
|
Hi all,
We have db2 v9.1 database,mq v6.0 and mb v6.0.0.1 installed on aix box. Now to create runtime components, the broker needs a database right !
My doubt is whether db2 v9.1 is supported ?.
If yes then how to create database for the broker using mqsi ?
When i checked the help documents theres no option where we can create db using mqsi command.
Now do i have to do anything else prior to asking these questions ?
Any suggestions would be af help to me.
_________________
Failure is not a defeat,it's just a delay, Walk TALL |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Aug 29, 2007 1:39 am Post subject: Re: Broker database on Unix/AIX platform |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| harshvajra wrote: |
| My doubt is whether db2 v9.1 is supported ?. |
Is it on the list of supported broker databases?
| harshvajra wrote: |
If yes then how to create database for the broker using mqsi ?
|
Given the broker is using an ODBC connection to the database (which implies the database already exists because you've tested the connection) why should it have such a facility?
| harshvajra wrote: |
Now do i have to do anything else prior to asking these questions ?
Any suggestions would be af help to me. |
More time with the documentation, especially the system administration manual, would appear to be a good idea.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| harshvajra |
| Posted: Wed Aug 29, 2007 2:22 am Post subject: |
|
|
Apprentice
Joined: 23 Apr 2007
Posts: 46
Location: India
|
Hello
Yes, it's clearly specified in the online documentation,the supported databases and their versions as :
O/S DB2
AIX 8.23,9.13+4
And it says "You must install WebSphere MQ Version 6.0.2.0 or later if you want to use DB2 Version 9.1. JDBC/XA is not supported with this database releas".
And the version we have is : 6.0.0.0
now can we conclude that the version are not compatable.
_________________
Failure is not a defeat,it's just a delay, Walk TALL |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Aug 29, 2007 2:35 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
For reasons discussed at length in the forum, it's not good advice to run MQ v6.0.0.0 at any time.
You should apply maintenance.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 29, 2007 2:56 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You should also be running at least 6.0.0.3 of MB, and not 6.0.0.1.
So apply maintenance to that, too.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| harshvajra |
| Posted: Wed Aug 29, 2007 3:03 am Post subject: |
|
|
Apprentice
Joined: 23 Apr 2007
Posts: 46
Location: India
|
Hi,
I beleive it'll take some time for me to understand why we should not prefer mq v6.0.0.0.
Okay even if i have the compatable version installed on the box(AIX),
there is a procedure to create database on unix platform.
The doc's says, for windows we can create directly a broker database using "mqsicreatedb".
But for unix/linux platform
the procedure goes like this:
Prepare setup database on unix "mqsi_setupdatabase db_type db_inst-dir"
and then followed by creating a databse instance using root priviledge
and then create database.
Would anyone helpme understand why is not the same for unix/linux platform.
_________________
Failure is not a defeat,it's just a delay, Walk TALL |
|
| Back to top |
|
|
| harshvajra |
| Posted: Wed Aug 29, 2007 3:06 am Post subject: |
|
|
Apprentice
Joined: 23 Apr 2007
Posts: 46
Location: India
|
Okay, as said for mq it good to prefer v 6.0.2.0 and mb v 6.0.0.3.
and what about the database version and any fixpacks ?
_________________
Failure is not a defeat,it's just a delay, Walk TALL |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Aug 29, 2007 3:07 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| harshvajra wrote: |
I beleive it'll take some time for me to understand why we should not prefer mq v6.0.0.0.
|
It'll take 5 mins with the search button. Short version - it's not that stable.
| harshvajra wrote: |
Would anyone helpme understand why is not the same for unix/linux platform. |
Because mqsicreatedb creates the internal Derby databases, only available on Windows. It doesn't create DB2 databases for you.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 29, 2007 3:08 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
MQ v6.0.0.0 is about two years old.
As you've already noted, it's also not supported for use with Broker with the version of DB2 you want to use.
Refresh/Fix packs are free, and simple to install. There's absolutely no reason not to install the latest one when making a new installation.
You don't need to use mqsi_setupdatabase if you are not using Oracle.
The documentation is specific about why it's different on Windows than on Unix. It says "There is no GUI for creating ODBC data sources" or some such.
Given that every single other thing is different about Unix and Windows, it seems odd to be surprised about this.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
