Transaction Type | DataSource Class |
NO_TRANSACTION, LOCAL_TRANSACTION | com.ibm.db2.jcc.DB2SimpleDataSource |
XA_TRANSACTION | com.ibm.db2.jcc.DB2XADataSource |
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: ![]() ![]() For more information, see your vendor's driver documentation. |
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 |