The StaticBinder utility can create four different versions
of a package, each version at a different isolation level. This utility
can also create packages for single isolation levels.
By default, the pureQuery
StaticBinder utility
creates four packages or DBRM files, one for each of the four DB2® isolation levels. The pureQuery
StaticBinder utility
identifies the isolation level by appending the following numbers
to the root names of the packages or DBRM files:
- 1
- For isolation level Uncommitted Read (UR)
- 2
- For isolation level Cursor Stability (CS)
- 3
- For isolation level Read Stability (RS)
- 4
- For isolation level Repeatable Read (RR)
If you use the -forceSingleBindIsolation option
when you run the Configure utility, however, the number for the isolation
level is not appended to the name of the created package.
If you use the -isolationLevel option
when you perform a bind or specify the isolation level in the bind
options string, only the package or DBRM file for the isolation level
that you specify is created. The name follows the convention that
the StaticBinder uses when creating packages or
DBRM files for all four isolation levels.