Website Search
Find information on spaces, staff, and services.
Catalog Search
Books
Implementing IBM Lotus Enterprise Integrator 6 on the IBM e server iSeries Server
- Available as
- Online
- Summary
-
This IBM Redbooks publication helps you to implement Lotus Enterprise Integrator (LEI) 6 on the IBM eServer iSeries server. It is targeted for system administrators who plan to implement or upgrade...
This IBM Redbooks publication helps you to implement Lotus Enterprise Integrator (LEI) 6 on the IBM eServer iSeries server. It is targeted for system administrators who plan to implement or upgrade to LEI 6 in their organization. The book provides tips and techniques to help you successfully deploy and administer LEI 6 on an iSeries server. We begin by providing a brief introduction to what’s new with LEI 6 and cover some architectural scenarios of how the LEI 6 infrastructure could be implemented in a customer’s environment. We then provide detailed information about how to install and administer LEI 6 on the iSeries server. Migrating or upgrading from LEI 3.x is also covered. This book also provides some basic connectivity information about how to connect one iSeries server to another as well as from iSeries to pSeries and xSeries to iSeries. Finally this book provides some working examples of how to use the Advanced RealTime activities that are new in LEI 6. It also provides examples of some of the batch activities previously available in LEI 3.x, such as a scripted activity and a replication activity. Please note that the additional material referenced in the text is not available from IBM.
Details
- Creator
- [Deb Landon ... et al.]
- Format
- Books
- Language
- English
- Contributors
- Publication
-
- 1st ed
- [S.l.] : IBM, International Technical Support Organization, c2003
- Series
- Physical Details
-
- xiv, 326 p. : ill
- text file
- ISBNs
- 0738453277
- OCLC
- ocn137342224, ocn829783611
- "September 2003."
- "SG24-6941-00."
- Includes bibliographical references and index.
- English
- Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction to IBM Lotus Enterprise Integrator (LEI) 6 for Domino -- 1.1 A business case for LEI -- 1.2 DECS and DCRs defined -- 1.2.1 DECS -- 1.2.2 DCRs -- 1.3 LEI defined -- 1.3.1 Connection documents -- 1.3.2 Activity documents -- 1.3.3 Current limitations with using LEI 6 -- 1.4 A comparison of DECS, DCRs, and LEI -- 1.4.1 Advanced RealTime feature - virtual attachments -- 1.4.2 Advanced RealTime feature - integrated credentials -- 1.5 What's new with LEI 6.0 and LEI 6.0.1 -- 1.5.1 What's new in LEI 6 -- 1.5.2 LEI 6.0.1 on the iSeries server -- 1.6 Terminology -- 1.6.1 iSeries relational database versus LEI verses Lotus Domino -- 1.6.2 DB2 UDB iSeries terminology differences -- 1.7 Data type conversions/mappings -- 1.7.1 iSeries SQL data types -- 1.7.2 iSeries native physical file data types -- 1.7.3 Domino Designer data types -- 1.7.4 Data type mapping guidelines -- Chapter 2. Architectural scenarios and considerations -- 2.1 Architectural scenarios -- 2.1.1 Scenario 1: Single iSeries server -- 2.1.2 Scenario 2: Remote database server -- 2.1.3 Scenario 3: LEI 6 integration with Domino R5 applications -- 2.1.4 Scenario 4: Decentralized Advanced RealTime access -- 2.1.5 Scenario 5: Advanced RealTime in a hub and spoke environment -- 2.1.6 Scenario 6: Accessing multiple relational databases from iSeries -- 2.2 Security considerations -- 2.2.1 Generic user ID and password in connection document -- 2.2.2 Integrated credentials -- 2.2.3 Fields and public key encryption -- 2.3 Performance considerations -- 2.3.1 LEI considerations -- 2.3.2 Performance spectrum scenarios -- 2.3.3 DB2 UDB considerations -- 2.3.4 Connection pooling verses persistent connections
- 2.3.5 Persistent connections in Advanced RealTime activities -- Chapter 3. Installation and configuration on the iSeries platform -- 3.1 Prerequisites for operating LEI on the iSeries server -- 3.1.1 Hardware -- 3.1.2 Software -- 3.1.3 Required PTFs for OS/400 -- 3.1.4 Domino Enterprise Connection Services (DECS) -- 3.2 Pre-installation activities -- 3.2.1 Domino server document changes -- 3.2.2 ID modifications -- 3.2.3 TCP/IP configuration -- 3.3 Installation of LEI -- 3.3.1 Installation Checklist -- 3.3.2 Process of Installation -- 3.4 Administration of LEI on the iSeries -- 3.4.1 LEI Administrator database -- 3.4.2 Configuration -- 3.4.3 Starting and stopping the LEI server -- Chapter 4. Migrating from Lotus Enterprise Integrator 3.x -- 4.1 Migration considerations -- 4.1.1 Migrating scripted documents -- 4.1.2 Migrating metaconnection documents -- 4.1.3 LEI clustering and remote administration -- 4.1.4 Duplicate connection and activity documents -- 4.2 Pre-migration activities -- 4.3 Process of migration -- 4.4 Troubleshooting -- 4.4.1 Migration log file -- Chapter 5. Base connectivity -- 5.1 Distributed Relational Database Architecture (DRDA) -- 5.2 iSeries to iSeries -- 5.2.1 Connecting from an iSeries server to an iSeries server -- 5.2.2 Creating a local relational database directory entry -- 5.2.3 Creating a DRDA connection to a remote iSeries server -- 5.2.4 Test connectivity using the DCTEST utility -- 5.3 xSeries server to iSeries server -- 5.3.1 Required software and setup -- 5.3.2 iSeries DB2 UDB client configuration -- 5.3.3 Testing connectivity -- 5.3.4 Errors encountered -- 5.4 iSeries to pSeries connectivity -- 5.4.1 Determining pSeries remote database server port -- 5.4.2 Creating a remote RDBDIRE entry to the pSeries server -- 5.4.3 Ensure the iSeries server is not using the default CCSID
- 5.4.4 Perform the DCTEST connectivity test -- 5.4.5 Creating a connection document to DB2 UDB on the pSeries server -- Chapter 6. Connection documents -- 6.1 DB2 connection document -- 6.1.1 Connectivity section -- 6.1.2 Table selection section -- 6.1.3 Other section -- 6.2 Notes connection document -- 6.2.1 Connectivity section -- 6.2.2 Other section -- 6.3 File connection document -- 6.3.1 Connectivity section -- 6.3.2 Subdirectory Selection section -- 6.3.3 Other section -- 6.4 Text connection document -- 6.4.1 Connectivity section -- 6.4.2 Text specifications section -- 6.4.3 Other section -- 6.5 Metaconnectors -- 6.5.1 Collapse/Expand metaconnector -- 6.5.2 Meter metaConnector -- 6.5.3 Order metaConnector -- 6.5.4 Trace metaConnector -- 6.6 Test connection documents using the CONTEST utility -- Chapter 7. Setting up the examples environment -- 7.1 OS/400 libraries -- 7.1.1 Download and set up the libraries -- 7.1.2 EMPLIB library -- 7.1.3 AUTOBODY library -- 7.2 Domino databases -- 7.2.1 Autobody demo database (autobodydemo.nsf) -- 7.2.2 Case files database (casefile.nsf) -- 7.2.3 Employee database (employee.nsf) -- 7.2.4 Medical records database (medrec.nsf) -- Chapter 8. Advanced RealTime activities -- 8.1 Virtual documents activity -- 8.1.1 How does the virtual documents activity work? -- 8.1.2 External system metadata for virtual documents activities -- 8.1.3 Indexing -- 8.1.4 Deletion involving virtual documents -- 8.1.5 Domino replication involving virtual documents -- 8.1.6 Event options for virtual documents activity -- 8.2 Virtual fields activity -- 8.2.1 How does the virtual fields activity work? -- 8.2.2 Event options for virtual fields activity -- 8.3 Differences between virtual documents and virtual fields -- 8.3.1 Advantages of virtual documents activity -- 8.3.2 Limitations of virtual documents activity
- 8.3.3 Using virtual fields with virtual documents -- 8.4 Virtual attachments -- 8.5 Virtual agents activity -- 8.6 Example 1: Using a virtual documents activity -- 8.6.1 Create a DB2 connection document -- 8.6.2 Create a virtual documents activity document -- 8.6.3 Testing the virtual documents activity -- 8.7 Example 2: Using virtual documents with a DB2 UDB view -- 8.7.1 Create a DB2 connection document to EMPLIB.EMP_DEPT -- 8.7.2 Create a virtual documents activity document -- 8.7.3 Testing the virtual documents activity -- 8.8 Example 3: Using virtual fields with multiple DB2 tables -- 8.8.1 Create a DB2 connection document to EMPLIB.EMPLOYEE -- 8.8.2 Create a DB2 connection document to EMPLIB.DEPARTMENT -- 8.8.3 Create a virtual fields activity document to EMPLIB.EMPLOYEE -- 8.8.4 Generate key documents -- 8.8.5 Create a virtual fields activity document to EMPLIB.DEPARTMENT -- 8.8.6 Testing the virtual fields activities -- 8.9 Example 4: Using virtual fields with virtual documents -- 8.9.1 Create a DB2 connection document to EMPLIB.EMPLOYEE2 -- 8.9.2 Create a DB2 connection document to EMPLIB.DEPARTMENT -- 8.9.3 Create a virtual documents activity -- 8.9.4 Create a virtual fields activity -- 8.9.5 Testing the activities -- 8.10 Example 5: Using virtual agents and virtual attachments -- 8.10.1 Create a DB2 connection document to AUTOBODY.AUTOBODY_EST -- 8.10.2 Create a DB2 connection document to AUTOBODY.AUTOBODY_DAMAGE -- 8.10.3 Create a DB2 connection document to AUTOBODY.DAMAGETOT -- 8.10.4 Create a virtual documents activity document -- 8.10.5 Create a virtual fields activity document -- 8.10.6 Create a virtual agents document -- 8.10.7 Testing the virtual attachments activity -- 8.10.8 Testing the virtual agents activity -- Chapter 9. Batch activities -- 9.1 Scripted activity -- 9.1.1 Example: Building a direct transfer scripted activity
- 9.2 Replication activity -- 9.2.1 Primary key replication -- 9.2.2 Timestamp replication -- 9.2.3 Example: Timestamp replication from DB2 UDB to Domino -- 9.3 Other data moving activities -- 9.3.1 Archive -- 9.3.2 Command -- 9.3.3 Direct transfer -- 9.3.4 Java -- 9.3.5 Polling -- 9.3.6 Admin-Backup -- 9.3.7 Admin-Purge Log -- Appendix A. Removing Lotus Enterprise Integrator (LEI) -- Considerations prior to removing LEI -- Access to data -- LEI clustered environment -- Domino Enterprise Connection Services (DECS) -- Process of removing LEI -- Appendix B. Using iSeries Navigator to access DB2 UDB -- Connecting to an iSeries server -- Working with a library -- Creating a library -- Displaying a library -- Working with tables -- Viewing the contents of a table -- Checking for journaling -- Running SQL scripts -- Appendix C. Troubleshooting -- Using the LEI log (leilog.nsf) -- Using the Domino log (log.nsf) -- Enabling log conflicts in replication activities -- Logging SQL statements -- Using the trace metaconnector -- Using Notes Server Diagnostic (NSD) -- Using spool file output -- Using the OS/400 command line interface -- Using iSeries Navigator -- Appendix D. Additional material -- Locating the Web material -- Using the Web material -- How to use the Web material -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Index -- Back cover