Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | JDBC Driver Specific Properties | DB2 | DB2 Universal Type 4
 
DB2 Universal Type 4
DataSource
Transaction Type
DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION
com.ibm.db2.jcc.DB2SimpleDataSource
XA_TRANSACTION
com.ibm.db2.jcc.DB2XADataSource
Other Properties
Specify the parameters in the Other Properties field:
Parameter
Description
driverType
Required. If the driverType is not set to 4, then Type 2 connectivity is selected by default.
driverType=4
readOnly
Creates a read only connection.
readOnly=true
currentSchema
Specifies the default schema name used to qualify unqualified database objects in dynamically prepared SQL statements.
currentSchema=YourSchemaName
loginTimeout
Maximum time in seconds to wait for the DataSource object to connect to a data source.
loginTimeout=number
traceFile
Specifies the name of a file into which this driver writes the trace information.
traceFile=fileName
traceFileAppend
Appends, instead of overwriting, the file that is specified by the traceFile property.
traceFileAppend=true
traceLevel
Specifies the level to trace.
traceLevel=number
The value of number is set to the following integer value:
*-1 to TRACE_ALL.
*2 to TRACE_STATEMENT_CALLS.
For more information, see your vendor's driver documentation.
Required Connection Property Fields
Driver
Server Name
User
Password
Database Name
Port Number
Network Protocol
DB2 Universal Type 4 for UDB 7.2, 8.1, 9.1, and 9.5
Yes
Yes
Yes
Yes
Yes
No
For more information about limitations, see Limitations.