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 Net Type 3 Driver
 
DB2 Net Type 3 Driver
Transaction Isolation Level Setting
Specify the transaction isolation level properties in the Other Properties field:
Parameter
Description
TransactionIsolation
Non-repeatable read does not function when you set the transaction isolation level to 2.
TransactionIsolation=2;
Other Properties
Specify the parameters in the Other Properties field:
Parameter
Description
clischema
Use the clischema property to enable an adapter polling notification if the triggers for the notification already exist.
*You must create a systriggers view in the sysibm.systriggers table.
*Specify the schema in which the view was created against the clischema property.
Thus the adapter redirects the query for triggers to the appropriate schema. For example:
clischema=schema_name
Required Connection Property Fields
Driver
Server Name
User
Password
Database Name
Port Number
Network Protocol
DB2 Net Type 3 for OS/390 V6 and V7
Yes
Yes
Yes
Yes
Yes
No
DB2 Net Type 3 for UDB V7.2 and V8.1
Yes
Yes
Yes
Yes
Yes
No
Note:
The DB2 net type 3 driver property portNumber is the same as the DB2 JDBC Applet server's port number. The default is 6789.
For more information about limitations, see Limitations.