| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Websphere Message Broker - Default Conf Wizard and DB2 |
« View previous topic :: View next topic » |
| Author |
Message
|
| damientaylor |
 Posted: Mon Sep 01, 2008 4:09 am Post subject: Websphere Message Broker - Default Conf Wizard and DB2 |
 |
|
Newbie
Joined: 29 Aug 2008
Posts: 4
|
Hi All,
I have installed Websphere Message Broker and DB2. First thing I am attempting is to create a default configuration. However it gets to a certain stage and fails when trying to create the database. It is unable to create a database. However I created a database with the same username and password as that for Message Broker and the same username and password as I start the conf wizard with.
Is there a way that I can specify the database source? Can I tell Websphere to use ODBC connection instead?
The log output is as follows:
1/09/2008 21:54:16 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO:
+++++++++++++++++++++++++++++++++++ task trace +++++++++++++++++++++++++++++++++++++++++++++
TIMESTAMP [Mon Sep 01 21:54:16 EST 2008]
1/09/2008 21:54:16 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: Checking for the Default Configuration
1/09/2008 21:54:16 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: The above task succeeded
Collected output from task >
Stdout: [MQSI 6.1.0.2
C:\Program Files\IBM\MQSI\6.1
BIP8071I: Successful command completion.]
Stderr: []
1/09/2008 21:54:22 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO:
+++++++++++++++++++++++++++++++++++ task trace +++++++++++++++++++++++++++++++++++++++++++++
TIMESTAMP [Mon Sep 01 21:54:22 EST 2008]
1/09/2008 21:54:22 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: Verifying that the default queue manager [WBRK61_DEFAULT_QUEUE_MANAGER] does not already exist.
1/09/2008 21:54:22 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: The above task succeeded
Collected output from task >
Stdout: [QMNAME(QM_cpaus_dtaylo) STATUS(Running)]
Stderr: []
1/09/2008 21:54:23 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO:
+++++++++++++++++++++++++++++++++++ task trace +++++++++++++++++++++++++++++++++++++++++++++
TIMESTAMP [Mon Sep 01 21:54:23 EST 2008]
1/09/2008 21:54:23 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: Verifying that the default broker [WBRK61_DEFAULT_BROKER] does not already exist.
1/09/2008 21:54:23 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: The above task succeeded
Collected output from task >
Stdout: [MQSI 6.1.0.2
C:\Program Files\IBM\MQSI\6.1
BIP8013E: Component does not exist.
A component may only be used if it has first been created.
No user action required.]
Stderr: []
1/09/2008 21:54:26 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO:
+++++++++++++++++++++++++++++++++++ task trace +++++++++++++++++++++++++++++++++++++++++++++
TIMESTAMP [Mon Sep 01 21:54:26 EST 2008]
1/09/2008 21:54:26 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: Verifying that the default broker database [DEFBKD61] does not already exist.
1/09/2008 21:54:26 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: The above task succeeded
Collected output from task >
Stdout: [C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.etools.mft.eou.win32_6.1.0.v20071108_1112>db2 start database manager
DB20000I The START DATABASE MANAGER command completed successfully.
C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.etools.mft.eou.win32_6.1.0.v20071108_1112>echo off
C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.etools.mft.eou.win32_6.1.0.v20071108_1112>db2 terminate
DB20000I The TERMINATE command completed successfully.
C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.etools.mft.eou.win32_6.1.0.v20071108_1112>echo off
C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.etools.mft.eou.win32_6.1.0.v20071108_1112>db2 list database directory
System Database Directory
Number of entries in the directory = 2
Database 1 entry:
Database alias = DAMIEN
Database name = DAMIEN
Node name = DAMIEN
Database release level = a.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
Database 2 entry:
Database alias = CIDS
Database name = CIDS
Node name = TCP103B0
Database release level = a.00
Comment = CIDS
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.etools.mft.eou.win32_6.1.0.v20071108_1112>echo off]
Stderr: []
1/09/2008 21:54:27 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO:
+++++++++++++++++++++++++++++++++++ task trace +++++++++++++++++++++++++++++++++++++++++++++
TIMESTAMP [Mon Sep 01 21:54:27 EST 2008]
1/09/2008 21:54:27 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: Verifying that the default Configuration Manager [WBRK61_DEFAULT_CONFIGURATION_MANAGER] does not already exist.
1/09/2008 21:54:27 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: The above task succeeded
Collected output from task >
Stdout: [MQSI 6.1.0.2
C:\Program Files\IBM\MQSI\6.1
BIP8013E: Component does not exist.
A component may only be used if it has first been created.
No user action required.]
Stderr: []
1/09/2008 21:54:27 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO:
+++++++++++++++++++++++++++++++++++ task trace +++++++++++++++++++++++++++++++++++++++++++++
TIMESTAMP [Mon Sep 01 21:54:27 EST 2008]
1/09/2008 21:54:27 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: Verifying that the local domain connection file does not already exist.
1/09/2008 21:54:27 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: The above task succeeded
Collected output from task >
Stdout: []
Stderr: []
1/09/2008 21:54:29 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO:
+++++++++++++++++++++++++++++++++++ task trace +++++++++++++++++++++++++++++++++++++++++++++
TIMESTAMP [Mon Sep 01 21:54:29 EST 2008]
1/09/2008 21:54:29 com.ibm.etools.mft.eou.wizards.EouWizard logAction
INFO: Creating the database [DEFBKD61] for the default broker.
1/09/2008 21:54:29 com.ibm.etools.mft.eou.wizards.EouWizard logAction
SEVERE: Could not create the database.
Collected output from task >
Stdout: [MQSI 6.1.0.2
C:\Program Files\IBM\MQSI\6.1
C:\Program Files\IBM\WMBT610>CALL mqsicreatedb DEFBKD61 -i dtaylo -a ***********
BIP9801I: No supported database product found.
The requested database was not created because a supported database product could not be found.
Please check your database product installation. |
|
| Back to top |
|
 |
| ranganathan |
| Posted: Mon Sep 01, 2008 4:36 am Post subject: |
|
|
Centurion
Joined: 03 Jul 2008
Posts: 104
|
If you have installed DB2.. check the following
1. Check if the DB2 is running
2. Try to create DB from the DB2 command window / DB2 Control center.
what about WebSphere MQ ?! Have you installed it ? |
|
| Back to top |
|
|
| damientaylor |
| Posted: Mon Sep 01, 2008 9:12 pm Post subject: |
|
|
Newbie
Joined: 29 Aug 2008
Posts: 4
|
Hi Ranganathan,
Yes, DB2 is certainly running as I can access them through WinSQL client (which is an ODBC based SQL Editor). The task manager also tells me that it is running. I was also successful at creating database and table. So yes DB2 is running.
I am not sure that I have MQ Broker running, I am not sure how to test. I thought that this was the reason for going through the "create a default configuration" wizard, so as to set up a MQ Broker connection? Is this correct? A tutorial told me that I has to do this first? And it is this wizard that keeps telling me that "No supported database product found.".
Thanks,
Damien |
|
| Back to top |
|
|
| damientaylor |
| Posted: Mon Sep 01, 2008 9:36 pm Post subject: |
|
|
Newbie
Joined: 29 Aug 2008
Posts: 4
|
| In Addition, I should also mention that I am able to create a database definition via File->New->Database Definition! And it works! So why can I create a connection to the database via one wizard, but not be found in another wizard for the same application (Create the Default Configuration)? |
|
| Back to top |
|
|
| ranganathan |
| Posted: Tue Sep 02, 2008 1:13 am Post subject: |
|
|
Centurion
Joined: 03 Jul 2008
Posts: 104
|
| damientaylor wrote: |
| In Addition, I should also mention that I am able to create a database definition via File->New->Database Definition! And it works! So why can I create a connection to the database via one wizard, but not be found in another wizard for the same application (Create the Default Configuration)? |
Damien,
I dont understand what exactly you mean by MQBroker ?! Did you mean the connectivity between MQ and MB ?!
Just to highlight.. WebSphere MQ and WebSphere Message Broker (WBIMB) are different products. Message Broker uses MQ as a mode of transport. The default configuration of Message Broker will work, only if you install all the following...
1. WebSphere Message Broker
2. Any Supported Database product (ex: DB2)
3. WebSphere MQ
Have you installed all of the above ?! As you said DB2 is installed in your machine.. has your database user been added in the 'mqbrkrs' group ?
Links:
http://www-01.ibm.com/software/integration/wbimessagebroker/
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp - Take the quick tour in this link it is very informative...
Hope this helps..  |
|
| 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
|
|
|
|
