| Author |
Message
|
| venuprsd |
 Posted: Mon Dec 31, 2012 9:59 am Post subject: BIP8146E: Unable to retrieve the SQL primitives supported by |
 |
|
Apprentice
Joined: 15 Aug 2010
Posts: 44
|
Hi Experts,
Plz plz help me..i am getting below problem while creating broker
============
mqsicreatebroker BRK_01 -i mqm -a mid@345 -q BRK01 -n BRKDB -u dbid -p xxxxx
AMQ8110: WebSphere MQ queue manager already exists.
WebSphere MQ queue manager running.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
BIP8146E: Unable to retrieve the SQL primitives supported by the Database.
The command attempted to retrieve the SQL primitives that the Database supports, however the primitives retrieved indicate that the Database could not be contacted successfully. Refer to the Administration Guide for information about Database setup, ensure that the Database libraries are available in the library path and that the ODBC ini file is correct.
Correct the problem and retry the command.
========
OS: Linux
MQSI 6.1.0.3
/opt/ibm/mqsi/6.1 |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Dec 31, 2012 10:19 am Post subject: Re: BIP8146E: Unable to retrieve the SQL primitives supporte |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| venuprsd wrote: |
| Plz plz help me.. |
Well...
| venuprsd wrote: |
| Refer to the Administration Guide for information about Database setup, ensure that the Database libraries are available in the library path and that the ODBC ini file is correct. |
Sounds like good advice to me.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| venuprsd |
| Posted: Mon Dec 31, 2012 10:29 am Post subject: |
|
|
Apprentice
Joined: 15 Aug 2010
Posts: 44
|
| where is the exact problem?plz help me on this..i am having pressure |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Dec 31, 2012 10:40 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
6.1.0.3 is very old version. There are many bug fixes to that version as of 6.1.0.11.
Why not you update your runtime to modern version while you read the Administrator's guide ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Dec 31, 2012 10:51 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| venuprsd wrote: |
| where is the exact problem? |
How can we know? We know nothing of your system or configuration except that the database connection is hosed up. You're the one with all the information.
| venuprsd wrote: |
| plz help me on this.. |
How do you suggest we do that? You've said nothing about your system or even the circumstances of the error except that you're trying to create a broker. Is this on a box already hosting a broker, a database server that hosts broker, an entirely new set up, what? What have you done to diagnose the problem apart from post here and fold your arms waiting for spoonfed advice?
| venuprsd wrote: |
| i am having pressure |
Welcome to the world of work. Enjoy your stay.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| venuprsd |
| Posted: Mon Dec 31, 2012 10:52 am Post subject: |
|
|
Apprentice
Joined: 15 Aug 2010
Posts: 44
|
But jedi sir,
we have 6.1.0.2 in other server in linux..there its working fine....same environment here also we established.but while creating broker getting the error... |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Dec 31, 2012 11:03 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| venuprsd wrote: |
| same environment here also we established.but while creating broker getting the error... |
Well thank you for the information. At last.
I don't see how you can say this is the same environment as:
a) this environment (you claim) is 6.1.0.3 & the other environment (you claim) is 6.1.0.2
b) the other environments can connect to the database & create brokers where this one can.
So there are 2 places for you to start looking for the problem.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
