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...
Autor Corporativo: | |
---|---|
Otros Autores: | |
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.