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