Thursday, February 24, 2011

DB2 Adapter Send port Configuration:

Step1 : Create two way send port with DB2 adapter
Step2: Configure the
1. Connection String :
User ID=ediuser;Password=***************;Initial Catalog=BCDB2T;Network Transport Library=TCP;Host CCSID=37;PC Code Page=1252;Network Address=host. sic.com;Network Port=4050;Package Collection=MOLE;Default Schema=MOLE;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/MVS;Defer Prepare=False;Rowset Cache Size=0;Authentication=Server;Persist Security Info=True;Connection Pooling=False;Derive Parameters=False;

2. Document Target namespace (input schema) - http://Debatching.Db2Schema.
3. Response Root Element Name : Response root(Tp_Response)
4. URI : DB2://host.lahsic.com:4050/BCDB2T/MOLE(configure Connection string automatically created this string)
Connection String configuration:
Click on Connection string button -> select new connection string radio button
Next-> set Data source flat form (DB2/MVS,DB2/AS400…)
Next->set Net work Type (TCP/IP)
Next ->Address of alias (DB2 server address eg host. sic.com)
Next -> Set Port
Next-> set the Initial catlog, Package Collection, Default schema and Database name (Database name and Initial catalog both are same)
Next ->Set Host CCID and PC Code page (default ones)
Next ->set the Security method (default –sign on), user name, password, confirm password and Authentication method (default server).
Next -> Select Connection pool, Defer prepare, derive prepare
Next -> test Connect button and packages and finish…

No comments: