Performing SQL Administrative Tasks

Performing SQL Administrative Tasks

You can use the SQL Administrative functions to perform the following maintenance:

• Set a default authorization ID for the current session.
• Rebind a plan.
• Delete a plan.

The SET AUTHID option allows you to change the default authorization ID used for the execution of SQL members in your current Interactive SQL Service Facility session. This default is released when you exit from the Interactive SQL Service Facility.

The plan options are for administration of plans associated with programs. You can rebind plans without having to re-precompile, and delete plans when the associated program becomes obsolete.