CODEWITHSUNDEEP
odbcibm-midrangedb2-400messagebrokeribm-integration-bus
Faris
Faris

Reputation: 1

How to integrate IIB with AS\400 database?

I am trying to connect IIB to IBM Iseries Database (DB2), but unfortunately I am not able to find the proper way to do this I tried to modify odbc.ini file as below:

Driver=/users/pc901/ODBC6.0/lib/DWdb224.so
Description=DataDirect 6.0 DB2 Wire Protocol
ApplicationUsingThreads=1
AuthenticationMethod=0
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
CharsetFor65535=0
Collection=DB2DEV
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=
DefaultIsolationLevel=1
DynamicSections=200
EnableBulkLoad=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
GrantAuthid=PUBLIC
GrantExecute=1
GSSClient=native
IpAddress=DB2.IBM.NET
LoadBalanceTimeout=0
LoadBalancing=0
Location=DB2LOC
MaxPoolSize=100
MinPoolSize=0
PackageCollection=NULLID
PackageNamePrefix=DD
Pooling=0
QueryTimeout=0
ReportCodePageConversionErrors=0
TcpPort=999
UseCurrentSchema=1
ValidateServerCertificate=1
WithHold=1
XMLDescribeType=-10

then I run the mqsisetdbparms then restart the integration node after this I run mqsicvp command and the following error appears

    BIP2322E: Database error: SQL State ''08001''; Native Error Code '-1013'; Error Text ''[unixODBC][IBM][CLI Driver] SQL1013N  The database alias name or database name "DEV" could not be found.  SQLSTATE=42705 ''.

Upvotes: 0

Views: 456

Answers (1)

jmarkmurphy
jmarkmurphy

Reputation: 11473

It looks like you are not using the correct driver. There are 3 flavors of DB2, and the drivers are not interchangeable. If you are trying to connect to DB2 for i, which is indicated by the ibm-midrange tag, then you need the ODBC driver from i Access Client Solutions. There are both windows and Linux drivers. This is licensed software, and you will need a valid license for the box you are trying to connect to. Here is a link to the product web site: IBM i Access Overview

If you cannot get a copy of that driver, then it looks like you can use JDBC with IIB as well. You can find an appropriate JDBC driver on Source Forge here.

Upvotes: 2

Related Questions