DB2 graphic  QMF Version 8

Binding

Use the Binding page to allow users assigned to this resource limits group and using this schedule to bind or drop static packages for their queries to or from the database server.

Table 23. Resource Limits - Binding Fields
Field Description
Allow binding of packages Specifies whether users can bind static packages for their queries.
Allow dropping of packages Specifies whether users can drop static packages from the database server.
Default collection ID Specifies the default collection ID for static packages bound by users.
Default collection ID can be overridden Specifies whether a user must use the Default collection ID or can specify any collection ID, subject to database security authorizations.
Default isolation level for packages The default isolation level for static packages bound by users:
  • Repeatable read (RR): The execution of SQL statements in the package is isolated (protected) from the actions of concurrent users for rows the requester reads and changes, including phantom rows.
  • All (RS): The execution of SQL statements in the package is isolated (protected) from the actions of concurrent users for rows the requester reads and changes.
  • Cursor stability (CS): The execution of SQL statements in the package and the current row to which the database cursor is positioned are isolated (protected) from the actions of concurrent users for changes that the requester makes.
  • Change: The execution of SQL statements in the package is isolated (protected) from the actions of concurrent users for changes the requester makes.
  • No Commit (UR): The execution of SQL statements in the package is not isolated (protected) from the actions of concurrent users for changes the requester makes.
Default isolation level can be overridden Specifies whether a user must use the Default isolation level or can specify any isolation level.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004