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.