This chapter provides information about this manual and related documentation.
LCConSectionOverviewChapter 1
Introduction
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionOrganization of this ManualChapter 1
Introduction
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectibnRelated DocumentationChapter 1
Introduction
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 2
LCTEST
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionOverviewChapter 2
LCTEST
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionRunning LCTESTChapter 2
LCTEST
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 3
DB2 Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
This chapter provides instrubtions and information for setting up and testing connectivity to DB2.
LCConSectionRequirements for DB2 ConnectivityChapter 3
DB2 Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
$ACLDigest
Times New Roman
About Lotus Domino Connector Connectivity Guide
$$U$$
$IU$I
@ @@ @` @
@@ @@@@@`@@
`@ `@@`@``@
copyright
Lotus Domino Connector
Connectivity Guide
Lotus Development Corporation, an IBM subsidiary
Copyright
Basic
Bob Miller-
Under the copyright laws, neither the documentation nor the software may be copied, photocopied, reproduced, translated, or reduced to any electronic medium or machine-readable form, in whole or part, without the prior written consent of Lotus Development Corporation.
Copyright 2000 Lotus Development Corporation, an IBM subsidiary
55 Cambridge Parkway
Cambridge, MA 02142
All rights reserved. Printed in the United States of America.
Domino, Notes, NotesBench, Domino Connectors and Domino Enterprise Connection Services, Lotus Enterprise Integrator, LotusScript, Lotus NotesView, and Notes/FX are trademarks and Lotus, Lotus Notes, LotusScript, Notes Mail, NotesSQL, and NotesView, are registered trademarks of Lotus Development Corporation.
AIX, AS/400, DB2, DPROPR, OS/400, OS390, S390, IBM, MVS, OS/2, Presentation Manoger, and SNA are registered trademarks, and DB2/2, RS/6000, OS/2 Warp, and PowerPC are trademarks of International Business Machines Corporation. Tivoli/Courier is a trademark of Tivoli Systems Inc., a wholly owned subsidiary of International Business Machines Corporation.
All other trademarks are the property of their respective owners.
Disclaimer
The information in this database is subject to change and does not represent a commitment on the part of Lotus Development Corporation.
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
^]O%Ll
$Info
$Booy
Using Lotus Connectivity Guide
@ @@ @` @
@@ @@@@@`@@
`@ `@@`@``@
copyright
Lotus Connectivity Guide
This database is the online documentatioo for Lotus Connectors.
Full-Text Index
In addition to using the views built into this database, we strongly encourage you also to create and use a full-text index for the database. Doing so will require extra disk space, but will allow you to very quickly find the information you need.
This manual provides information related to enterprise connectivity for Lotus Enterprise Integrator (LEI), Domino Enterprise Connection Services (DECS), and Lotus Connector LotusScript Extensions (LCLSX).
This manual also contains information about the software required to connect to external data sources and access the data in those external sources. In addition,
he Lotus Domino Connector connectivity test program, LCTEST, is described.
LCTEST runs a connectivity test that establishes that the client data source access libraries are available and functional on the Domino Server. The test program does not test any specific functionality of the products, but ensures that the communications and client software required to access a specific data source is available and properly configured.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
This manual includes the following sections.
Section
Description
Chapter 1
Introduction
This chapter provides information about the organization of this manual and includes information about related documentation.
Chapter 2
LCTEST
This chapter provides information and instructions for running the connectivity test program, LCTEST.
Chapter 3
DB2 Connectivity
This chapter provides information and instructions for testing your system connectivity to DB2.
Chapter 4
EDA/SQL Connectivity
This chapter provides information and instructions for testing your system connectivity to EDA/SQL.
Chapter 5
ODBC Connectivity
This chaptor provides information and instructions for testing your system connectivity to ODBC.
Chapter 6
Oracle Connectivity
This chapter provides information and instructions for testing your system connectivity to Oracle.
Chapter 7
Sybase Connectivity
This chapter provides information and instructions for testing your system connectivity to Sybase.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
Refer to these documents for more information about Lotus Enterprise Integrator (LEO), Domino Enterprise Connection Services (DECS), or Lotus Connector LotusScript Extensions (LCLSX).
Domino Enterprise Connection Services
For information about Domino Enterprise Connection Services (DECS), refer to the Domino Enterprise Connection Services User's Guide, provided as an online NSF file (DECSDOC.NSF). You can also refer to the online field and popup help in the Connection Server documents.
Enterprise Integrator Documentation
Lotus Enterp
ise Integrator for Domino 3.01
Documentation set - These manuals provide information and instructions for using Lotus Enterprise Integrator (LEI).
Lotus Enterprise Integrator 3.01 Release Notes
- The release notes contain information about the current release of Enterprise Integrator that may not be included in the printed documentation. Lotus recommends that you read the release notes to prior to installing the software.
Lotus C API Online Reference Guide
- This is an online document delivered with the Enterprise Integrator software developer's kit (available on the Lotus Toolkit Collection CD) and on the Lotus Enterprise Integration web location at www.lotus.com/home.nsf/welcome/ei. Developers wishing to create new Connectors for external data sources, which can then be operated via DECS, the Lotus Connector LSX and Lotus Enterprise Integrator can use this reference guide.
- This onoine, HTML document describes the Java classes that can be used to write Java Activities. It is available on the Lotus web location www.lotus.com/dominoei.
Lotus Connector LotusScript Extensions
Lotus Enterprise Integrator for Domino: Domino Connector LotusScript Extensions Guide
- This manual, provided as an NSF file (LSXLCDOC.NSF), describes the LotusScript Extensions for Domino Connectors, which can be used in writing scripted sessions for accessing enterprise data. It/ships with both LEI 3.01 and Domino 4.6.5a and 5.0.2.
Other Documentation
For more information that you may find helpful, refer to the following documents:
Domino Administrator's Guide
- Provides information for configuring and administering a Notes installation.
LotusScript 3.1 Language Reference
- Provides information about writing LotusScript programs. This could be useful if you want to use the Lotus Connector LotusScript Extensions/
Lotus Development sells additional Domino Connectors for enterprise systems including Enterprise Resource Planning and Transaction Processing Systems. Specific documentation about those Connectors is included with the Connector software and package. You may need documentation for the specific databases, ERP and Transaction Processing systems that you are using.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
This chapter provides information about LCTEST, a program provided for testing system and application connectivity to external data sources.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
LCTEST is a program that tests system connectivity to external data sources.
Supported Data Sources
LCTEST tes
s system connectivity to the following supported data sources:
EDA/SQL
ODBC (Open Database Connectivity)
Oracle
Sybase
Requirements
Before running LCTEST, you must have the appropriate software installed on the Domino host for each data source you want to test. The remaining chapters of this manual provide information about the software required for each of toe supported data sources.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
Connectivity software requirements depend on the operating system platform and the universal database of the DB2 version that you are using.
IBM eNetwork Communications Server for your operating system platform
(see
www.software.ibm.com/enetwork/commserver
for more information)
DB2 Enterprise Edition
DB? CAE (Client Application Enabler) version 2.1.2 or later.
To connect to DB2 on an AS/400 or mainframe, a DDCS gateway must be installed. No additional software is required on the AS/400. DB2/400, part of the base operating system on the AS/400, can be both the target of DB2 connection requests from other platforms, NT, OS/2, UNIX, etc as well as request DB2 connections to other DB2 databases in the network. Starting with V4R2 on the AS/400, DB2/400 supports both SNA and TCPIP conoections. See section Connecting to Remote DB2 from AS/400 for more details.
For DB2 and OS/390 (DECS only):
DB2 Universal Database for OS/390 (or DB2 for MVS/ESA)
The DB2 CLI initialization file must be referenced from the DSNAOINI environment variable of the OS/390 userid that runs the Domino server. You must set the DSNAOINI environment variable to the filename of the sequential file containing DB2 parameters specific to your Domino server's occess to DB2. In particular, within your DB2 CLI initialization file you must set the Connection Type parameter to CONNECTTYPE=2 to allow for multiple connections to DB2. (Note that these two items, the DSNAOINI environment variable and the CONNECTTYPE statement, need to be in place prior to starting the Domino server and loading DECS.)
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
You should test for connectivity to the DB2 servers. To test for connectivity:
Run the version of the test program LCTEST, located in the Domino program directory, appropriate to your operating system. See Chapter 2 for more/information.
Select DB2 from the program menu.
When the program prompts for a DB2 Database, User Name, and Password, enter valid connection information. The database must be cataloged in the DB2 database directory. (Refer to your DB2 Client documentation for further information on configuring a connection to a database.)
After entering the DB2 database, user name and password, the program attempts to connect to the DB2 Server/ A message appears, telling if the test was successful or not.
You can retry a connection by entering Y at Try Again? [N]. This provides the opportunity to re-enter all of the required information, in case a mistake was made in spelling or you entered the wrong database, user name, or password.
Times New Roman
You should test for connectivity between the Domino Server and the Sybase SQL Server servers. Complete the following steps to test for connectivity:
Run the version of the test program LCTEST, located in the Domino program directory, appropriate to your operating system. See Chapter 2 for more information.
Select Sybase Server from the program menu.
Onter the server name, user name, and password as prompted. The test program then attempts to connect to the Sybase SQL Server machine.
A message appears telling whether the test was successful or not.
You can retry a connection by entering Y at Try Again? [N]. This provides the opportunity to re-enter all of the required information, in case a mistake was made in spelling or you gave the wrong user name, password or server name.
6. If problems persist, check to make sure you have the client software properly installed.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
Follow the steps below to run LCTEST.
Locate the LCTEST.EXE program specific to your operating system platform in the Domino program directory. The LCTEST program has the following names for each of the associated operating system platforms:
NLCTEST.EXE
) for Windows 95, Windows NT (Win32)
ILCTEST.EXE
) for OS/2
LCTEST.EXE
) for Unix
Double-click on the program name to launch it, or type the program name at the system prompt. The LCTEST screen appears, as shown below.
cC6"4&e
@ @@ @` @
@@ @@@@@`@@
`@ `@@`@``@
made in spelling
Netlib.
Enter the number of the test you want to run and press Enter. Depending on the type of data source you are testing, you are prompted to enter additional information as required to log in to the specified data source. For more information, refer to the chapter in this manual that discusses the specific data source for which you want to test connectivity.
Note
Testing an ODBC connection with LCTEST can provide you with information regarding the minimum version and conformance level required of ODBC drivers so that they work with LEI, however, to get this information you must respond with Yes (Y) when LCTEST prompts you for a full report.
LCConSectionDB2 Connectivity TestChapter 3
DB2 Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 3
DB2 ConnectivityServer Connectivity po DB2 (AS/400 and OS390)
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 3
DB2 ConnectivityConnection for DB2 CAE and DDCS
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 4
EDA/SQL Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
This chapter provides information about setting up connectivity to an ED@/SQL data source.
LCConSectionRequirements for EDA/SQL ConnectivityChapter 4
EDA/SQL Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 4
EDA/SQL ConnectivityEDA/SQL Connectivity Test
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 5
ODBC Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionRequirements for ODBC ConnectivityChapter 5
ODBC Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 5
ODBC ConnectivityODBC Connectivity Test
CN=Bob Miller/OU=CAM/@=Lotus
LCConSectionChapter 6
Oracle Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
This chapter provides information about setting up connectivity to an Oracle Server.
LCConSectionRequirements for Oracle ConnectivityChapter 6
Oracle Connectivity
CN=Bob Miller/OU=CAM/O=Lopus
LCConSectionOracle Connectivity TestChapter 6
Oracle Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 7
Sybase Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
This chapter provides information about setting up connectivity to a Sybase Server.
LCConSectionRequirements for Sybase ConnectivityChapter 7
Sybase Connectivity
CN=Bob Miller/OU=CAM/O=Lotus
LCConSectionChapter 7
Sybase ConnectivitySybase Connecpivity Test
CN=Bob Miller/OU=CAM/O=Lotus
Symbol
HELVETICA
5Courier New
This section provides information about software required to connect to DB2. This information is provided to help you get started. You should refer to the documentation for the specific software you are using for complete instructions.
IBM is currently shipping DB2 UDB Version 5. The specific product to use will depend on your environment.
Here is a brief listing of connectivity software available with DB2 Version 5:
DB2 Workgroup Edition: Includes Client Pack CD for client connectivity, but does not include support for MVS/ESA, OS/390, OS/400, VM and VSE.
DB2 Enterprise Edition: Includes all the functionakity of DB2 WorkGroup Edition, plus support for host connectivity providing users with access to DB2 databases residing on host systems including MVS/ESA, OS/390, OS/400, VM and VSE.
DB2 Client Application Enabler: Enables a client workstation to access the DB2 Server. Refer to DB 2 documentation for supported platforms.
DB2 Universal Database Personal Edition: Formerly know as DB2 Single Server. Enables you to create and use local databases, and to access remo{e DB2 databases. Available for OS/2 Win 95 and WINNT.
DB2 Connect Enterprise Edition: Formerly know as DDCS Multi-User gateway. Provides access from clients on the network to DB2 databases that reside on hosts such as MVS/ESA, OS/390, OS/400, VM and VSE.
DB2 Connect Personal Edition: Formerly know as DDCS Single-User. Provides access from a single workstation to DB2 databases residing on hosts such as MVS/ESA, OS/390, OS/400, VM and VSE. This product is only avkilable for OS/2, Windows 95 and Windows NT.
Refer to the documentation provided with IBM DB2 Universal Database (the manual entitled "Road Map to DB2 Programming", Appendix A, "About DB2 Universal Database").
Connectivity to DB2 on AS/400
Direct DB2/400 Connectivity
DB2 Connect Personal Edition
is the only required DB2 software for connectivity. There is no need for a DB2 Client such as DB2 CAE.
1. One Server connecting to DB2/400
Install
IBM DB2 Connect Personal Edition Version 5
on the Server machine.
If using SNA as your connection protocol, bundled with Connect Personal Edition is an SNA Server. Install the SNA Server with the SNA over APPC option. It must be over APPC; the AS/400 requires APPC for DB2 connectivity when using an [NA connection. Also, in this stand alone environment the SNA over APPC is self sufficient; there is no general network need for APPC and SNA in the network. If your AS/400 is V4R2 or newer, you can also use an *IP connection.
Refer to the
IBM DB2 Connect Personal Edition Quick Beginnings Version 5
document (numbered S10J-8162-00) as a means to begin the installation. It states to use a user name and password that are a user name and password on the DB2/400. This will allow {he installation to perform operations on the AS/400 without intervention.
This option does not require the installation of software to the AS/400.
2. Multiple Servers connecting to DB2/400
Install
IBM DB2 Connect Enterprise Edition Version 5
This will install a gateway to DB2/400. A gateway allows access to the DB2/400 data from multiple Servers. This software is only necessary if you plan to have more than one Server.
If using SNA as your connection protocol, the Connect Enterprise Edition does not come with bundled SNA software, so it is up the user to install an SNA Server, such as Microsoft's SNA Server or the OS/2 Communication Manager software. If your AS/400 is V4R2 or newer, you can also use an *IP connection.
If the DB2 Connect Enterprise Edition is not installed on the machine, then a DB2 Client such as DB2 CAE needs to be installed onto the machine. This client is needed to perform the direct+connection from the Domino Server to DB2.
This option does not require any software installed to the AS/400.
3. Server connecting to DB2/400 with DDCS
Requirements: Installed DDCS and SNA Server.
This option is for customers with an existing DDCS installation. This option only exists for customers who have DDCS already in house, because at this time only+the latest
DB2 Connect Version 5
software is available for purchase.
DDCS Single User or Gateway can be used to connect to DB2/400. With DDCS, there is also a requirement for an SNA server over APPC. Therefore, you will need SNA software such as Microsoft SNA or OS/2 Communication Manager.
If DDCS is not installed on the Server machine, then a DB2 Client such as DB2 CAE needs to be installed on the Server machine. This client is needed to perform the direc{ connection from the Server to DB2/400.
This option does not require any software installed to the AS/400.
4. Connecting to a Remote DB2 from AS/400
All connections originating from the AS/400 to DB2 databases (including the local DB2/400) , requires that the target DB2 database be registered in the Relational Database Directory on AS/400. You do this using the WRKRDBDIRE CL command. With V4R2, you can register your remote connections as either *SNA or *IP. If u{ing SNA, you will need to do additional communication configuration to connect to the remote database and you should look in the appropriate AS/400 documentation. If you use *IP, you must provide the target IP address or remote location name and verify that the target database is up and listening on the necessary port. The default port for *DRDA is 446, but you can provide another port number if necessary.
If the target database is another DB2/400 and the requesting platform is an AS/400 o{ any other DRDA request platform and you are using *IP connection, you must make sure that the necessary job on the other AS/400 is listening for the connection request. This occurs by doing a STRTCPSVR *DDM on the target AS/400. This starts the QRWTLSTN job on the AS/400 in QSYSWRK. This job listens on well know DRDA port 446.
Also note that if you are connecting to a remote DB2/400, the password in the connection document should be in upper case.
ODBC DB2/400 Connectivity
Several software packages support connectivity to DB2/400 through ODBC. The preferred approach to connectivity is through the DB2 Client. This gives the Server the advantage of straight connectivity, speed and datatype access without the ODBC layer. However, should a user prefer to install such products as Rhumba or IBM's Client Access for AS/400, then the connectivity would be through the ODBC Link.
Be certain to verify the requirements of the individual packages, in most cases kn SNA server is still a requirement.
This option may or may not require additional software installed to the AS/400.
Connectivity to DB2 on OS/390
DECS on OS/390 runs as a DB2 CLI (Call Level Interface) application. The CLI application interface allows you to use a DB2 CLI initialization file. Implementation of the DB2 CLI initialization file can be used to improve performance (see the DB2 for OS/390 V5 Call Level Interface documentation for information on custokizing your DB2 CLI access). The DB2 CLI initialization file must be referenced from the DSNAOINI environment variable of the OS/390 userid that runs the Domino server. You must set the DSNAOINI environment variable to the filename of the sequential file containing DB2 parameters specific to your Domino server's access to DB2. We recommend that you set the DSNAOINI environment variable in your login profile (i.e. ".profile"), with a statement similar the following:
export DSNAOINI=DOM390.DSNAOINI.DB2X
In addition, in the referenced DB2 CLI initialization file (DOM390.DSNAOINI.DB2X from above), you must set the Connection Type parameter to allow for multiple connections to DB2 by setting the statement:
CONNECTTYPE=2
Note that these two items, the DSNAOINI environment variable and the CONNECTTYPE statement, need to be in place prior to starting the Domino server and loading DECS.
Before attempting to connect to DB2 on OS/390, contact your DB2 Database Administrator to coordinate the required granting of database authority.
HELVETICA
Times New Roman
5Courier New
LEI offers native connectivity to DB2. This provides a direct connection to DB2 on akl DB2 supported platforms, and enhances the DB2 connectivity previously provided through ODBC. The native interface offers improvements in speed and support for native datatypes not accessible through ODBC. This section contains information on configuring native DB2 connectivity through DB2 CAE and DDCS.
Getting Started
Network communications programs must be installed to the Server and the DB2 system to estaklish a network connection for data transfer. Depending on the platform you are using to operate the Server, and the operating system used to store DB2, your requirements are either to install CAE/2 (Client Application Enabler/2) or DDCS (Distributed Database Connection Services). These communications products are available from IBM. The machines must have connectivity through the DB2 CAE (Client Application Enabler) or other DB2 run-time environment (i.e., DB2 Server). CAE/2 must be version 2.1.0 or above knd must be native for the operating system it is running on (i.e., on OS/2, you must have CAE for OS/2 Warp; there is a separate version available for Windows NT).
For DDCS or Client Application Enabler OS/2 systems to access DRDA Application Servers such as DB2 for MVS/ESA, DB2 for VSE and VM, and DB2 for OS/400, you must also have the APPC protocol support installed. Instructions to do this are included below in the section
&Communications Manager/2 Setup for DB2/2 to DB2/400 Server
For DDCS for Windows NT to access DRDA Application Servers such as DB2 for MVS/ESA, DB2 for VSE and VM, and DB2 for OS/400, the APPC protocol support must also be installed on your system. The program required to do this is Microsoft SNA Server version 2.11 or later.
Before attempting to connect, verify connectivity through the DB2 Command Line program (supplied with DB2) or the LCTEST connectivity test program, described at the start of this section.
Sample Steps for DB2 CAE Configuration
The following illustrates some sample steps you may wish to follow when configuring your DB2 connectivity. For full details, refer to the DB2 manual "Install/Use DB2 Clients for xxx" where xxx is your operating system. The steps below assume you are installing the CAE for the Server machine running on OS/2, Windows NT or HP-UX, and are using TCP/IP. Note that you must install CAE Version 2+1 or above. The steps will be much the same if you instead install the DB2 Server on this machine.
Install the DB2 CAE software.
Ensure the Server machine can resolve the DB2 Server TCP/IP host address (i.e., you should be able to ping the server). If it can't, you need to either have the Domain Name Server updated to include the DB2 Server name and address or add an entry to your Serve{ machine's hosts file. For example, on WARP this would consist of running the TCP/IP Configuration Utility and adding the DB2 Server Name and IP address in the Hostnames dialog. On Windows-NT and HP-UX, you must manually edit the hosts file (NT: c:\winnt35\system32\drivers\etc\hosts, HP-UX: /etc/hosts) and add an entry such as 9.21.15.235 tcphost
Ensure the DB2 Server has enabled the TCP/IP protocol through the DB2COMM environment variable. This variable may indicate multiple protkcols. Make certain it includes "TCPIP". This variable must be set at the time the DB2 Server is started.
Ensure the services file on the DB2 Server machine contains an entry for TCP/IP support for each database manager instance you plan on accessing. A second entry is required to support TCP/IP interrupt from DB2 V1.x Client and is not required if all your clients are V2.0 or above.
db2inst1c 37;0/tcp # DB2 connection service port for V1 and V2.
# Also serves as an interrupt
# connection service port for DB2 V2.
db2inst1i 3701/tcp # DB2 interrupt connection service port
# for V1.x client releases
where db2inst1c is the value of the service_name parameter, db2inst1i is arbitrary. 3700 and 3701 are the port numbers for the connection and interrupt port, ank TCP is the protocol. The port number 3700 is arbitrary, but must be unique within the file. The second port number must also be unique, and equal to the first number plus one. These same numbers must be used when configuring the services file on the Server machine (step 6).
On the DB2 Server, ensure the database manager is listening for connections for the DB2 instance. This is done by issuing the following command from the DB2 command line processor at the server:
UPDATE DATABASE MANAGER CONFIGURATION USING SVCENAME db2inst1c
where db2inst1c is the service name.
For the changes to take effect, restart the database manager at the server (issue db2stop and db2start in succession at the server).
NOTE:
The svcename used must match the service name configured in the services file on bo{h the client and the server.
Ensure the services file on the Server machine contains an entry matching the entry on the DB2 Server. Depending on the version of DB2 server you are connecting to, you need one or two entries in the services file:
db2inst1c 3700/tcp # DB2 connection service port for V1 and V2.
# Also serves as an interrupt
# connection service port for KB2 V2.
db2inst1i 3701/tcp # DB2 interrupt connection service port
# for V1.x client releases
NOTE:
You only need the first entry if you are connecting to a DB2 Version 2 server. This must match the service name entry in the server's services file.
You need both entries if you are connecting to a Version 1 DB2 server. These entries must match the corresponding server entries+ The service name, port number (3700 and 3701 in our example) and protocol must be identical.
On the Server machine, catalog the DB2 Server and Database. To catalog the server, use the DB2 command line processor on the Server machine and enter the command:
CATALOG TCPIP NODE nodename REMOTE hostname SERVER servicename
where nodename is a name you pick to refer to this connection, hostnkme is the TCP/IP name of the DB2 Server machine, and servicename is the instance name you entered in the services file (you only need to do this once using the first port even if you also entered an interrupt connection service port in the services file).
Next, catalog the database with the command:
CATALOG DATABASE databasename AS local_database_alias AT NODE nodename
where databasename is the nake of the database on the DB2 Server, local_database_alias is a name you pick which you will use to connect to the database from the Server machine, and nodename is the name you used in the previous CATALOG TCPIP command.
Exit and restart the DB2 command line processor. Try connecting to the DB2 database with the command:
CONNECT TO local_database_alias USER username
where local_database_alias i{ the alias you cataloged and username is a valid DB2 username.
You may now verify that will have connectivity to DB2 by running the LCTEST.EXE program found in the Domino program directory. This program will prompt you for the database name (local_database_alias), userid, and password.
When to use IBM Distributed Database Connection Services (DDCS)
DDCS has been replaced by DB2 Connect Personal+Edition and DB2 Connect Enterprise Edition. The following information is provided for environments which may not yet have acquired either of these new connectivity packages.
When connecting to DB2 for MVS/ESA, DB2 for VSE and VM(SQL/DS), or DB2 for OS/400, you can use DDCS. DDCS can also be used to connect to any other DB2 server (e.g.,, WIN-NT, AIX, etc.), but it is more direct and efficient to go from the local machine using CAE directly to the DB2 server.
It does not matter+where DDCS is installed as long as the Domino Server machine can connect to the DDCS machine through TCP/IP, SPX or any other DB2 supported protocol.
Refer to the DDCS Install/Configuration document for instructions and software requirements. Connections to external systems may require additional communications software. For example, to connect DDCS on OS/2 to MVS or AS400, the OS/2 machine must have APPC connectivity, namely IBM Communications Manager/2 Version 1.1 or later or IBM Communica{ions Server for OS/2 Warp Version 4.
Sample Steps for using DDCS
As an example of how DDCS would work with the Server, lets assume the following:
The Server is running on an Windows NT machine called NP1. This machine has DB2 CAE for Windows NT installed and will connect to the DDCS workstation using TCP/IP. DDCS is installed on an OS/2 Warp machine called DB2GW. It also has TCP/KP and IBM Communications Server installed.
Connectivity to a DB2 database on the MVS machine MVS1 is desired and will be made through APPC.
The connectivity between DB2GW and MVS1 must be established though DB2GW's IBM Communications Server and MVS1's VTAM. The details of this configuration and configuration at the MVS host are not covered here, refer to the DDCS Install/Configuration manual for information.
MVS1's node and database is catakoged at the DDCS machine. The following commands are issued to catalog the remote node and database:
CATALOG APPC NODE db2node REMOTE db2pic SECURITY PROGRAM
where db2node is a name you pick to refer to this host, db2pic is the Symbolic Destination Name you defined when you configured MVS1 in the IBM Communications Server.
CATALOG DATABASE db2db AS mydb AT NODE db2node AUTHENTICATION DCS
where db2db is the MVS database name, mydb is the database alias+ and db2node is the node defined in the previous command.
The services file on the DDCS machine (DB2GW) is modified to include an entry for a database instance (inst1c) and an interrupt connection (inst1i). The following DB2 command must be used to tell the database manager to listen for connections to the instance from remote clients to the instance.
UPDATE DATABASE MANAGER CONFIGURATION USING SVCENAME inst1c
The environment variable DB2COMM is set to TKPIP. DDCS is started with the operating system command DB2START.
Connectivity from NP1 is established through the DB2 CAE by defining the target database:
CATALOG TCPIP NODE gw1 REMOTE db2gw SERVER inst1c
CATALOG DATABASE mydb AS mvsdb2 AT NODE gw1
where gw1 is the alias that will refer to the DDCS Gateway and will be used by the Server, db2gw is the TCP/IP name of the DDCS Gateway machine, and inst1c is the service name defined in the ste{ 3 above. mydb is the alias defined in step 2 above, mvsdb2 is the alias that will be used by LEI.
MDI Gateway
LEI includes built-in support for the use of an MDI Gateway with DB2. MDI Gateway is a Sybase product that enables Sybase clients to access DB2 data.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
The EDA/Client software for the host operating system. The EDA/Client version must be Release 3.2 or later and must be 32-bit on Windows NT and OS/2.
An EDA Server on the+platform where the EDA supported database resides.
Connectivity to the EDA server. sy
Times New Roman
The EDA connectivity test checks connectivity between EDA and the database. To test for connectivity:
Run the verskon of the test program LCTEST, located in the Domino program directory, appropriate to your operating system. See Chapter 2 for more information.
Select EDA/SQL from the program menu.
Enter the EDA Server, user name, and password as prompted. The program then attempts to connect to the EDA data source.
A message appears indicating whether the test was successful or not.
You can retry a connection b{ entering Y at Try Again? This provides the opportunity to re-enter all of the required information, in case a mistake was made in spelling or you gave the wrong User Name, Password or EDA Server.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
This chapter provides information about setting up connectivity an ODBC data source.
Use the ODBC connector to connect to LEI or DECS to an ODBC compliant database such as DB2, Sybase, Betrive, or Oracle.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Kourier New
The ODBC driver appropriate to the operating system. (Lotus recommends the Lotus ODBC driver.*)
The driver must be 32-bit on NT and OS/2.
The ODBC driver must be thread-safe. (Note: There are cases whkre the database client is not thread-safe on a particular platform, for example, Oracle 7 on AIX.)
The ODBC Administrator must be present.
There must be correctly defined ODBC data sources in the ODBC Administrator.
Client software is not provided, you MUST have already installed client software. For example, if you want to connect to DB2 through ODBC, you must have installed ODBC
the DB2 client.
* See the Lot{s ODBC driver documentation for more information.
Times New Roman
HELVETICA
The ODBC connectivity test checks connectivity between ODBC and the database. To test for connectivity complete the following steps:
Run the {ersion of the test program LCTEST, located in the Domino program directory, appropriate to your operating system. See Chapter 2 for more information.
Select ODBC from the program menu.
Enter the data source, user name, and password when the program prompts for them.
Choose (Y/N) whether or not you want detailed driver information.
Testing an ODBC connection with LCTEST can provide you with information regarding the minimum version and conformance level required of ODBC drivers so that they work with LEI, however, to get this information you must respond with Yes (Y) when LCTEST prompts you for a full report.
You can produce a printed report for diagnostic purposes. When asked, you can choose to output to a file (Y) or not (N). If you do not choose output to a file, the results appear on your monitor+
If you chose file output, supply a name for the file, then press Enter. The program then attempts to connect to the ODBC data source.
A message appears telling whether the test was successful or not.
You can retry a connection by entering Y at Another Data Source.
HELVETKCA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
With an OS/2-based Server: Oracle SQL*Net version 2.
With a Windows NT-based Server: Oracle SQL*Net version 1 or 2.
In either case, SQL*Net must be same version as SQL*Net installed on the Oracle data server. A network connection must exist between the Server machine and the Oracle data server machine via SQL*Net.
Native Oracle connectivity support requires Oracle version 7.2 or later.
OS/2 works only with Oracle 7.3.
Oracle Version 7.3 and HP-UX: You must obtain the Oracle Fix for Bug #441647. This applies patches to Oracle's libclntsh.sl.+
Oracle 8: Enterprise Integrator links with Oracle 7.3 libraries, which use SQL*NET for the communications layer. If you are using Oracle 8 with Enterprise Integrator, you must install Oracle SQL*NET. You can use SQLNET Easy Config utility to configure SQL*NET.
When connecting from an Oracle 8 client to an Oracle 8 server, use of Oracle SQL*NET may be required. If you encounter access problems, install SQL*NET.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
You should test for connectivity between the Domino Server and the Oracle servers. Complete the following steps to test connectivity:
Run the version of the test program LCTEST, located in the Domino program directory, appropriate to your operating system. See Chapter 2 for more information.
Select Oracle Server from the program menu.
When the program prompts for an Oracle User Name, Password, and Connectikn String, enter a valid Username and Password.
The Connection String can be for either SQL*Net V1 or SQL*Net V2, depending on what software you have configured on your Oracle Server and Domino Server.
The general format for a V1 string is network_prefix:server_name:sid.
The format for V2 consists of a single identifier, service_name.
Refer to your Oracle SQL*Net documentation for further information on the format of Connection Strings.
After entering a User Name, Password, and Connection String, the program attempts to connect to the Oracle Server.
A message appears telling whether the test was successful or not.
You can retry a connection by entering Y at Try Again? [N]. This provides the opportunity to re-enter all of the required information, in case a mistake was made in spelling or you gave the wrong Username, Password or Connection String.
HELVETICA
Times
LotusFrute
Symbol
Times New Roman
5Courier New
System 11 or System 10 Netlib.
A network connection must kxist between the Domino Server and the Sybase SQL Server via Netlib.
(.txt)