Resources › DB2BUFFP Resource Class—Secure DB2 Buffer Pools

DB2BUFFP Resource Class—Secure DB2 Buffer Pools

Valid on z/OS.

Use DB2BUFFP to secure DB2 buffer pools.

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

TSS ADDTO(acid) DB2BUFFP(buffer pool,buffer pool,buffer pool,...)

Prefix length

One to five characters

Capacity of list

One to five DB2 buffer pools or prefixes per TSS command

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

TSS PERMIT(acid) DB2BUFFP(buffer pool prefix(es))

Prefix length

One to five characters per prefix

Full name

One to five characters

Capacity of list

One to five buffer pools or prefixes per TSS command

DB2BUFFP is used with:

• The commands CREATE, ADDTO, PERMIT, REVOKE, ADMIN, DEADMIN, WHOOWNS, and WHOHAS
• The DB2BUFFP ACID types User, Profile, Department, Division, Zone, DCA, VCA, ZCA, LSCA, SCA, and MSCA when used with TSS ADD/REMOVE
• The ACID types User, Profile, DCA, VCA, ZCA, LSCA, SCA, and MSCA when used with TSS PERMIT/REVOKE
• DB2BUFFP(OWN) Authority

The administrator can:

• Specify the accesses: ALL, USE, and NONE. The default is USE.
• Use any of the following methods to control access to buffer pools: Expiration, Facility, Time/Day, and Actions.

Examples: DB2BUFFP resource class

This example gives the Operations Department (OPRDEPT) ownership of the buffer pool BP1:

TSS ADDTO(OPRDEPT) DB2BUFFP(BP1)

This example removes ownership of the table BP1:

TSS REMOVE(OPRDEPT) DB2BUFFP(BP1)

This example authorizes USRMARK to access buffer pool BP1 with USE access so that this user can name BP1 in a CREATE INDEX or CREATE TABLESPACE statement:

TSS PERMIT(USRMARK) DB2BUFFP(BP1)
                    ACCESS(USE)

This example revokes USRMARK's Authority to buffer pool BP1:

TSS REVOKE(USRMARK) DB2BUFFP(BP1)