Element Details: Connection.DB2
 Back


Available in: Logi Info Source code name: Connection.DB2

The Connection.DB2 element sets the parameters required to connect to a DB2 database.

In order to use this element you must have installed the Net 2.0 data provider for DB2 from IBM. The data provider is typically included on your DB2 CD or can be downloaded from the IBM web site.

Element Group:Relational Databases



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
CommandTimeOut
UserDefined
The CommandTimeOut attribute specifies the amount of time, in seconds, before the request to connect to the data source is presumed to have failed. For most data sources, the default value is 60 seconds. For MySql, the default is 30 seconds.
DB2ConnectionString
UserDefined
A full connection string to the DB2 database. If a value is defined, it will override all other settings for the connection element and use this string to connect to the database. DB2 Parameter elements are still processed and added to the string.
DB2Database
UserDefined
(Required) The name of the DB2 database.
DB2Flavor
iSeries
This attribute when set to ISeries allows the IBM DB2 ISeries data provider to be utilized instead of the default DB2 Universal provider. In DotNet the IBM I Access for Windows product is required. The IBM.Data.DB2.ISeries.dll needs to be installed in the Logi bin directory as well. http://www-03.ibm.com/systems/power/software/i/access/windows_sp.html In Java the IBM ISeries Toolkit JDBC driver jt400.jar needs to be installed in WEB-INF/lib. http://www-03.ibm.com/systems/power/software/i/toolbox/downloads.html
DB2Password
UserDefined
The password for the DB2 database.
DB2Port
UserDefined
The port address for the DB2 database.
DB2Server
UserDefined
(Required) The host name of the DB2 database.
DB2User
UserDefined
(Required) The user name for the DB2 database.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.



PARENT ELEMENTS

Click element to drill down for more information.

Connections Studio Connection


CHILD ELEMENTS

Click element to drill down for more information.

DB2 Parameters Metadata Studio Connection


 Back to top


 Chart Debug