Choosing the number of cursors for JDBC result sets
 Technote (FAQ)
 
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.

 
Related information
DB2 UDB for z/OS and OS/390 Application Programming Gui
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS > DB Connections/Connection Pooling
Operating system(s): z/OS
Software version: 5.0
Software edition:
Reference #: 1163497
IBM Group: Software Group
Modified date: Mar 17, 2004