MQSeries.net :: View topic - Not able to connect remote db2 database using WMB 7

girish_kulkarni · Posted: Tue Jun 11, 2013 1:53 am Post subject:

Hi All,

We are trying to connect remote db2 database (9.5.x.x) using WMB 7 (odbc ) in linux environment. I have copied the DB2 ODBC CLI driver package in WMB installed machine.

Below is the odbc ini file (only db2 stanza pasted here)

;#######################################
;#### List of data sources stanza ######
;#######################################

[ODBC Data Sources]
NGIDB=IBM DB2 ODBC Driver for NGIDB
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 6.0 Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 Oracle Wire Protocol (Real Application Clusters)
SYBASEDB=DataDirect 6.0 Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver

;###########################################
;###### Individual data source stanzas #####
;###########################################

;# IBM DB2 DSN NGIDB stanza
[NGIDB]
Driver=/opt/ibm/mqsi/7.0/ODBC/V6.0/db2_cli_odbc_driver/odbc_cli/clidriver/lib/libdb2.so
Description=IBM DB2 ODBC Driver for NGIDB
Database=EGOVPROD

When I run mqsicvp getting below error, kindly help

wmbadmin@vmdb08 ~]$ mqsicvp MB7BROKER -n NGIDB

[i]BIP2393E: Database error: ODBC return code '-1' from data source ''NGIDB'' using ODBC driver manager ''libbipodbc.so''.
The broker received an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect data source, or table names. Correct either the database or the broker configuration.
BIP2322E: Database error: SQL State ''08001''; Native Error Code '-1013'; Error Text ''[IBM][CLI Driver] SQL1013N The database alias name or database name "NGIDB" could not be found. SQLSTATE=42705 ''.
The error has the following diagnostic information: SQL State ''08001'' SQL Native Error Code '-1013' SQL Error Text ''[IBM][CLI Driver] SQL1013N The database alias name or database name "NGIDB" could not be found. SQLSTATE=42705 ''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.

BIP8040E: Unable to connect to the database.
The database cannot be accessed with the specified user Id and password pair.
- Check that the database is running.
- Check that the database has an adequate number of database connections available for use.
- On Windows, check that an ODBC connection has been created.
- On systems that use $ODBCINI, check that the file pointed to by $ODBCINI has been correctly updated.
- On z/OS check the BIPDSNAO member of the component's dataset, and check the DB2 64bit ODBC driver (DSNAO64C) is in the STEPLIB.
- Use mqsisetdbparms to set the password to the correct value and try again.

Also, I would like to know is IBM data direct client installation is mandatory in the WMB installed machine or just DB2 ODBC CLI driver package is enough.

I have also updated db2cli.ini and db2dsdriver.cfg with all my db details