| Author |
Message
|
| Cogito-Ergo-Sum |
 Posted: Thu Jan 27, 2011 8:21 am Post subject: WinXP : Unable to create database. |
 |
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
Whenever I run mqsicreatedb, I get a message as 'No supported database product found.'. Though, I am having C:\Program Files\IBM\SQLLIB_01\BIN in PATH. I get the same message even if I want to create a Derby database.
Where should I start looking to solve this problem ?
_________________
ALL opinions are welcome.
-----------------------------
Debugging tip:When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
---Sherlock Holmes |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Jan 27, 2011 8:41 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| You installed DB2 from the broker runtime disks? |
|
| Back to top |
|
|
| Cogito-Ergo-Sum |
| Posted: Thu Jan 27, 2011 7:46 pm Post subject: |
|
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
No. DB2 was installed before.
_________________
ALL opinions are welcome.
-----------------------------
Debugging tip:When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
---Sherlock Holmes |
|
| Back to top |
|
|
| Cogito-Ergo-Sum |
| Posted: Thu Jan 27, 2011 10:39 pm Post subject: |
|
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
I think this APAR is close to our problem. Hopefully, we will resolve it following the link.
_________________
ALL opinions are welcome.
-----------------------------
Debugging tip:When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
---Sherlock Holmes |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Jan 28, 2011 12:51 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Whenever I've had DB2 Installed (not just the runtime bits) and I'm going to use it with Broker then I've always created the DB first using either a script of the control centre 'db2cc'. Then I've created the ODBC DSN as normal.
Apart from creating the default configuration, I can't remember when (if ever) the last time I used mqsicreatedb.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Cogito-Ergo-Sum |
| Posted: Fri Jan 28, 2011 3:19 am Post subject: |
|
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
Yes, I was thinking of creating the db without using mqsicreatedb. I was thinking that this command will also create the broker specific tables also. Now, I have gone through the documentation where I do not see reference to creation of broker specific tables.
_________________
ALL opinions are welcome.
-----------------------------
Debugging tip:When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
---Sherlock Holmes |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Jan 28, 2011 3:52 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
The Broker specific Tables are created by the mqsicreatebroker command (If they don't exist that is...)
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Cogito-Ergo-Sum |
| Posted: Fri Jan 28, 2011 3:55 am Post subject: |
|
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
| Quote: |
| The Broker specific Tables are created by the mqsicreatebroker command (If they don't exist that is...) |
ah, yes. Thanks !
_________________
ALL opinions are welcome.
-----------------------------
Debugging tip:When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
---Sherlock Holmes |
|
| Back to top |
|
|
|
|
