| Author |
Message
|
| Cogito-Ergo-Sum |
 Posted: Thu May 19, 2011 3:59 am Post subject: Check the ODBCINI environment variable |
 |
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
I have checked that the ODBCINI variable exists (with env command) and is set to the correct file. I have also checked the .ini file where I am having only one stanza for the DB2 database that I want to work with. I have also verified with mqsicvp that does not report anything out of line.
And yet, I keep getting this error which refers to DataDirect.
What is wrong and how do I fix ? 
Error message:
| Code: |
May 19 17:12:54 host WebSphere Broker v7001[12994]: (HOST.BRKR.default)[4]BIP2322E: Database error: SQL State 'IM002'; Native Error Code '0'; Error Text '[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.'. : HOST.BRKR.9ea86cb8-2e01-0000-0080-ec35aac0b0a5: /build/S700_P/src/DataFlowEngine/ImbOdbc.cpp: 480: ImbOdbcHandle::checkRcInner: :
|
.ini file contents:
| Code: |
[ODBC Data Sources]
WBRKBKDB=IBM DB2 version 9 ODBC Driver
###### Individual data source stanzas #####
# DB2 version 9 stanza
[WBRKBKDB]
Driver=/opt/ibm/db2/V9.7/lib32/libdb2.so
Description=DB2V9DB DB2 ODBC Database
Database=WBRKBKDB
[ODBC]
# To turn on ODBC trace set Trace=1
Trace=0
TraceOptions=3
TraceFile=/var/mqm/trace/odbctrace32.out
TraceDll=/opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/odbctrac.so
InstallDir=/opt/ibm/mqsi/6.1/ODBC32/V5.3
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8
|
_________________
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 May 19, 2011 4:18 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Well, there is a discrepency here.
| Quote: |
| WebSphere Broker v7001 |
| Quote: |
| /opt/ibm/mqsi/6.1/ |
And I believe that this is the wrong driver as well
| Quote: |
| Driver=/opt/ibm/db2/V9.7/lib32/libdb2.so |
And remember that Broker v7 doesn't need a database for it's own use. |
|
| Back to top |
|
|
| Cogito-Ergo-Sum |
| Posted: Thu May 19, 2011 4:48 am Post subject: |
|
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
I changed the references of 6.1 to 7.0. And, as per this link, the DB2 driver name seems to be valid. But, the problem remains.
_________________
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 May 19, 2011 4:54 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Cogito-Ergo-Sum wrote: |
| And, as per this link, the DB2 driver name seems to be valid. But, the problem remains. |
That page appears to conflict with this one which specifies "DRIVER=libdb2Wrapper.so" in all cases. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu May 19, 2011 7:28 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
As well please check the environment and let us know the value of the ODBCINI variable.
like in echo $ODBCINI or echo %ODBCINI% 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Cogito-Ergo-Sum |
| Posted: Thu May 19, 2011 8:21 am Post subject: |
|
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
The first thing I did was to check for the ODBCINI variable. It is set to the correct file name.
_________________
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 May 19, 2011 8:19 pm Post subject: Solved. |
|
|
Master
Joined: 07 Feb 2006
Posts: 293
Location: Bengaluru, India
|
Had a look into the sample .ini file with a microscope. The view showed a half-wriggly character, a dot above and a curve below, known as Semi Colonus otherwise also known as a semi-colon. This was chiefly found before the familiar Hashus #
I should have used this sample .ini file instead of borrowing it from a pal.
Thanks for your time !
_________________
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 |
|
|
|
|
