| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| NNSY Database connection issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| heath |
 Posted: Thu Dec 30, 2004 4:26 pm Post subject: NNSY Database connection issue |
 |
|
Novice
Joined: 12 Jan 2004
Posts: 21
Location: Chicago, IL
|
Hi Guys, I am testing my setup currently by putting in test messages and I am having an issue with the NEON part. I get the following error in the NNSYMessageLog.nml file:
| Code: |
20041230235248101Z|DB Old Session Base|27583|11|Database Session|NNOT_EC_NATIVE_API_ERROR|Unknown||A database API call failed.
File: NNSesDB2.cpp
Line: 201
Call: SQLConnect
Code: IM002
Text: [DataDirect][ODBC lib] Data source name not found and no default driver specified
20041230235248142Z|DB Old Session Base|27583|11|Kernel|NNOT_EC_SES_ACCESS|Unknown||File: /home/src/ccm_wa/eng_dev/DBTIL~DB_2.6_3
4/DBTIL/ses/db/odbc/NNSesODBC.cpp
Line: 224
Session access failed.
20041230235248144Z|DB Old Session Base|27583|11|INFR|INFR|Info||Ending process.
|
Also here are the various NNSY related environment variables I have set in my environmet:
| Code: |
ODBCINI=/var/wmqi/odbc/.odbc.ini
export NNSY_ROOT=/opt/nnsy
export SHLIB_PATH=$SHLIB_PATH:$NNSY_ROOT/bin
export ICU_DATA=$NNSY_ROOT/share/icu/data
export PATH=$PATH:$NNSY_ROOT/bin:/usr/bin:/etc:/usr/sbin:$HOME:/sbin
export NNSY_CATALOGUES=$NNSY_ROOT/NNSYCatalogues
export NN_CONFIG_FILE_PATH=/var/mqsi
export LIBPATH=/opt/wmqi/merant/lib:$LIBPATH
|
Here is what my .odbc.ini file looks like:
| 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
[MQSIBKDB]
Driver=/db2inst1/sqllib/lib/libdb2.sl
Description=MQSIBKDB DB2 ODBC Database
Database=MQSIBKDB
[VAD_DB]
Driver=/db2inst1/sqllib/lib/libdb2.sl
Description=VAD_DB DB2 ODBC Database
Database=VAD_DB
[MYDB]
Driver=/db2inst1/sqllib/lib/libdb2.sl
Description=MYDB DB2 ODBC Database
Database=MYDB
[ORACLEDB]
Driver=/opt/wmqi/merant/lib/UKor816.sl
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=YourServerName
EnableDescribeParam=1
OptimizePrepare=1
[SYBASEDB]
Driver=/opt/wmqi/merant/lib/UKase16.sl
Description=Sybase12
Database=SYBASEDB
WorkstationID=id
ServerName=YourServerName
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=10.30.14.72,5000
SelectUserName=1
[ODBC]
Trace=0
TraceFile=/var/wmqi/odbc/odbctrace.out
TraceDll=/opt/wmqi/merant/lib/odbctrac.sl
InstallDir=/opt/wmqi/merant
|
Do I also need to add a section in this file for the NEONDB?
Thanks for your help.
-H |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Dec 30, 2004 4:57 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
If you are using DB2 as your DB for NEON, you will need to define an ODBC connection to the DB.
You do not need to create ODBC connection for any other database.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| heath |
| Posted: Sun Jan 02, 2005 8:12 pm Post subject: |
|
|
Novice
Joined: 12 Jan 2004
Posts: 21
Location: Chicago, IL
|
Thanks Kiran. I added the NEONDB part to my .odbc.ini and everything is working fine now. However, I still have a questions for you guys out there:
We are migrating from WMQI running on AIX platform to WMQI running on the HP-UX platform. I brought over the .odbc.ini file from the AIX machine and put it on the HP machine without changing anything (except for the library path). The strange thing is that on the AIX box, there is no definition at all for the NEONDB in the .odbc.ini. Does any one know how is it working on AIX then??
Thanks,
-H |
|
| Back to top |
|
|
| VivekMeshram |
| Posted: Mon Jan 03, 2005 4:14 pm Post subject: |
|
|
Voyager
Joined: 25 Mar 2002
Posts: 83
|
| I think the entries for NEONDB and BKDB should be in .odbc.in in the /var/mqsi/odbc directory OR search for the .odbc.ini it may also possible that the .odbc.ini for the NEONDB and BKDB might have been configured on different location on AIX platform. |
|
| 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
|
|
|
|
