IBM Lotus Enterprise Integrator (LEI) for Domino Version 8.5.2 August 17, 2010 A) What's new in LEI V8.5.2 B) System requirements C) Installation considerations D) Operational considerations E) What's been fixed in LEI V8.5.2 F) Documentation errata G) Troubleshooting and support _____________________________________________________________________ A) What's new in LEI V8.5.2 The LEI technical documentation is available at https://www.ibm.com/developerworks/lotus/documentation/lei/ and http://www.ibm.com/software/lotus/support/integration/support.html. For the latest information about Lotus Enterprise Integrator offerings, visit http://www-306.ibm.com/software/lotus/products/enterpriseintegrator/ LEI V8.5.2 is a point release to the major LEI V8.5 release. If you are new to LEI V8.5, see the LEI V8.5 readme.txt file at the IBM developerWorks technical library at http://www.ibm.com/developerworks/lotus/documentation in the Lotus Enterprise Integrator product category. - ODBC 64 bit connector is now supported on Windows 64-bit(Windows 2003, Windows 2008 and Windows 2008 R2) and AIX 64-bit (5.3 and 6.1) platforms. - LEI 64-bit version is now supported for Text and File connector Windows 64-bit (Windows 2003, Windows 2008 and Windows 2008 R2) and AIX 64-bit (5.3 and 6.1) - UTF8 Support for Text Connector Windows 32-bit, Windows 64-bit and AIX 64-bit. - Support for MS SQL Server 2008. - Support for DB2 9.7. - Support for ODBC 5.3.3. - Support for Windows 2008 R2 operating system - Support for IBM i 7.1 operating system B) System requirements *Hardware requirements -- LEI 32 bit* - 60MB disk space on Win32 - 80MB disk space on UNIX and IBM i - 15MB temp space on Win32 - required by LEI installer - 90MB temp space on UNIX - required by LEI installer - 90MB temp space on Win32 - required by IBM i LEI installer * Memory requirement -- LEI 32 Bit* For Microsoft Windows - 256 MB RAM (above Domino requirements) for data management activities only - 512 MB (above Domino requirements) for real time and data management activities For Sun Solaris, IBM AIX, and Linux - 256 MB RAM (above Domino requirements) for data management activities only - 512 MB (above Domino requirements) for real time and data management activities *Hardware requirements -- LEI 64 bit* - 60MB disk space on Win64 - 20MB temp space on Win64 - required by LEI installer Note: To run 64 bit LEI, you must be running 64 bit versions of Domino, the Lotus Connector and all client connectivity software. * Memory requirement -- LEI 64 Bit* For Microsoft Windows - 256 MB RAM (above Domino requirements) for data management activities only - 512 MB (above Domino requirements) for real time and data management activities For IBM AIX - 256 MB RAM (above Domino requirements) for data management activities only - 512 MB (above Domino requirements) for real time and data management activities LEI V8.5.2 - 32 bit version LEI 32 bit is supported on the following platforms: 1) Windows 2003 Server and Server Enterprise Edition 32 bit Database client connectivity: Oracle 9i ,10g,11g - Native client and ODBC DB2 8.2.2, 9.1, 9.5, 9.7 - Native client and ODBC DB2 Universal Database for IBM i - Native client and ODBC Sybase 15 - Native client and ODBC MS SQL Server 2000, 2005, 2008 - Native client and ODBC Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 2) Windows 2003 Server and Server Enterprise Edition 64 bit (as a 32 bit application) Database client connectivity: Oracle 9i, 10g, 11g - Native client only DB2 8.2.2, 9.1, 9.5, 9.7 - Native client only DB2 Universal Database for IBM i - Native client only Sybase 15 - Native client only MS SQL Server 2000, 2005, 2008 - Native client only 3) Windows 2008 Server and Server Enterprise Edition 32 bit Database client connectivity: Oracle 10g,11g - Native client and ODBC DB2 9.1, 9.5, 9.7 - Native client and ODBC DB2 Universal Database for IBM i - Native client and ODBC Sybase 15 - Native client and ODBC MS SQL Server 2005, 2008 - Native client and ODBC MS SQL Server 2000 - ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 4) Windows 2008 Server and Server Enterprise Edition 64 bit (as a 32 bit application) Database client connectivity: Oracle 10g, 11g - Native client only DB2 9.1, 9.5, 9.7 - Native client only DB2 Universal Database for IBM i - Native client only Sybase 15 - Native client only MS SQL Server 2005, 2008 - Native client only 5) Windows 2008 R2 Server and Server Enterprise Edition 64 bit (as a 32 bit application) Database connectivity: Oracle 10g,11g -Native client and ODBC DB2 9.1,9.5, 9.7 -Native client and ODBC MS SQL Server 2005, 2008 -Native client and ODBC Sybase - ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 6) AIX 5.3 and 6.1 - 32 bit and 64 bit Database client connectivity: Oracle 9i ,10g,11g -Native client and ODBC DB2 8.2.2, 9.1,9.5, 9.7 -Native client and ODBC DB2 Universal Database for IBM i -Native client and ODBC Sybase 15 -Native client and ODBC MS SQL Server -ODBC only Informix -ODBC only MySQL 5.0, 5.1 - ODBC only 7) Solaris 10 Database client connectivity: Oracle 9i, 10g, 11g - Native client and ODBC DB2 8.2.2, 9.1, 9,5, 9.7 - Native client and ODBC DB2 Universal Database for IBM i - Native client and ODBC Sybase 15 - Native client and ODBC MS SQL Server-ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 8) RedHat Enterprise Linux (RHEL) 5.0, 5.1, 5.2 - 32 bit and 64 bit (as a 32bit application) Database client connectivity: Oracle 9i, 10g, 11g - Native client and ODBC DB2 8.2.2, 9.1, 9.5, 9.7 - Native client and ODBC DB2 Universal Database for IBM i - Native client and ODBC Sybase -ODBC only MS SQL Server - ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 9) Novell SuSE Linux Enterprise Server (SLES) 10 - 32 bit and 64 bit (as a 32 bit application) Database client connectivity: Oracle 9i, 10g, 11g - Native client and ODBC DB2 8.2.2, 9.1, 9.5, 9.7 - Native client and ODBC DB2 Universal Database for IBM i - Native client and ODBC Sybase - ODBC only MS SQL Server -ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 10) Novell SuSE Linux Enterprise Server (SLES) 11 - 32 bit and 64 bit (as a 32 bit application) Database client connectivity: DB2 8.2.2, 9.1, 9.5, 9.7 - Native client and ODBC DB2 Universal Database for IBM i - Native client and ODBC Sybase - ODBC only MS SQL Server -ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 11) IBM i 5.4, 6.1, 7.1 Database client connectivity: Universal Database for IBM i - Native client and ODBC Oracle - ODBC only Sybase - ODBC only MS SQL Server - ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only Read all Domino documentation regarding the specific patches Domino requires for its 32 bit server. The patch level required by Domino is a prerequisite for successful LEI installation. Patch requirements are updated periodically. See the Domino documentation for details: http://www.ibm.com/developerworks/lotus/documentation/domino/ *Other Software requirements -- LEI 32 bit* Note: Database client libraries must be 32 bit. If a client version is not available on a platform then that client configuration is not supported. For example, Oracle 9i (client only) is not available on Linux, thus support for this configuration of Oracle client is not supported on Linux. LEI V8.5.2 32 bit requires Notes/Domino V8.5.2 32 bit. *Current supported data drivers list -- LEI 32 bit* Supported Lotus Connector data driver versions are listed below: These include the Data Direct Sybase, Oracle, Informix, DB2, MS SQL, MySQL server ODBC wire protocols. Note: DataDirect ODBC drivers should be used with the Lotus Connector for ODBC. LEI supports the Lotus-branded DataDirect ODBC Wire Protocol drivers. LEI recommend using the Lotus- branded DataDirect ODBC Wire Protocol drivers. LEI V8.5.2 - 64 bit version LEI 64 bit is supported on the following platforms: 1) Windows 2003 Server and Server Enterprise Edition 64 bit Database connectivity: Oracle 9i ,10g,11g - Native client and ODBC DB2 8.2.2, 9.1, 9.5, 9.7 - Native client and ODBC MS SQL Server 2005, 2008 - Native client and ODBC Sybase - ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 2) Windows 2008 Server and Server Enterprise Edition 64 bit Database connectivity: Oracle 10g,11g -Native client and ODBC DB2 9.1,9.5 -Native client and ODBC MS SQL Server 2005, 2008 -Native client and ODBC Sybase - ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 3) Windows 2008 R2 Server and Server Enterprise Edition 64 bit Database connectivity: Oracle 10g,11g -Native client and ODBC DB2 9.1,9.5, 9.7 -Native client and ODBC MS SQL Server 2005, 2008 -Native client and ODBC Sybase - ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only 4) AIX 5.3 and 6.1 (64 bit) Database client connectivity: Oracle 9i ,10g,11g -Native client and ODBC DB2 8.2.2, 9.1,9.5, 9.7 -Native client and ODBC Sybase - ODBC only Informix - ODBC only MySQL 5.0, 5.1 - ODBC only Read all Domino documentation regarding the specific patches Domino requires for its 64 bit server. The patch level required by Domino is a prerequisite for successful LEI installation. Patch requirements are updated periodically. See the Domino documentation for details: http://www.ibm.com/developerworks/lotus/documentation/domino/ *Other Software requirements -- LEI 64 bit* Note: Database client libraries must be 64 bit. LEI V8.5.2 64 bit version requires Domino V8.5.2 64 bit version. *Additional Requirements* - Notes V8.5.2 client to administer the LEI Administrator database and run the LEI server if LEI is installed on a Notes client - Domino V8.5.2 server to manage the LEI Administrator database and run the LEI server if LEI is installed on a Domino server - Client libraries of the external systems to be accessed must be installed on the LEI server and the Domino server. When running activities, if the LEI server and the Domino server are on separate machines, the client libraries must be installed on both machines. - For UNIX, X Window system server environment - For UNIX, X Window system client libraries *Current supported data drivers list -- LEI 64 bit* Supported Lotus Connector data driver versions are listed below: These include the Data Direct Sybase, Oracle, Informix, DB2, MS SQL, MySQL server ODBC wire protocols. Note: DataDirect ODBC drivers should be used with the Lotus Connector for ODBC. LEI supports the Lotus-branded DataDirect ODBC Wire Protocol drivers. LEI recommend using the Lotus- branded DataDirect ODBC Wire Protocol drivers. Verify that all of your database software is current with all available maintenance releases and/or fix packs. For IBM i , LEI installation requires Windows Internet Explorer V6.0 or later. *Testing connectivity* - The supplied DCTEST program tests connectivity from the system on which the LEI server is installed to external data sources. The LEI server acts as a client to your external data server. - Run the appropriate connectivity test program from the Domino server before running LEI. The program names are listed below by platform: Issue the following command for Windows: ndctest Issue the following command for UNIX: dctest Issue the following command for IBM i: RUNDOMCMD SERVER(your_dom_server) CMD(CALL PGM (QDOMINOxxx/DCTEST)) BATCH (*NO) where xxx is the Domino release A command window help menu provides information for using the connectivity test program. C) Installation considerations See the Installation Guide supplied with LEI and also available at http://www.ibm.com/developerworks/lotus/documentation/lei for complete LEI installation instructions. See below for related considerations. Install considerations: - The user ID of the user who is installing LEI must be resident in the Domino Directory group LocalDomainAdmins or the LEI installation will fail. - The LEI installation utility does not inform you that you must make changes to your Domino Directory in order to support the server-side browsing method used by LEI. See the LEI Installation Guide for details. - The LEI server must be installed on a machine where a Notes client or a Domino server is installed. Only one LEI server can be installed on any single non-partitioned machine. On a partitioned machine, an LEI server can be installed on each partition. The LEI server version and the Notes/Domino version must match, or example Domino V8.5.2 with LEI V8.5.2. - On UNIX, do not use the following characters in an LEI server name: ", ', &, ;, :, / - If you will be installing LEI to a Notes client, set the Notes ID to share its password with other Notes-based systems, as documented in the LEI installation guide. To avoid multiple prompting for password, ensure that your Notes client is running during LEI install. Uninstall considerations: - In a failover cluster, uninstall the first failover server in the cluster last. Uninstall the failover servers sequentially from last to first. D) Operational considerations - Current LEI Tech Notes and other user information can be found at http://www.ibm.com/software/lotus/support/integration/support.html. - For platform and version support, see the LEI readme file on the developerWorks Technical documentation page at https://www.ibm.com/developerworks/lotus/documentation/lei. E) What's been fixed in LEI V8.5.2 The fixlist database at http://www.lotus.com/ldd/r5fixlist.nsf lists each LEI issue resolved in this release. Follow the steps to see what's been fixed in LEI V8.5.2: 1. Click "Product area" and then "Enterprise "Integration." 2. Click the release number to view the list of resolved issues. Important issues fixed in LEI Replication Activity area and VD quality initiative. a. SPR#PRJI7ZN9Y5 : LEI timestamp replication does not function as designed if Notes connector is used as source or target. b. SPR#DGIN7UNR9S : View categorization fails for the views used by LEI timestamp replication activity. c. SPR # KSAA7T94YV: The data inconsistency reported when VD is used in congestion with data table having constraint has been fixed. F) Documentation errata - All instances of the term "System i" or "i5/OS" should have been changed to "IBM i" in the LEI documentation set. - Missing documentation for IBM i system: As a prerequisite for successful LEI installation, see http://www.ibm.com/software/sw-lotus/products/product4.nsf/wdocs/leihomepage (weblink: http://www-306.ibm.com/software/lotus/) and the Domino documentation regarding the platform patch-level required for the Domino server. The LEI installation program checks which IBM i version is installed on your system. Install the required PTFs and other resources needed for your IBM i version. G) Troubleshooting and support The Lotus Connector LotusScript Extensions Guide and Lotus Connectors and Connectivity Guide are supplied with Domino. You can also obtain these guides at https://www.ibm.com/developerworks/lotus/documentation/lei/. For the latest information about Lotus Enterprise Integrator product offerings, visit the following Web sites: http://www.ibm.com/software/lotus/products/enterpriseintegrator/support http://www.ibm.com/developerworks/lotus/products/enterpriseintegration https://www.ibm.com/developerworks/lotus/documentation/lei/ _______________________________________________________________________________ Disclaimer The following paragraph does not apply to the United Kingdom or any other country/region where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NONINFRINGEMENT, MERCHANTABILITY, OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions; therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product, and use of those Web sites is at your own risk. Copyright Under the copyright laws, neither the documentation nor the software may be copied, photocopied, reproduced, translated, or reduced to any electronic medium or machine-readable form, in whole or in part, without the prior written consent of IBM Corporation, except in the manner described in the documentation or the applicable licensing agreement governing the use of the software. Licensed Materials - Property of IBM © Copyright IBM Corporation 1985, 2009 All rights reserved. Printed in the United States. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GS ADP Schedule Contract with IBM Corp. Revision History: Original material produced for IBM Lotus Notes and IBM Lotus Domino Release V8.5.2. List of Trademarks IBM, the IBM logo, AIX, DB2, Domino, iSeries, i5/OS, Lotus, Lotus Notes, LotusScript, Notes, QuickPlace, Sametime, System i, IBM i, System i5, System z, WebSphere, z/OS, and zSeries are trademarks or registered trademarks of IBM Corporation in the United States, other countries, or both. Additional IBM copyright information can be found at: http://www.ibm.com/legal/copytrade.shtml. Java and all Java-based trademarks and logos are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Intel and Pentium are trademarks of Intel Corporation in the United States, other countries, or both. Linux is a trademark of Linus Torvalds in the United States, other countries, or both. Other company, product and service names may be trademarks or service marks of others. _______________________________________________________________________________