Specifying Binding resource limits
On the Binding page of the Edit Resource Limits Group Schedule window you specify whether users assigned to this resource limits group and using this schedule can bind or drop static packages for their queries to or from the data source.
Binding resource limits can only be set for data sources. The Binding resource limits are as follows:
- Allow binding of packages
- This field specifies whether or not you can bind static packages for your queries on the database data source.
- Allow dropping of packages
- This field specifies whether or not you can drop static packages from the database data source.
- Default collection ID
- This field specifies the default collection ID for the static packages that you bind.
- Default collection ID can be overridden
- This field specifies whether you must use the default collection ID. If this check box is selected, you can specify any collection ID subject to database security authorizations. If this check box is clear, you must use the default collection ID that is specified in the Default collection ID field.
- Default isolation level
- This field specifies the default isolation level for the static
packages that you bind. You can select one of the isolation levels:
- Repeatable Read specifies that the default isolation level for the static packages will be Repeatable Read (RR). The RR isolation level isolates the SQL statements in the static package from the actions of concurrent users for rows the requester reads and changes, including phantom rows. RR isolation provides the most protection.
- All (RS) specifies that the default isolation level for the static packages will be Read Stability (RS). The RS isolation level isolates the SQL statements in the static package from the actions of concurrent users for rows the requester reads and changes
- Cursor Stability (CS) specifies that the default isolation level for the static packages will be Cursor Stability (CS). The CS isolation level isolates the SQL statements in the static package and the current row to which the database cursor is positioned from the actions of concurrent users for changes the requester makes.
- Change (UR) specifies that the default isolation level for the static packages will be Uncommitted Read (UR). The UR isolation level isolates the SQL statements in the static package from the actions of concurrent users for changes the requester makes.
- No Commit (NC) specifies that the default isolation level for the static packages will be No Commit (NC). The NC isolation level does not isolate the SQL statements in the static package from the actions of concurrent users for changes the requester makes.
- Default isolation level can be overridden
- This field specifies whether you can override the isolation level specified in the Default isolation level field. If this check box is selected, you can specify any isolation level when binding packages. If this check is not selected, you must use the default isolation level specified in the Default Isolation Level field to bind static packages.