IBM Lotus Enterprise Integrator for Domino (LEI) Release 8.5.3 September 22, 2011 A) System requirements B) Installation considerations C) Operational considerations D) What's been fixed in LEI 8.5.3 E) Documentation errata F) Troubleshooting and support _____________________________________________________________________ A) 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 8.5.3 - 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 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 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 8.5.3 32 bit requires Notes/Domino 8.5.3 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 8.5.3 - 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 8.5.3 64 bit version requires Domino 8.5.3 64 bit version. *Additional Requirements* - Notes 8.5.3 client to administer the LEI Administrator database and run the LEI server if LEI is installed on a Notes client - Domino 8.5.3 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 6.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. B) 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 nonpartitioned 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, for example Domino 8.5.3 with LEI 8.5.3 - 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. C) 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. D) What's been fixed in LEI 8.5.3 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 8.5.3: 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 8.5.3. a. SPR#CSAO8AG9JG : AIX 64-bit and Windows 64-bit: LEI is crashed on ZPGetInputRecord by using text connector. b. SPR#KKOO7XUJTZ : SUMMARY flag is not created by LEI.. c. SPR#CSAO86BBEX : nlei.exe is crashed for PANIC: 01:92 during a termination d. SPR#HGBT79BC8B : LEI w64 throws error while installing Failed to get return value from database exists e. SPR#ADPI7XNB4Z : LEI 64 bit uninstaller skips a panel f. SPR#DGIN7PYQCA : LEI 8.5 does not find license file if started as a Windows service. g. SPR#AVSE8CU86X : LEI Licence files are copied in Domino program directory only on W64 platform. h. SPR#DWHL8DJQ76 : Lotus ODBC 64-bit drivers not licensed for use with LSXODBC / LS:DO newfeature i. SPR#DWHL864VUF : LEILOG.NSF must be uppercase on CentOS, or LEI will experience startup trouble. E) 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. F) 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 machinereadable 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 8.5.3. 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. __________________________________________________________________________