ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Can't create ODBC datasource on new Integration Bus 9 server

Post new topic  Reply to topic Goto page 1, 2  Next
 Can't create ODBC datasource on new Integration Bus 9 server « View previous topic :: View next topic » 
Author Message
mqsiman
PostPosted: Wed Oct 02, 2013 4:03 pm    Post subject: Can't create ODBC datasource on new Integration Bus 9 server Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

This is my first post on this forum. Hopefully there will be many to come!

Here's my issue. My company has been developing Web Services using WebSphere Enterprise Service Bus (WESB). We are now migrating to Integration Bus 9. We don't have a lot of prior Message Broker experience.

We have developed and tested some POC services on our development machines (Windows 7) that use an ODBC datasource and are now wanting to deploy them to our freshly built DEV server.

This is the server architecture and OS:

bash-3.2$ arch
x86_64
bash-3.2$ uname
Linux

Integration Bus 9 has been installed properly and tested with some POC Web Services that used JDBC connections. Integration Bus 9 ODBC Database Extender has been installed. The $ODBCINI, $ODBCSYSINI, and $IE02_PATH environment variables have been set. The odbc.ini odbcinst.ini should be correct because I used the provided templates and modified them.

When I run the following command to test my ODBC datasource I get the error message below. I thank you in advance for any help.

bash-3.2$ mqsicvp DEVBROKER -n MDMDB
BIP8290I: Verification passed for the ODBC environment.

BIP2393E: Database error: ODBC return code '-1' from data source ''MDMDB'' using ODBC driver manager ''''.
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. Use the mqsicvp command to test connectivity to this database.
BIP2347E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'
The error has the following diagnostic information: SQL State ''IM002'' SQL Native Error Code '0'
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. Use the mqsicvp command to test connectivity to this database.

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.
Back to top
View user's profile Send private message
Vitor
PostPosted: Wed Oct 02, 2013 4:53 pm    Post subject: Re: Can't create ODBC datasource on new Integration Bus 9 se Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

mqsiman wrote:
The $ODBCINI, $ODBCSYSINI, and $IE02_PATH environment variables have been set.


Have they been set in the command shell the broker is using?

mqsiman wrote:
The odbc.ini odbcinst.ini should be correct because I used the provided templates and modified them.


They should be, but there is a remote change of a typographical error. Remember that Linux is case sensitive where Windows is not.

mqsiman wrote:
BIP2347E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'


This is one thing which calls me to question your confidence.

mqsiman wrote:
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 systems that use $ODBCINI, check that the file pointed to by $ODBCINI has been correctly updated.


This is another.

mqsiman wrote:
- Use mqsisetdbparms to set the password to the correct value and try again.


Also you don't even mention this command.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
mqsiman
PostPosted: Wed Oct 02, 2013 6:55 pm    Post subject: Re: Can't create ODBC datasource on new Integration Bus 9 se Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

Vitor wrote:
mqsiman wrote:
The $ODBCINI, $ODBCSYSINI, and $IE02_PATH environment variables have been set.


Have they been set in the command shell the broker is using?

Yes. They get set when the $. mqsiprofile command is run.

bash-3.2$ cat /var/mqsi/common/profiles/setenv.sh
export ODBCINI=/var/mqsi/odbc.ini
export ODBCSYSINI=/var/mqsi
bash-3.2$


mqsiman wrote:
The odbc.ini odbcinst.ini should be correct because I used the provided templates and modified them.


They should be, but there is a remote change of a typographical error. Remember that Linux is case sensitive where Windows is not.

Double checked this again and I don't see anything wrong.

mqsiman wrote:
BIP2347E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'


This is one thing which calls me to question your confidence.

If I don't set any of $ODBCINI, $ODBCSYSINI, or $IE02_PATH I get different errors saying that the environment variable is not set.

mqsiman wrote:
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 systems that use $ODBCINI, check that the file pointed to by $ODBCINI has been correctly updated.


This is another.

I've double checked all of these.

mqsiman wrote:
- Use mqsisetdbparms to set the password to the correct value and try again.


Also you don't even mention this command.


I have used this command to associate the datasource with the broker. If I don't I again get a different error message (please see below).

bash-3.2$ mqsisetdbparms DEVBROKER -n MDMDB -u mdm_apps

Enter password for user ID
Retype password for user ID.
BIP8071I: Successful command completion.
bash-3.2$ mqsicvp DEVBROKER -n MDMDB
BIP8290I: Verification passed for the ODBC environment.

BIP2393E: Database error: ODBC return code '-1' from data source ''MDMDB'' using ODBC driver manager ''''.
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. Use the mqsicvp command to test connectivity to this database.
BIP2347E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'
The error has the following diagnostic information: SQL State ''IM002'' SQL Native Error Code '0'
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. Use the mqsicvp command to test connectivity to this database.

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.
bash-3.2$ mqsicvp DEVBROKER -n MDMDBXXX
BIP8272E: Datasource 'MDMDBXXX' has not been associated with broker 'DEVBROKER'.
This invocation of the mqsicvp command requires that the datasource name has been associated with the broker, using the mqsisetdbparms command.
Check that this datasource has been associated with the broker.



Back to top
View user's profile Send private message
Tibor
PostPosted: Wed Oct 02, 2013 11:54 pm    Post subject: Reply with quote

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary

Please send the output for this command:
Code:
cat $ODBCINI

If it seems correct, you should switch tracing on (http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fau14215_.htm).
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Oct 03, 2013 7:37 am    Post subject: Reply with quote

Grand High Poobah

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

Are you sure ODBCSYSINI should be pointing to a directory an not to ODBCInst.INI ?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
mqsiman
PostPosted: Thu Oct 03, 2013 8:47 am    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

fjb_saper wrote:
Are you sure ODBCSYSINI should be pointing to a directory an not to ODBCInst.INI ?


According to the instructions that I've used it should be the directory:
http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/topic/com.ibm.etools.mft.doc/bk58060_.htm
Back to top
View user's profile Send private message
mqsiman
PostPosted: Thu Oct 03, 2013 8:51 am    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

Tibor wrote:
Please send the output for this command:
Code:
cat $ODBCINI

If it seems correct, you should switch tracing on (http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fau14215_.htm).


;##########################################################################
;# ODBC database driver manager initialisation file. #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the #
;# copy. #
;# #
;# 1. For each data source, add the name of the data source into #
;# the 'List of data sources stanza' section. #
;# #
;# 2. For each data source, create a stanza in the #
;# 'Individual data source stanzas' section. #
;# #
;##########################################################################

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

[ODBC Data Sources]
MDMDB=DataDirect 7.0 ODBC Oracle Wire Protocol

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

;# Oracle stanza
[MDMDB]
Driver=/opt/ibm/mqsi/9.0.0.0/ODBC/V7.0/lib/UKora26.so
Description=MDM DEV Environment
HostName=myserver.mycompany.org
PortNumber=1521
ServiceName=myoracleservicename
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=/opt/ibm/mqsi/9.0.0.0/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8
Back to top
View user's profile Send private message
mqsiman
PostPosted: Thu Oct 03, 2013 9:09 am    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

I installed isql on the server. It’s referencing the $ODBCINI environment variable and I’m able to connect through isql. This tells me that odbc.ini is fine. However, I still get the same error message.

bash-3.2$ isql MDMDB myuser mypassword
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> quit
bash-3.2$ mqsicvp DEVBROKER -n MDMDB
BIP8290I: Verification passed for the ODBC environment.

BIP2393E: Database error: ODBC return code '-1' from data source ''MDMDB'' using ODBC driver manager ''''.
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. Use the mqsicvp command to test connectivity to this database.
BIP2347E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'
The error has the following diagnostic information: SQL State ''IM002'' SQL Native Error Code '0'
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. Use the mqsicvp command to test connectivity to this database.

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.
Back to top
View user's profile Send private message
lancelotlinc
PostPosted: Thu Oct 03, 2013 9:10 am    Post subject: Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

Did you sudo to the broker service Id before you ran mqsicvp ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Back to top
View user's profile Send private message Send e-mail
mqsiman
PostPosted: Thu Oct 03, 2013 11:53 am    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

lancelotlinc wrote:
Did you sudo to the broker service Id before you ran mqsicvp ?


yes

bash-3.2$ whoami
mqm
bash-3.2$ ps -ef | grep mqm
mqm 4774 5021 0 Sep29 ? 00:00:00 /opt/mqm/bin/runmqlsr -r -m DEVQMGR -t TCP -p 1415
mqm 4982 1 0 Sep17 ? 00:00:00 /opt/mqm/bin/amqzxma0 -m DEVQMGR
mqm 4989 4982 0 Sep17 ? 00:00:01 /opt/mqm/bin/amqzmuc0 -m DEVQMGR
mqm 4993 4982 0 Sep17 ? 00:00:03 /opt/mqm/bin/amqzmur0 -m DEVQMGR
mqm 4996 4982 0 Sep17 ? 00:00:00 /opt/mqm/bin/amqzmuf0 -m DEVQMGR
mqm 4998 4982 0 Sep17 ? 00:00:00 /opt/mqm/bin/amqrrmfa -m DEVQMGR -t2332800 -s2592000 -p2592000 -g5184000 -c3600
mqm 5000 4982 0 Sep17 ? 00:00:00 /opt/mqm/bin/amqzdmaa -m DEVQMGR
mqm 5021 4982 0 Sep17 ? 00:00:00 /opt/mqm/bin/amqzmgr0 -m DEVQMGR
mqm 5032 4996 0 Sep17 ? 00:00:00 /opt/mqm/bin/amqfqpub -mDEVQMGR
mqm 5038 4982 0 Sep17 ? 00:00:23 /opt/mqm/bin/amqzlaa0 -mDEVQMGR -fip0
mqm 5040 5021 0 Sep17 ? 00:00:00 /opt/mqm/bin/runmqchi -m DEVQMGR -q SYSTEM.CHANNEL.INITQ -r
mqm 5042 5021 0 Sep17 ? 00:00:04 /opt/mqm/bin/amqpcsea DEVQMGR
mqm 5049 5032 0 Sep17 ? 00:00:00 /opt/mqm/bin/amqfcxba -m DEVQMGR
mqm 5081 1 0 Sep17 ? 00:00:02 ./runmqlsr -t tcp -m DEVQMGR -p 1414
mqm 5087 5081 0 Sep17 ? 00:00:51 /opt/mqm/bin/amqrmppa -m DEVQMGR
root 13471 13433 0 08:47 pts/1 00:00:00 su mqm
mqm 13472 13471 0 08:47 pts/1 00:00:00 bash
root 14133 3678 0 09:02 ? 00:00:00 sshd: mqm [priv]
mqm 14135 14133 0 09:02 ? 00:00:00 sshd: mqm@notty
mqm 14136 14135 0 09:02 ? 00:00:00 /usr/libexec/openssh/sftp-server
mqm 23094 1 0 14:49 ? 00:00:00 bipservice DEVBROKER
mqm 23099 23094 15 14:49 ? 00:00:19 bipbroker DEVBROKER
mqm 23149 23099 0 14:49 ? 00:00:00 biphttplistener DEVBROKER
mqm 23152 23099 0 14:49 ? 00:00:00 /bin/bash /opt/ibm/mqsi/9.0.0.0/bin/startDataFlowEngine DEVBROKER 804ad266-4101-0000-0080-f561fbb5ee0a ServiceIntegration
mqm 23153 23152 3 14:49 ? 00:00:04 DataFlowEngine DEVBROKER 804ad266-4101-0000-0080-f561fbb5ee0a ServiceIntegration
mqm 23155 23099 0 14:49 ? 00:00:00 /bin/bash /opt/ibm/mqsi/9.0.0.0/bin/startDataFlowEngine DEVBROKER 0afd0a60-4101-0000-0080-9fbc2df33822
mqm 23156 23155 3 14:49 ? 00:00:03 DataFlowEngine DEVBROKER 0afd0a60-4101-0000-0080-9fbc2df33822 sdzelil
mqm 23157 23099 0 14:49 ? 00:00:00 /bin/bash /opt/ibm/mqsi/9.0.0.0/bin/startDataFlowEngine DEVBROKER 7636ce2e-4101-0000-0080-f9c0cd9ecda8
mqm 23161 23099 0 14:49 ? 00:00:00 /bin/bash /opt/ibm/mqsi/9.0.0.0/bin/startDataFlowEngine DEVBROKER 16277c3b-4101-0000-0080-b963982b95fb
mqm 23162 23161 3 14:49 ? 00:00:04 DataFlowEngine DEVBROKER 16277c3b-4101-0000-0080-b963982b95fb
mqm 23172 23157 5 14:49 ? 00:00:06 DataFlowEngine DEVBROKER 7636ce2e-4101-0000-0080-f9c0cd9ecda8
mqm 23389 13472 0 14:51 pts/1 00:00:00 ps -ef
mqm 23390 13472 0 14:51 pts/1 00:00:00 grep mqm


Last edited by mqsiman on Thu Oct 03, 2013 11:58 am; edited 1 time in total
Back to top
View user's profile Send private message
lancelotlinc
PostPosted: Thu Oct 03, 2013 11:56 am    Post subject: Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

Have you read the thread that talks about never ever to use mqm as the Broker service Id ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Back to top
View user's profile Send private message Send e-mail
mqsiman
PostPosted: Thu Oct 03, 2013 11:59 am    Post subject: Reply with quote

Novice

Joined: 01 Oct 2013
Posts: 12

lancelotlinc wrote:
Have you read the thread that talks about never ever to use mqm as the Broker service Id ?


Actually no. Someone else installed IIB9. Should that cause my error though?
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Oct 03, 2013 1:35 pm    Post subject: Reply with quote

Grand High Poobah

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

Quote:
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the specified user Id and password pair.

Are you sure the access has been granted to your userid and your passowrd is valid?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
lancelotlinc
PostPosted: Fri Oct 04, 2013 3:36 am    Post subject: Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

mqsiman wrote:
lancelotlinc wrote:
Have you read the thread that talks about never ever to use mqm as the Broker service Id ?


Actually no. Someone else installed IIB9. Should that cause my error though?


Whomever installed your IIB should be kept far away from any of your other applications as their depth of knowledge is questionable.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Back to top
View user's profile Send private message Send e-mail
smdavies99
PostPosted: Fri Oct 04, 2013 3:39 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

lancelotlinc wrote:


Whomever installed your IIB should be kept far away from any of your other applications as their depth of knowledge is questionable.


Should it be

'Whoever CONFIGURED your broker should be....'

configuring the broker with the right username etc is what's wrong. AFAIK, they don't need to reinstall
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page 1, 2  Next Page 1 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Can't create ODBC datasource on new Integration Bus 9 server
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
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.