We are currently running into concurrency problems with a java stored procedure we built out of the db2 Stored Procedure Builder. We believe that if we can reset the isolation level of the package to Repeatable Read (rather than the default Cursor Stability), then our concurrency problems will be over. The only problem is, there doesn't seem to be any way of specifying this isolation level out of the SPB, and the documentation from IBM is at best cryptic. Does anyone know how to alter the precompilation parameters or bind parameters for SPB to generate a package with an isolation level other than the default? Has anyone else run into this problem and come up with a workable solution?
Note: we are building on NT for both NT and AIX platforms, UDB 6.
Note: we are building on NT for both NT and AIX platforms, UDB 6.