Question & Answer
SPSS Data Access Pack 7.1 for MAC - no software on CD 1 Answer Notes SQL driver for Mac OS 0 Answers Informix ODBC OS X 0 Answers SPSS Grad Pack - Data access pack 3 Answers How to install ODBC driver in mac - to access dashdb from local rstudio app 0 Answers. IBM ODBC Driver for Linux on iSeries / AS/400 DB2 servers. DataDirect ODBC Driver for IBM DB2. OpenLink ODBC Driver for IBM DB2. Please add new entries here. IBM Informix. Please add new entries here. Netezza ODBC driver. Since IBM acquired Netezza, the ODBC drivers are only available to customers with active support contracts. Received the following warnings in Rstudio when I try to make a idaConnection: RODBC ERROR: state 00000, code 20471992, message iODBCDriver Managerdlopen(BLUDB, 6): image not found RODBC ERROR: state IM003, code 20471992, message iODBCDriver ManagerSpecified driver could not be loaded Looks like I don't have the db2 driver in place, even after going through the following step.
Question
How do you configure Modeler Client on a Mac to access DB2 LUW using the IBM DB2 ODBC driver?
Answer
1. Download the ODBC driver Manager from http://www.odbcmanager.net and install with the default settings.2. Download the IBM DB2 ODBC Driver from the 'IBM Data Server Driver' package within IBM Fix Central, for SPSS Modeler 18.0 FP1 this is 'DSClients-macos-dsdriver-11.1.1.1-FP001' that can be downloaded from:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm~Information%2BManagement&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=11.1.*&platform=Mac+OSX&function=fixId&fixids=*macos_dsdriver*FP001*&includeSupersedes=0&source=fc
NOTE: for up-to-date information on supported ODBC drivers refer to the footnotes of the DB2 entry in the IBM SPSS Modeler Related Software Reports on the IBM Software Compatibility Reports for the version of SPSS Modeler that you are using, http://www-969.ibm.com/software/reports/compatibility/clarity/index.jsp
3. Install the ODBC driver:
a. Create a folder ‘dsdriver’ under /Applications
b. Double click the downloaded v11.1.1fp1_macos_dsdriver.dmg file and a 'dsdriver' window will open Watch tv series online 123.
c. Double click ‘installDSDriver’
4. Configure the ODBC Driver Manager and ODBC Driver
a. Open ODBC manager, and in Driver tab, add DB2 native driver. Specify ‘DB2 Native Driver’ in the 'Driver Name' slot and ‘/Applications/dsdriver/lib/libdb2.dylib’ in the 'Driver File' slot - no other information is required here.
b. In the 'System DSN' tab of ODBC Manager create a DB2 DSN
i. In the 'Choose a Driver' slot specify the 'DB2 Native Driver' you defined in 4.a. above
ii. Specify a DSN in the 'Data Source Name (DSN) slot, eg. 'DB2v11' and click on 'Add' to create the system DSN.
c. Configure the DB2 Native Driver to connect to your DB2 instance:
Define the DB2 server information in the config file db2dsdriver.cfg under /Applications/dsdriver/cfg. An example of this is (using the example DSN 'DB2v11' as specified in 4.b.ii. above):
<?xml version='1.0' encoding='UTF-8' standalone='no' ?>
<configuration>
<dsncollection>
<dsn alias='DB2v11' host='<IP_or_HOST_NAME>' name='SAMPLE' port='50000'>
</dsn>
</dsncollection>
<databases>
<database host='<IP_or_HOST_NAME>' name='SAMPLE' port='50000'>
<parameter name='CommProtocol' value='TCPIP'/>
<parameter name='UID' value='<YOUR_DB2_USER_ID>'/>
<parameter name='EnableCharToWCharMapping' value='1'/>
<parameter name='XMLDefaultDescribeMapping' value='-98'/>
<parameter name='XMLDefaultCMapping' value='1'/>
<parameter name='LobAsLongDataMode' value='1'/>
</database>
</databases>
</configuration>
NOTE: Ensure the DSN in ODBC manager matches the one specified in the cfg file.
For more details of the configuration file, please refer to https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.swg.im.dbclient.config.doc/doc/c0054555.html
Also, if you need to use db2 commands to create or edit db2d2driver.cfg, or validate the contents of it, please add the profile file ‘db2profile’ under /Applications/dsdriver into your profile ($HOME/.profile).
You can validate the datasource you have defined outside of Modeler to ensure it is correctly defined by running the following from a terminal on the Mac, in the event of connections issues from within Modeler ensure this step succeeds and diagnose any issues with reference to the DB2 documentation:
db2cli validate -dsn <DSN> -connect -user <DB2USER> -passwd <DB2PASSWD>
substitute <DSN>, <DB2USER> and <DB2PASSWD> for the DSN you have created in db2dsdriver.cfg, and the DB2 username and password respectively.
[{'Product':{'code':'SS3RA7','label':'SPSS Modeler'},'Business Unit':{'code':'BU053','label':'Cloud & Data Platform'},'Component':'Modeler','Platform':[{'code':'PF022','label':'OS X'}],'Version':'18.0','Edition':','Line of Business':{'code':'LOB10','label':'Data and AI'}}]
Ibm Odbc Drivers For Mac Windows 7
Document Information
Odbc Driver Manager Download
Odbc Driver Manager Missing
Modified date:
19 September 2019
19 September 2019