|
Problem |
If you are running Java on WebSphere Z/OS
using DB2 how many cursors can be open? Can this number be specified?
Where? Where can documentation be found? Can the bind for the DSNJDBC plan
be altered to CS? Can this improve performance? Is it recomended?
|
|
|
|
Solution |
In the DB2 V7 Application Programming and Java Reference
Section "E.3 Choosing the number of cursors for JDBC result sets" gives a
discussion on how many cursor be open and where to specify them.
.
In the same manual, Section "6.1.1.7 Binding the DBRMs", it states the
install job DSNTJJCL binds DSNJDBC in isolation level RR/RS/CS/UR. The
default transaction isolation level is CS (cursor stability) and you can
change the transaction level of a connection in a JDBC program, using
Connection.setTransactionIsolation method.
|
|
|