Use the Options page to view additional settings for the package.
- Binder
- Shows the user ID that ran the bind command for the package.
- Cursor blocking
- Specifies the setting for cursor blocking:
- UNAMBIG
- Specifies that blocking occurs for cursors that are specified with the FOR READ ONLY clause. Blocks cursors that are not declared with the FOR READ ONLY or FOR UPDATE clause, which are not ambiguous and are read-only. Ambiguous cursors will not be blocked.
- ALL
- Specifies that blocking occurs for cursors that are specified with the FOR READ ONLY clause or that are not specified as FOR UPDATE.
- NO
- Specifies that blocking does not occur for any cursor.
- Default schema
- The user ID of the person who created the object or the ID that is associated with the database connection.
- Explain snapshot
- Specifies whether an Explain snapshot exists for the package.
- Isolation level
- Specifies the level of isolation for the package.
- Number of sections
- Specifies how many sections are in the package.
- Owner
- Specifies the user ID that owns the package.
- Reoptimize
- Specifies whether to have DB2® optimize during the bind process.
- SQL path
- Specifies the path to use when resolving routine references during the bind operation.