Connectivity with DB2 AS400?

HCL Domino Domino Forum
1

Hi, Does anybody has idea that how to connect with AS400-DB2 using Lotus Notes?

Thanx in advance.

Regards.

2

Subject: Connectivity with DB2 AS400?

Here is an excerpt of the Domino Designer help:

You can access DB2 on an iSeries system using the Lotus Connector for DB2. The procedure varies slightly depending on whether or not the DB2 database resides on the same iSeries system as the Domino server.

DB2 Database on Same iSeries System as Domino Server

Use the following procedure to access a DB2 database that resides on the same iSeries system as the Domino server.

  1. Add a relational database entry in DB2/400. An example is shown below:

ADDRDBDIRE RDB(database name) RMTLOCALNAME(*LOCAL)

  1. Create a DB2 Connection document using the relational database name in the above statement for the database name entry.

  2. Enter the user name and password for iSeries.

This user name and password should have authority to access the given database.

  1. If the table on the iSeries system is not journalled, select the “Non-Journalled Data” option in the Connection Properties section of the DB2 Connection document.

DB2 Database on a Different iSeries System than Domino Server

Use the following procedure to access a DB2 database that resides on a different iSeries system than the Domino server.

  1. Add a relational database entry in DB2/400. An example is shown below:

ADDRDBDIRE RDB(database name) RTMLOCNAME(IPaddress)

  1. Start the DDM server job on the remote iSeries by using the following command:

STRTCPSRV *DDM.

You can verify that the job QRWLSNN in subsystem QSYSWRK is active by using the WRKACTJOB command.

  1. Create a DB2 Connection Document using the relational database name in the above statement for the database name entry.

  2. Enter the user name and password for iSeries.

This user name and password should have authority to access the given database.

  1. If the table on the iSeries system is not journalled, select the “Non-Journalled Data” option in the Connection Properties section of the DB2 Connection Document.

  2. To use interactive SQL to verify that the connection to the remote iSeries is set up correctly, run the STRSQL command from your local iSeries system and then issue the following SQL command:

Connect to remote server name

You must have 5722-ST1 installed to use STRSQL.

  1. You can also test connectivity using DCTEST from the OS/400 command line:

Call Qnotes/dctest

Hinweis If this is the first time that you have used SQL to connect to a remote iSeries system, an error message (SQLPKG not found) may appear. You can run the following agent to create *SQLPKG on the remote iSeries system:

Option Public

Uselsx “*lsxodbc”

Sub Initialize

Dim con As New ODBCConnection

con.AutoCommit=False

If (con.ConnectTo("databasename","userid", "pwd")) Then

	Call con.Disconnect

End If

Print "Test Create SQL Pkg"

End Sub

I think this are pretty good instructions. If you have specific problems with this feel free to ask again.

Greetings

Ralf M Petter