| Author |
Message
|
| morpheus |
 Posted: Wed Aug 06, 2003 12:27 pm Post subject: how to create broker on Sun solaris? |
 |
|
Acolyte
Joined: 08 Mar 2003
Posts: 72
Location: Austin, TX
|
Can somebody help me in creating a broker on SunSolaris? I don't have db2 installed on sunsolaris. Thera are already other brokers are running on the same machine. I tried to create broker but its giving database error. I am getting ODBC return code -1.
Is there any chance the old brokers are using any other database other than db2. It's very hard for me to find out because my predecessors didn't leave any documentation. Please help me on this issue.
Thanx in advance
morpheus |
|
| Back to top |
|
 |
| vennela |
| Posted: Wed Aug 06, 2003 12:40 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
If there are already brokers and if DB2 is not installed on that box, then most likely you have DB2 client installed on this box.
I think you have to catalog the DB on this box before creating the broker.
I am sure there is db2 client atleast on this box. If you do a pkginfo then iy might tell you. |
|
| Back to top |
|
|
| morpheus |
| Posted: Wed Aug 06, 2003 1:02 pm Post subject: Thank you |
|
|
Acolyte
Joined: 08 Mar 2003
Posts: 72
Location: Austin, TX
|
Thank you for the quik reply.
Here I have the information from pkginfo | grep db2 command
| Code: |
| application n6idb26 NNSY Database Installation 260 |
Does it mean that I have db2 client on my machine? |
|
| Back to top |
|
|
| JT |
| Posted: Wed Aug 06, 2003 1:13 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Try looking at the .odbc.ini file. There will be an entry in the file that will identify the broker database's driver. The location of the .odbc.ini file can be determined by issuing the SET command and looking at the ODBCINI environment parameter. |
|
| Back to top |
|
|
| morpheus |
| Posted: Wed Aug 06, 2003 1:47 pm Post subject: Thank you |
|
|
Acolyte
Joined: 08 Mar 2003
Posts: 72
Location: Austin, TX
|
Thank you for the info.
I looked in ODBC.ini file. and found
this info.
| Code: |
[ODBC Data Sources]
MQSIBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=MERANT 3.70 Oracle 8 Driver
SYBASEDB=MERANT 3.70 Sybase ASE Driver
MYBRKDSN=MERANT 3.60 Oracle 8 driver
SITBRKDSN=MERANT 3.60 Oracle 8 driver
[MYBRKDSN]
Driver=/opt/wmqi/merant/lib/UKor815.so
Description=Oracle8
ServerName=dws2
EnableDescribeParam=1
OptimizePrepare=1
[SITBRKDSN]
Driver=/opt/wmqi/merant/lib/UKor815.so
Description=Oracle8
ServerName=uws2
EnableDescribeParam=1
OptimizePrepare=1
[MQSIBKDB]
Driver=/u/db2inst1/sqllib/lib/libdb2.so
"/var/wmqi/odbc/.odbc.ini" 57 lines, 1205 characters |
I tried with all the DSN s but I am getting same error. How do I know If the userid I'm passing in the mqsicreatebroker command have authorization to the DSN i am specifying?
and is there is any way we can find out which database the existing broker associated with. |
|
| Back to top |
|
|
| morpheus |
| Posted: Thu Aug 07, 2003 6:00 am Post subject: Thank you |
|
|
Acolyte
Joined: 08 Mar 2003
Posts: 72
Location: Austin, TX
|
Thank you for the suggestions,
I finally figured it out. I used -u option which I didn't see in the manuals.
It worked.
Later
Morpheus |
|
| Back to top |
|
|
|
|
