Resources › DB2PLAN Resource Class—Secure DB2 Plans

DB2PLAN Resource Class—Secure DB2 Plans

Valid on z/OS.

Use DB2PLAN to secure DB2 plans.

When used with TSS ADDTO/REMOVE, this resource class has the following format:

TSS ADDTO(acid) DB2PLAN(plan,plan,plan,...)

Prefix length

One to eight characters

Capacity of list

One to five DB2 plans or prefixes per TSS command

When used with TSS PERMIT/REVOKE, this resource class has the following format:

TSS PERMIT(acid) DB2PLAN(plan prefix(es))

Prefix length

One to eight characters per prefix

Capacity of list

One to five plans or prefixes per TSS command

DB2PLAN is used with:

• The commands CREATE, ADDTO, REMOVE, PERMIT, REVOKE, ADMIN, DEADMIN, WHOOWNS, WHOHAS, and DELETE.
• The DB2PLAN ACID types User, Profile, Department, Division, Zone, DCA, VCA, ZCA, LSCA, SCA, and MSCA.
• DB2PLAN(OWN) Authority

The administrator can specify:

• The accesses: BIND, EXECUTE, ALL, and NONE. The default is EXECUTE.
• The following methods to control access to plans: Expiration, Facility, Time/Day, and Actions.

Examples: DB2PLAN resource class

This example gives the Engineering Department (ENGDEPT) ownership of the plan SR19052P:

TSS ADDTO(ENGDEPT) DB2PLAN(SR19052P)

This example removes ownership of the plan SR19052P:

TSS REMOVE(ENGDEPT) DB2PLAN(SR19052P)

This example authorizes USRMIKE to bind on plan SR19052P:

TSS PERMIT(USRMIKE) DB2PLAN(SR15092P) ACCESS(BIND)

This example revokes USRMIKE's Authority to plan SR19052P:

TSS REVOKE(USRMIKE) DB2PLAN(SR19052P)