Package - Options page

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.

Feedback