IBM DB2

Use this datasource to connect to an IBM DB2 Database.

To install the IBM connectors, and only the connectors (including JDBC, ADO.NET, ODBC, & Ole-DB):

1. You want to install the “Data Server Driver Package” – only 40M and has everything.

2. Need 9.7.0.3a (or later). It’s at http://www-01.ibm.com/support/docview.wss?uid=swg24028317  

   1. Version previous to 9.7.0.3a have major problems - make sure you get that version or later.

3. All hotfixes are at http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg27016878

   1. Note – it says hotfix but it’s a full install.

   2. You only need the file v9.7fp3a_ntx64_dsdriver_EN.exe (under DSClients-ntx64-dsdriver-9.7.301.326-FP003a). You need _EN or _ALL_LANG.

4. If you are running a 64-bit version of Windows (Windows 7 and Vista are 64-bit) you install just the 64-bit driver and it will work with 32-bit applications. (AutoTag matches Office so if you are running a version of Office prior to 2010, or the 32-bit version of Office 2010, this will work in that configuration.)

Once you install the above, you can then connect to DB2 using AutoTag or either engine.

Server: Enter the server name here. This will auto-populate with the name of servers on your subnet that are configured to respond to a network query asking for their name. You can type in the name or select from the list.

Database: Enter the database name here. This will auto-populate from the server once the server is set. In most cases you will need to set your username & password (if you are not using Windows Identity) in order for AutoTag to auto-populate the list. You can type in the name or select from the list.

Display Tables: User and User Owned are the same thing for Sql Server. User will pull the metadata of just the tables created for a database. System will also pull the system tables Sql Server adds to the database used to administer and configure each database.

Read in metadata: Check this to read in additional information from the database, primarily the descriptions of tables, views, & columns and the primary key - foreign key relationships. You should always keep this checked.

Use Connection String: You can enter the connection string directly instead of entering the Server, Database, & Credentials. When unchecked it will dispkay the connection string AutoTag will generate from your settings.

Demo Server

You can connect to the Windward demo DB2 database as follows. It has the SAMPLE database.

Server: db2.windward.net

Username: demo

Password: demo