
74 DB2 II and WPS Synergy
Figure 4-5 Determining user ID of DB2 II
– Microsoft Excel must be installed on the Windows server where DB2 II is
installed, if Microsoft Excel files need to be accessed by DB2 II.
Appendix B.5.1, “Microsoft Excel data source considerations” on page 268
describes the considerations involved in configuring DB2 II to access
Microsoft Excel.
If the flat files are not located on the WebSphere Portal Windows server, or
Microsoft Excel cannot be made available on it, then DB2 II will need to be
located on a Windows server where these prerequisites are met.
Licensing and administration costs
When DB2 II is installed on a sep ...