IBM DB2
Use the IBM DB/2 DataSource to access DB/2 database including DB/2 databases on iSeries and AIX systems.
The following IBM DB 2 versions are supported
- IBM DB/2 9.5
- IBM DB/2 7.0, 8.0, 8.1 and 8.2
- IBM DB/2 6.0 with minimum Fix pack 3 installed
- IBM DB/2 5.0 with minimum Fix pack 11 installed (5.2)
IBM DB 2 supported Data Types
Additional installation
Installing the RapidiConnector
If you want to transfer data to/from DB2 Data Sources, you have to do the following:
- Install "DB2 Connect" for Windows.
- Open the "Client Configuration Assistant".
- Add a connection to each database that you want to transfer data to/from. Locate the database by searching the network. If your DB2 database is placed on a iSeries (AS400), you have to add a new system. When the requested database is found, you select it and fill in the database name and description.
Select "System Data Source" and test the connection.
If the result is successful, you can continue. - Now you have to "bind" "DB2 utilities". You fill in the UserID and Password. When you get the option of choosing the type of binding, you have to choose "CLI" binding.
Configuration
The fields of the IBM DB/2 Data Source Card are described as follows:
-
Code: Give the Data Source a unique ID.
-
Description: Fill in a descriptive text.
-
Server Connect: Here you specify the name of the connection you created during the additional installation.
-
UserID: Here you specify the UserID.
-
Password: Here you specify the Password.
-
Schema: If you want to use a specific schema you can specify which one.
Copy, Test, Activate Changes, and Read Design
Copy Connection
Connection Test
Activate Changes
Read Design