Create a federated database for DB2 UDB and Informix IDS using DB2 II

Create a federated database for DB2 UDB and Informix IDS using DB2 II

Cisco and Huawei network technology-the largest network content Teaching Resource Network (vlan9.com)

Http://www.qqread.com Author: Source: blog.chinaunix.net browse: 45

DB2 II is now called WebSphere II

Environment:
Windows XP Pro
DB2 UDB v8.1 fixpak3
DB2 II v8.1 fixpak3
Informix IDS v10.00.tc1 (HA for IDS V9 wrapper supports IDs v10.0)

Informix server and DB2 UDB are both on one machine, so Informix Client-SDK is not installed.

(1) Installation of DB2 II v8.1
DB2 II v8.1 requires that the patch package for DB2 UDB v8.1 be higher than fixpak2.
I have downloaded fixpak3 and fixpak3 of DB2 II v8.1.
(A) install DB2 UDB v8.1
(B) install DB2 UDB v8.1 fixpak3
(C) install DB2 II v8.1
(D) reinstall DB2 UDB v8.1 fixpak3 and install DB2 II v8.1fixpak3 (including relational wrapper and norelational wrapper)

(2) db2ii
(A) edit the db2dj. ini file and add the following content:
Informixdir = C:/progra ~ 1/Informix
Informixserver = ol_demo
Client_locale = en_us.cp1252
Db_locale = EN_US.8859-1
Db_locale, client_locale and Informix are not configured at the beginning, and error-23101 is reported.

(B) Create a packer
DB2 create wrapper "Informix" library 'db2informix. dll ';

(C) Create a server
DB2 create ifx_srv wrapper Informix

(D) Create a user ing
DB2 create user mapping for "username" server "ifx_srv" Options (add remote_authid 'username', add remote_password '*****');

(E) DB2 set passthru ifx_srv
Yes ;-)
DB2 select count (*) from Informix. Tables Ables

(F) Create a nickname
DB2 create nickname username. Customer for ifx_srv. "username". "customer ";
You can also query
DB2 select * from customer

An Excel connection is also made. Now it is relatively simple to write, but the whole process is still tossing for 2 or 3 days. In addition, it is convenient to use the control center.

References
<Federation-database interoperability (Part 1)>
<Federation-database interoperability, continue to make bold attempts (Part 1)>
<DB2 II v8.1 installation guide.pdf>
<DB2 II v8.1 data source configuration guide.pdf>

Keywords: Database Server word Windows XP Informix ie Excel DB2