Implementing IBM Lotus Enterprise Integrator 6 on the IBM e server iSeries Server / [Deb Landon ... et al.].

Format:

Book

Contributor:

Landon, Deb.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Business enterprises--Data processing.

Business enterprises.

Enterprise application integration (Computer systems).

Web servers.

Lotus Domino.

Physical Description:

xiv, 326 p. : ill.

Edition:

1st ed.

Place of Publication:

[S.l.] : IBM, International Technical Support Organization, c2003.

Language Note:

English

System Details:

text file

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

Contents:

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.

Notes:

"September 2003."

"SG24-6941-00."

Includes bibliographical references and index.

OCLC:

137342224