Microsoft KB Archive/932791

= How to use the BizTalk Adapter for DB2 Connection Configuration Wizard to configure a connection string that you can use to connect to an IBM iSeries (AS/400) system or a mainframe system =

Article ID: 932791

Article Last Modified on 2/13/2007

-

APPLIES TO


 * Microsoft Host Integration Server 2006

-



INTRODUCTION
When you use the BizTalk Adapter for DB2 Connection Configuration Wizard to configure a send port or a receive location, you must complete many fields. This article describes how to use these fields to configure a connection string that you can use to connect to an IBM iSeries (AS/400) system or a mainframe system.

Note The BizTalk Adapter for DB2 is included with Microsoft Host Integration Server 2006.



MORE INFORMATION
To use the BizTalk Adapter for DB2 Connection Configuration Wizard to configure a connection string, follow these steps:  Click Start, click Programs, click Microsoft BizTalk Server 2006, and then click BizTalk Server Administration. Under Console Root, expand BizTalk Server 2006 Administration, expand BizTalk Group, expand Applications, expand BizTalk Application 1, and then click Receive Locations.

Note The name of your BizTalk group and application may be different. Right-click an existing DB2 receive location, and then click Properties. Click Configure. Click the ellipsis button (...) that is next to the connection string. The Connection Configuration Wizard starts. Click Create a new connection string, and then click Next. Configure the data source. You can select one of the following data source platforms: <ul> DB2/MVS</li> DB2/AS400</li> DB2/NT</li> DB2/6000</li></ul>

Additionally, you can select one of the following network protocols: <ul> TCP/IP</li> SNA LU6.2</li></ul>

Note Some network protocols may not be available for all data source platforms.

This example configures a data source that uses the TCP/IP protocol to communicate with an IBM iSeries (AS/400) system. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Under Data source platform, click DB2/AS400.</li> Under Network type, click TCP/IP.</li> Click Next.</li></ol> </li> Configure the TCP/IP network connection. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> In the Address or alias box, type the IP address or alias.</li> In the Port box, type the TCP/IP port number.

Note By default, the TCP/IP port number for an IBM iSeries (AS/400) system is 446.</li> Click Next.</li></ol> </li> Configure the DB2 database information. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> In the Initial catalog box, type the name of the AS/400 RDBNAME. Typically, this is the name of the IBM iSeries (AS/400) system.</li> In the Package collection box, type the name of the AS/400 library in which the packages for the provider are created and stored.</li> <li>In the Default schema box, type the default schema name. Typically, this is the name of the AS/400 library in which the tables are accessed.</li> <li>In the Default qualifier box, type the name of the default qualifier. <ul> <li>If the library that hosts the tables differs from the library that is specified in the default schema, the Default qualifier box should contain the name of the library that hosts the table. This value is used as the second value in a three-part naming scheme.</li> <li>If the library that hosts the table is the same as the default schema, leave this box blank.</li></ul> </li> <li>Click Next.</li></ol> </li> <li>Configure the locale settings. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>In the Host CCSID box, click the character code set identifier (CCSID) that matches the DB2 data.</li> <li>In the PC code page box, click a code page to use for character code conversion.</li> <li>Click Next.</li></ol> </li> <li>Configure the security settings. By default, the security method is set to interactive sign-on by using a user name and a password.

Important Earlier versions of the DB2 providers automatically converted the user name and the password to uppercase. This behavior no longer occurs. These values are now case-sensitive. We recommend that you press CAPS LOCK before you type the user name and the password, unless you are sure that the destination computer uses uppercase and lowercase passwords.

To configure the security settings, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>In the Security method box, click a security method.</li> <li>In the User name box, type the user name.</li> <li>In the Password box, type the password.</li> <li>In the Password confirmation box, retype the password.</li> <li>Click Next.</li></ol> </li> <li>Configure advanced options. The following options are available: <ul> <li>Connection pooling

Select this option to make a connection available for successive database access operations.</li> <li>Read only

Select this option to make sure that the data source cannot be updated.</li> <li>Defer prepare

Select this option to delay the preparation of the SQL statement. This optimizes the processing of parameterized INSERT, UPDATE, DELETE, and SELECT SQL commands. When you enable this option, the provider combines the preparation, execution, and commit commands together into one network flow to the remote database.</li> <li>Derive parameters

This optional OLE DB data source initialization property instructs the provider to derive parameter information from the data source when the data source is requested by the consumer.</li></ul>

After you have configured advanced options, click Next.</li> <li>Validate the connection to make sure that the connection to the data source works correctly. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Connect. The physical and logical connectivity to the destination is tested.</li> <li>After the connection test succeeds, click Sample Query. A listing of the tables in the destination library should appear. If a listing of the tables does not appear, the connection string is configured incorrectly. Make sure that you used the correct case for the user name and the password in step 11.</li></ol>

Note A Packages button also appears. Packages behave like metadata for the provider and are provider-specific. Among other settings, packages define what types of access are allowed. A detailed discussion of packages is beyond the scope of this article.</li> <li>Click Finish.</li></ol>

Use the Data Access Tool to configure a connection string
Instead of using the BizTalk Adapter for DB2 connection wizard to configure a connection string, you can use the Data Access Tool. When you use the Data Access Tool, you can save the connection string. Then, when you use the Microsoft BizTalk Server 2006 Administration Console to configure a send port or a receive location, you can click Existing connection string when the BizTalk Adapter for DB2 Connection Configuration Wizard starts.

<div class="references_section">