| Author |
Message
|
| lancelotlinc |
 Posted: Thu Mar 31, 2011 5:30 am Post subject: mqsicvp db2 results in SLQ1366N |
 |
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Hi ya!
Ok, I'm -><- this close to getting this thing to work. I seek help of experts in the DB2 area, because I'm a novice on this topic.
I procured the DB2 v9.7 product for RHEL 5.5 64-bit. Installer went fine.
I successfully connected to the remote database using db2:
| Code: |
| db2 connect to <db2instancename> user <username> |
Result successful:
| Quote: |
Database Connection Information
Database server = DB2 OS/390 8.1.5
SQL authorization ID = <username>
Local database alias = <db2instancename>
|
Next I try:
| Code: |
| mqsicvp -n <db2instancename> -u <username> -p <pwd> |
And I get this error:
| Quote: |
BIP2393E: Database error: ODBC return code '-1' from data source ''<db2instancename>'' 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 '' ''; Native Error Code '-1366'; Error Text ''[IBM][CLI Driver] SQL1366N A security plug-in "IBMOSauthclient" processing error occurred on the client. Reason code = "7". ''.
The error has the following diagnostic information: SQL State '' '' SQL Native Error Code '-1366' SQL Error Text ''[IBM][CLI Driver] SQL1366N A security plug-in "IBMOSauthclient" processing error occurred on the client. Reason code = "7". ''
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.
|
Using Google, I find a similar problem on HP-UX related to linker. This clue leads me to believe I may have a 64-bit to 32-bit linker issue. How to test this theory and resolve?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Mar 31, 2011 5:42 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
mqsisetdbparms <broker> -n <db2instancename> -u <user> -p <password> ?
Edit: No. Strike that.
Can we see the odbc.ini? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Mar 31, 2011 5:50 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
ODBCINI (relevant parts)
| Quote: |
;##########################################################################
;# ODBC database driver manager initialisation file. #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the #
;# copy. #
;# #
;# 1. Complete the 'Mandatory information stanza' section #
;# at the end of the file. #
;# #
;# 2. For each data source, add the name of the data source into #
;# the 'List of data sources stanza' section. #
;# #
;# 3. For each data source, create a stanza in the #
;# 'Individual data source stanzas' section. #
;##########################################################################
;#######################################
;#### List of data sources stanza ######
;#######################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
<db2instancename>=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 #####
;###########################################
;# DB2 stanza
[DB2DB]
DRIVER=/opt/ibm/mqsi/7.0/lib/libdb2Wrapper64.so
Description=DB2DB DB2 ODBC Database
Database=<db2instanncename>
[<db2instanncename>]
DRIVER=/opt/ibm/mqsi/7.0/lib/libdb2Wrapper64.so
Description=DB2DB DB2 ODBC Database
Database=<db2instanncename>
;##########################################
;###### Mandatory information stanza ######
;##########################################
[ODBC]
;# To turn on ODBC trace set Trace=1
Trace=1
;#TraceOptions=3
TraceFile=/var/ibm/odbctrace.log
TraceDll=/opt/ibm/mqsi/7.0/ODBC/V6.0/lib/odbctrac.so
InstallDir=/opt/ibm/mqsi/7.0/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8
|
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Mar 31, 2011 6:05 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
and you've sourced the db2profile in the shell running mqsicvp?
(I'm sure you have, but it needs to be double-checked). |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Mar 31, 2011 6:14 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Yes...
| Quote: |
[mqbrkrs@<rhel64bitservername> <dir>]$ . /home/db2inst1/sqllib/db2profile
[mqbrkrs@<rhel64bitservername> <dir>]$ mqsicvp -n <db2instancename> -u <username> -p <pwd>
BIP2393E: Database error: ODBC return code '-1' from data source ''<db2instancename>'' 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 '' ''; Native Error Code '-1366'; Error Text ''[IBM][CLI Driver] SQL1366N A security plug-in "IBMOSauthclient" processing error occurred on the client. Reason code = "7". ''.
The error has the following diagnostic information: SQL State '' '' SQL Native Error Code '-1366' SQL Error Text ''[IBM][CLI Driver] SQL1366N A security plug-in "IBMOSauthclient" processing error occurred on the client. Reason code = "7". ''
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.
[mqbrkrs@<rhel64bitservername> <dir>]$
|
(BTW - thanks for helping me with this)
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Mar 31, 2011 7:22 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Quote: |
[db2inst1@<rhel64bitservername> <dir>]$ ls -l /opt/ibm/mqsi/7.0/lib/libdb2Wrapper64.so
lrwxrwxrwx 1 root root 16 Mar 16 10:51 /opt/ibm/mqsi/7.0/lib/libdb2Wrapper64.so -> libdb2Wrapper.so
[db2inst1@<rhel64bitservername> <dir>]$ ls -l /opt/ibm/mqsi/7.0/lib/libdb2Wrapper.so
-rwxr-xr-x 1 bin bin 107295 Jul 7 2010 /opt/ibm/mqsi/7.0/lib/libdb2Wrapper.so
|
Is "/opt/ibm/mqsi/7.0/lib/libdb2Wrapper.so" 32-bit or 64-bit?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Mar 31, 2011 8:55 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
|
|
