Topic
  • 1 reply
  • Latest Post - ‏2014-08-14T23:07:41Z by Luis_river2421_82
NIKI PATRICIO
NIKI PATRICIO
1 Post

Pinned topic WMB 8 AIX v6 - Error ODBC DB2 Connect AS400 v5r3

‏2013-08-08T22:20:24Z |

Hi,

i have this error when i run: mqsicvp BRKPRD_MSEG -n DEVVIDA

BIP2393E: Database error: ODBC return code '-1' from data source ''DEVVIDA'' using ODBC driver manager ''/opt/ibm/IE02/2.0.0/lib/libodbcinterface.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 ''42968''; Native Error Code '-1598'; Error Text ''[unixODBC][IBM][CLI Driver] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968 ''.
The error has the following diagnostic information:     SQL State             ''42968''     SQL Native Error Code '-1598'     SQL Error Text        ''[unixODBC][IBM][CLI Driver] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968 ''
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.

I have copied the license in the "$ DB2_CLI_DRIVER_INSTALL_PATH/license" and I can successfully run the driver test connection: ./db2cli validate -dsn DEVVIDA -connect

Success: The schema validation completed successfully without any errors.
 
===============================================================================
db2cli.ini validation for data source name "DEVVIDA":
===============================================================================
 
[ Keywords used for the connection ]
 
Keyword                   Value
---------------------------------------------------------------------------
DBALIAS                   DEVVIDA
UID                       WBIADMIN
PWD                       ********
 
===============================================================================
db2dsdriver.cfg validation for data source name "DEVVIDA":
===============================================================================
 
[WARNING] Database entry for dsn is missing in IBM Data Server Configuration
file.
 
===============================================================================
 
[ Parameters used for the connection ]
 
Keywords                  Valid For     Value
---------------------------------------------------------------------------
DATABASE                  CLI,.NET,ESQL DEVVIDA
HOSTNAME                  CLI,.NET,ESQL 10.172.2.113
PORT                      CLI,.NET,ESQL 446
 
GlobalParam               **UNKNOWN**
 
===============================================================================
Connection attempt for data source name "DEVVIDA":
===============================================================================
 
[SUCCESS]
 
===============================================================================
The validation is completed.

===============================================================================

I also set the environment variables for users:

export DB2_CLI_DRIVER_INSTALL_PATH=/opt/db2_cli_odbc_driver/odbc_cli/clidriver
export LIBPATH=/opt/db2_cli_odbc_driver/odbc_cli/clidriver/lib:$LIBPATH
export PATH=/opt/db2_cli_odbc_driver/odbc_cli/clidriver/lib:/opt/db2_cli_odbc_driver/odbc_cli/clidriver/adm:$PATH

I have this same setup on the other server, but Linux and I have no problems, any ideas?

  • Luis_river2421_82
    Luis_river2421_82
    1 Post

    Re: WMB 8 AIX v6 - Error ODBC DB2 Connect AS400 v5r3

    ‏2014-08-14T23:07:41Z  

    Hola NIKI PATRI, quisiera saber como resolviste este problema, actualmente tengo el mismo error al confiurar un dataSource desde AIX hacia un iseries remoto.

    FAvor te agradeceria si me puedes ayudar. Te dejo mi mail : luis_river2421@hotmail.com

     

    Saludos