How to Connect to Protocols in IBM DB2

This article deals with connection string related to different protocols such as TCP/IP and APPC in IBM DB2.
  • 1758

TCP/IP

The command given below is a connection string used for connecting to TCP/IP protocol. TCP/IP consists of two important protocols: Transmission Control Protocol and Internet Protocol. TCP/IP protocol provides connectivity for connection between different protocols. So in order to implement it use the following connection string.

Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=192.1.1.1.;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=Username;Password=User_password;

APPC

The command given below is a connection string used for connecting to Advanced Program to Program Communication protocol. It is protocol used for connecting various computer progarms and devices over a network. This protocol works over application layer in the OSI model. So in order to implement it use the following connection string.

Provider=DB2OLEDB;APPC Local LU Alias=Use_Alias;APPC Remote LU Alias=user_Remote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=Username;Password=User_password;

Further Readings


You may also want to read these related articles.

Ask Your Question

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.