Implementing IBM Lotus Enterprise Integrator 6 on the IBM e server iSeries Server

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...

Descripción completa

Detalles Bibliográficos
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Otros Autores: Landon, Deb (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: [S.l.] : IBM, International Technical Support Organization c2003.
Edición:1st ed
Colección:IBM redbooks.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627113806719
Tabla de Contenidos:
  • 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.