IBM Lotus Enterprise Integrator for Domino (LEI) Release 6.5 September 29, 2003 A) What's New in LEI Release 6.5 B) System Requirements C) Installation and Migration Considerations D) Installing LEI - General Instructions E) Uninstalling LEI F) Operational Considerations G) What's Been Fixed in LEI Release 6.5 H) Documentation Errata I) Troubleshooting and Additional Support _______________________________________________________________________________ A) What's New in LEI Release 6.5 For the latest information about Enterprise Integration offerings, visit the http://www.lotus.com/ei Web site or the LDD http:/www.lotus.com/ldd Web site. LEI Release 6.5 contains the following new features and enhancements. - Ability to install LEI on multiple partitions of a partitioned server LEI can now be installed on multiple partitions of a Domino partitioned server. - Additional platform support This release of LEI has added support for Linux Red Hat and United Linux v1.0. Supported platforms are listed in Section B of this readme and in the LEI installation guide. - Additional DataDirect ODBC driver support DataDirect 4.2 ODBC drivers are now available for use with the Lotus Connector for ODBC in both LEI and DECS. Any of the DataDirect ODBC drivers in the driver pack can be used with the Lotus Connector for ODBC. These include the Data Direct Sybase Wire Protocol for Sybase and the Data Direct Oracle Wire Protocol for Oracle. LEI and DECS continue to support the supplied Lotus-branded DataDirect version 4.2 ODBC driver. The Lotus Connectors are certified for use with the DataDirect ODBC drivers. For information on obtaining these drivers, please visit http://www.lotus.com/ei. - Current supported data drivers list The list of supported Lotus Connector data driver versions has been updated as below. All drivers are supplied with LEI. - Lotus Connector for DB2 with UDB 7.x and 8.1 - Lotus Connector for Oracle 7 with Oracle 7.3.4 and 8.0.5 - Lotus Connector for Oracle 8 with Oracle 8.0.5, 8i, and 9 - Lotus Connector for Sybase for Sybase 11.9.2 - Lotus Connector for OLE DB with SQL Server 2000 and Access 2000 - Lotus Connector for ODBC with DataDirect Lotus-branded driver 4.2 SP3 for standard ODBC connection - also see "Additional DataDirect ODBC driver support" statement above for additional 4.2 drivers. Supported systems include: - Sybase 12.5 - Oracle 9 - DB2 8.1 - SQL Server 2000 - Lotus Connector for SAP Release 1.7 - this is a Premium Connector product and is not supplied with LEI. See the http://www.lotus.com/ldd Doc Library for information. - Additional Lotus Connector availability on iSeries The following Lotus Connectors are now available on iSeries: DB2, Notes, SAP R/3, File, Text, ODBC, and the Metaconnectors - Read access control for Connection Documents LEI Activity Documents and Connection Documents now contain a Reader Priveleges field, similar to the existing Author Priveleges field. This enables the Author or an Administrator to assign Reader-level access to the document. - Dependent activity report available from LEI Administrator You can now generate a dependent activity report that displays the subordinate relationships for all activities in the active LEI Administrator database. This option is found on the Actions pulldown menu under the Activity Administrator selection. - Ability to reassociate detached virtual attachments Virtual attachments that have been detached from their parent document can now be re-attached, even after the parent document or key document is reinitialized, provided the attachment table contains a key to identify the parent document. - Multi-versioning support on iSeries LEI on iSeries supports the existence of multiple versions of Domino running at the same time on one server. However, as with the other platforms that support LEI, there must be a corresponding Domino version running to support LEI. For example, LEI 6.5 is only supported in conjunction with Domino 6.5 or 6.0.3, not a previous version of Domino such as 6.0.2. The LEI install and uninstall utilities automatically access the partition that contains the corresponding Domino version. The installer will notify you if the Domino server is not a version that the installer supports. You can then either select a different Domino server or exit the installation. - Additional PTF requirements for iSeries PTF 5722SS1 SI09401 is now required for V5R2. All current PTF requirements are listed in the LEI installation guide. - New environment variable for notes.ini As of DECS 6.0.3/6.5 and LEI 6.5, the EINoCenturyBoundary has been added for LEI, DECS, and LC LSX applications. When this variable is set as EINoCenturyBoundary=1, all year values are treated as 4 digit values. For example, the LC LSX statement New LCDatetime(1, 1, 4) will create a date of January 1, 0004. However, the New LCDatetime (1,1,04) will create a date of January 1, 0004, not January 1, 2004. Setting the variable as EINoCenturyBoundary=1 negates any use of EICenturyBoundary. - Changes in required fields for DB2 Advanced RealTime activities See the LEI Activities and User Guide for current information regarding the fields that are required. For example, the EINOTEPROPS data type for DB2 is now a VARCHAR for bit data, as opposed to BLOB. - Inactive view now part of the activities view choices A new view is now available that displays stopped activities. - The LEI documentation set is available in the Japanese language in the IntlDoc subdirectory. If you wish to use the Japanese translation, back up the English version .nsf documentation files (typically located in the Lotus\Domino\Data\Help directory) and copy the Japanese language .nsf documentation files into the Help directory. The Japanese-version documentation is also available in the Documentation Library at http://www.lotus.com/ldd under the Enterprise Integrator product title and the LEI 6.5 version. B) System Requirements For complete details see the LEI Installation Guide. *Hardware Requirements* - 40MB disk space on Win32 - 80MB disk space on UNIX and iSeries (or OS/400) - 90MB temp space on Win32 - required by iSeries LEI Installer - 15MB temp space on Win32 - required by LEI installer - 90MB temp space on UNIX - required by LEI installer *Operating Systems and Versions* LEI is supported on the following platforms, depending on whether you are using Domino 6.0.3 or 6.5: - Windows NT 4 SP6a, 2000, and 2003 - AIX 4.3.3, 5.1, and 5.2 - Solaris 2.8 and 2.9 - Linux Red Hat 7.2 and United Linux v1.0 - OS400 V5R1 and V5R2 Read all Domino documentation regarding the specific patches Domino requires for its 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. For example, the correct Solaris patch cluster is required. See IBM Technote 175748 for description of known issues for Windows NT 4.0 service pack 6a. *Software Requirements* LEI 6.5 requires Notes/Domino 6.0.3 or 6.5. - Notes 6 client to administer the LEI Administrator database and run the LEI server if LEI is installed on a Notes client - Domino 6.0.3 or 6.5 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 *** Verify that all of your database software is current with all available maintenance releases and/or fix packs. *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 (NT, 2000, 2003): ndctest Issue the following command for UNIX (AIX, Linux, and Solaris): dctest Issue the following command for iSeries: RUNDOMCMD SERVER(your_dom_server) CMD(CALL PGM(QDOMINOxxx/DCTEST)) BATCH(*NO) where xxx is the Domino release (650 for Domino 6.50 or 603 for Domino 6.0.3) A command window help menu appears that provides information for using the connectivity test program. C) Installation and Migration Considerations See the Installation Guide (leiig.nsf) supplied with LEI and also available as both a .nsf file and an HTML browseable at the LDD Documentation library (http://www.lotus.com/ldd) on the Enterprise Integrator product page for complete LEI installation and migration instructions. See below for related considerations. Installation 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 Domino server must be running during LEI installation. For the UNIX platforms, the installer does not error out if Domino is not running. You must verify that the Domino server is running before installing LEI. - DECS, if installed, must not be running during LEI installation. You can end DECS by typing 'tell DECS quit' at the Domino console. - 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 Release 6.5. See the LEI Installation Guide (leiig.nsf) 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, for example Domino 6.0.3 or 6.5 with LEI 6.5. - On UNIX, do not use the following characters in an LEI server name: ", ', &, ;, :, / Migration Considerations - Users must add the path to the Domino executable directory to their system PATH variable. For example, if performing migration where the LEI server and Domino server are on the same machine, the PATH must include C:\lotus\domino. If the migration is being performed on an LEI server that is installed via the Notes client, and the Domino server is remote, the PATH to the LEI server must include C:\lotus\notes. If this pathing is not set, the migration Tool may briefly flash on the screen, and exit without any error message. Or the migration tool will start but stay in the "starting..." position and you must stop it manually. To capture the error message, invoke the run_migration.exe launcher from a Dos prompt (as below) to gain additional information: run_migration.exe -is:log c:\temp\mig.txt Then look in the c:\temp\mig.txt file to see the following error: java.lang.UnsatisfiedLinkError: no nlsxbe (nlsxbe.dll) in java.library.path at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1380) at java.lang.Runtime.loadLibrary0(Runtime.java:766) at java.lang.System.loadLibrary(System.java:849) at lotus.domino.NotesThread.load(NotesThread.java:299) at lotus.domino.NotesThread.checkLoaded(NotesThread.java:320) at lotus.domino.NotesThread.initThread(NotesThread.java:140) at lotus.domino.NotesThread.run(NotesThread.java:202) LEI users must manually add the Domino executable directory path to their PATH setting because Domino and LEI installation do not. This is a Domino consideration, outside the scope of LEI, and is documented as a technote and in the LDD forums. A helpful technote is available at http://www.ibm.com/support by selecting "Search technical support", entering 183735 in the "Enter search terms" field, and then clicking Submit. You can also find assistance by performing an "All of LDD" search at www.lotus.com/ldd on the "unsatisfiedlinkerror" string. - If you have installed DECS and want to upgrade from DECS to LEI Release 6.5, you must first upgrade your DECS Administrator to 6.0.3 or 6.5 before installing LEI. You can upgrade Domino and then perform a "replace design" on the existing DECS Administrator using the Domino 6.0.3 or 6.5 DECS Administrator template. Once you have updated your DECS Administrator, you can install this release of LEI. The LEI installer automatically upgrades the DECS Administrator to this release of LEI. - In order to perform a remote upgrade, you must start Domino and stop DECS on the remote Domino server prior to installing LEI. You must also edit the remote Domino server's notes.ini file to remove DECS from the ServerTasks settings prior to installing LEI. - The migration log does not indicate the names of activities or connections that have been skipped. - When performing a migration that includes a script vault, if the migration tool encounters a script in the target with the same name as one that you are migrating from the source, the migrating (source) script will be logged as a duplicate. The remaining scripts will be logged as duplicates and will not be migrated. D) Installing LEI - General Instructions See the Installation Guide (leiig.nsf) supplied with LEI and also available as both a .nsf file and an HTML browseable at the LDD Documentation library (http://www.lotus.com/ldd) on the Enterprise Integrator product page for complete LEI installation and migration instructions. See below for related considerations. - Before installing to a UNIX platform, you must do the following: - Set the correct access controls in the names.nsf file on the Domino server. - Establish the correct access rights in the Notes ID file. - Ensure that all needed environment variable are set and exported. - Ensure that you have loaded and configured X Window system software. - 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 promptings for password, ensure that your Notes client is running during LEI install. E) Uninstalling LEI The LEI uninstall process is explained fully in the Installation Guide (leiig.nsf) supplied with LEI and also available as both a .nsf file and an HTML browseable at the LDD Documentation library (http://www.lotus.com/ldd) on the Enterprise Integrator product page. F) Operational Considerations Current LEI Tech Notes and other user information can be found at http://www-3.ibm.com/software/lotus/support/integration/support.html. The Lotus Connector LotusScript Extensions Guide (lsxlc6.nsf) are not supplied LEI, you can obtain them at the LDD Documentation Library or with your Domino release. Virtual Activities Considerations - When using any LEI Data Transfer activity in conjunction with an ODBC to DB2 or an ODBC to Oracle connection, the activity will fail if certain binary data types are mapped. Additionally, Virtual Documents activities will fail whether or not these binary data types are mapped as data due to the internal use of the types. With DB2, this occurs when using either the native IBM DB2 ODBC driver or the DataDirect DB2 ODBC driver. With Oracle, this occurs when using either the native Oracle ODBC driver (pre 8.1.5) or the DataDirect Oracle ODBC driver. The native Oracle ODBC driver version 8.01.05 and later does not appear to have this limitation. The affected data types are as follows, with possible suggested alternates where possible: DB2 BLOB,CLOB alternate: use VARCHAR for bit data Oracle BLOB alternate: use LONG RAW or RAW For Virtual Documents, use one of the alternate types when setting up the EINOTEPROPS column and set the size to the largest allowable, which will be generally less than the recommended size of 10K when using the BLOB data type. - As of LEI release 6.5, when working with DB2 and the required EINOTEPROPS field, the suggested field size has changed from a 2GB BLOB to a 10240 VARCHAR. This may cause errors in your Virtual Documents activities after you upgrade to LEI 6.5. The solution is detailed in the Virtual Documents chapter of the user guide in the section entitled Virtual Documents Required Column Data Types. - If Advanced RealTime is enabled ("EXTMGR_ADDINS=decsext" is present in your notes.ini file), whenever the Domino server is shut down, the LEI server is also shut down, regardless of whether it is run as an addin task ("ServerTasks=LEI" is present in your notes.ini file). This is not an issue if RealTime is not enabled on the Domino server. iSeries Considerations - On the iSeries platform, when transferring data from Notes to Japanese EBCDIC DB2, the Japanese single byte yen character (0x5c in LMBCS) is replaced with the backslash character. - On iSeries, the LCFieldList.Copy method of LC LSX drops the source LCStream object property values for Stream Flags and Max Length. As a result, they are not set in the target FieldList object. LCFieldList.MaxLength is a read-only property based on the LCStream type: LCTYPE_TEXT or LCTYPE_BINARY. You can manually set the LCFieldList.Flags property when copying, obtaining the property values from the source object. - Use the native Lotus Connector for DB2 to access the IBM DB2 UDB and IBM DB2 on iSeries. For the latest information about the iSeries platform, visit the http://www-1.ibm.com/servers/eserver/iseries Web site: For the latest information about Enterprise Integration offerings, visit the http://www.lotus.com/ei Web site. G) What's Been Fixed in LEI Release 6.5 This section lists functionality improvements that have been made in LEI Release 6.5. - Multi-value Readers/Authors fields did not function correctly within a Virtual Documents activity. This has been corrected. - Timestamp polling with the Lotus Connector for DB2 has been improved. - Double-precision data type transfer from DB2 to DB2, DB2 to Oracle 8, OR Notes to DB2 did not always yield the same or higher precision in the target as in the source. This has been corrected. - Replication failed when more than 170 fields were mapped. This has been corrected. - The LC LSX LCStream Trim method is now fully functional. - The Virtual Documents option for conflict detection is now fully functional. - In conjunction with a Virtual Fields activity, if a subform is in a table on a form, LEI did not resolve the fieldlist from the subform specified in the connection. This has been corrected. - When paging occurs frequently in a users environment, the LEI executable nleiact.exe caused an error. This has been corrected. - Virtual Documents index/view rebuilds have experienced significant performance improvements. Also, changing the EIReadBlockSize in notes.ini from '1' to '50' increases performance. - For any activity that used a Notes connection in which the "Allow view creation/overwrite" option was enabled (primarily a Replication activity), or if the view was updated by some other process concurrent with an LEI activity, data corruption could occur in the target database. This has been corrected. - Running Virtual Agents against Virtual Documents will refresh the view for those records to display all external database modifications. However, for non-parameter Virtual Agents or for modifications made by stored procedure outside of the selected records, the view was not refreshed. This has been corrected. - Users can now manually edit field lists in the Virtual Documents, Virtual Fields, and Virtual Agents activities. H) Documentation Errata - Any instances of the term "LEI 6/LEI Release 6" or "Domino 6" are in reference to LEI 6.5 and Domino 6.0.3 or 6.5. - During LEI installation, ncontest.exe (Win32) or contest is copied to the target system. The installation guided omitted this. - The LEI user guide refers to the LEI console commands (tell lei) that are available when LEI is started as an addin task. However, it does not mention the "tell lei exit" command, which enables you to shut down the LEI server from the LEI console window. - You can use the Admin-backup activity to create a backup copy of the LEI Administrator and/or LEI Script Vault. To use the backup, copy the original administrator or script vault database to a new name (such as _mmddyy), delete the old database, and copy the backup to the data directory (typically \Lotus\Domino\data). Once copied, rename as either decsadm.nsf (admin) or leivlt6.nsf (script vault). Open the database and begin work. This procedure is not documented in the user guide. - The "Considerations When Working with the Lotus Connector for ODBC - iSeries" section of Chapter 7 in the Lotus Connectors and Connectivity Guide (lccon6.nsf) contains a pathing error. The correct pathing is shown below: ADDENVVAR ENVVAR(PASE_LIBPATH) VALUE('/usr/lib:/QIBM/ProdData/LOTUS/DOMINOXXX/EITODBC/lib') ADDENVVAR ENVVAR(PASE_ODBCINI) VALUE('/QIBM/UserData/LOTUS/DOMINOXXX/EITODBC/odbc.ini') I) Troubleshooting and Additional Support For the latest LEI technical information, including Tech Notes, visit the following Web page: http://www-3.ibm.com/software/lotus/support/integration/support.html Support is also available for LEI at the following Web page: http://www-3.ibm.com/software/lotus/support/ ***************************************************************************** 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. Domino, Notes, IBM Lotus Enterprise Integrator for Domino (LEI), LotusScript, Lotus Connectors, and Domino Enterprise Connection Services (DECS) are trademarks of Lotus Software, IBM Software Group. AIX, DB2/2, DB2, and IBM are registered trademarks of International Business Machines Corporation. All other trademarks are held by their respective owners. Copyright IBM Corporation 1985-2003 Lotus Software, IBM Software Group One Rogers Street Cambridge, MA 02142 All Rights Reserved. *****************************************************************************