MQSeries.net :: View topic - Connecting to db2 in the os of windows while MB6 in AIX.

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Connecting to db2 in the os of windows while MB6 in AIX.

Connecting to db2 in the os of windows while MB6 in AIX.

« View previous topic :: View next topic »

Author

Message

chris888

Posted: Fri Oct 22, 2010 6:57 am Post subject: Connecting to db2 in the os of windows while MB6 in AIX.

Novice

Joined: 12 Jul 2010
Posts: 21

Hi All,
I try to store business data into db2 database, I met this error.

Code:

Text:CHARACTER:Root SQL exception
Insert
Type:INTEGER:2
Text:CHARACTER:-1
Insert
Type:INTEGER:5
Text:CHARACTER:                DatabaseException
File:CHARACTER:/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp

Line:INTEGER:446
            Function:CHARACTER:ImbOdbcHandle::checkRcInner

Type:CHARACTER:

Name:CHARACTER:

Label:CHARACTER:

Catalog:CHARACTER:BIPv610

Severity:INTEGER:3

Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:IM002             Insert
Type:INTEGER:2
   Text:CHARACTER:0
   Insert
   Type:INTEGER:5
            Text:CHARACTER:[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.

bash-3.2$ ./db2 connect to DMS user dmsuser using dmsuser

Code:

Database Connection Information
Database server = DB2/NT 9.5.0
SQL authorization ID = DMSUSER
Local database alias = DMS

/esb/IBM/mqsi/6.1/ODBC64/V5.3/odbc64.ini

Code:

;# DB2 stanza
[dmslpt]
DRIVER=libdb2Wrapper64.so
Description=DB2DB DB2 ODBC Database
Database=DMS

bash-3.2$ echo $ODBCINI

Code:

/esb/IBM/mqsi/6.1/ODBC64/V5.3/odbc64.ini

Can someone help me?

chris888

Posted: Fri Oct 22, 2010 4:19 pm Post subject:

Novice

Joined: 12 Jul 2010
Posts: 21

Nobody give me a hand?

fjb_saper

Posted: Fri Oct 22, 2010 7:47 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Really your DB on windows is a 64 bit DB?

Anyways from the error you listed it looks like you are supplying a String where an Integer is expected...

_________________
MQ & Broker admin

rekarm01

Posted: Sat Oct 23, 2010 6:00 am Post subject: Re: Connecting to db2 in the os of windows while MB6 in AIX.

Grand Master

Joined: 25 Jun 2008
Posts: 1415

chris888 wrote:

Code:

Text:CHARACTER:Child SQL exception
Insert
   Type:INTEGER:5
   Text:CHARACTER:IM002
Insert
   Type:INTEGER:2
   Text:CHARACTER:0
Insert
   Type:INTEGER:5
   Text:CHARACTER:[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.

Google IM002 "System information file not found" ?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Connecting to db2 in the os of windows while MB6 in AIX.

Jump to:

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

Protected by Anti-Spam ACP