DB2BUFFP

Description: Identifies DB2 buffer pools.
TSS Commands: The following TSS commands can be used with this keyword: CREATE, DELETE, ADDTO, REMOVE, PERMIT, REVOKE, ADMIN, DEADMIN, WHOOWNS, WHOHAS.

TSS ADDTO or REMOVE

Syntax

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

Prefix length: 1‑8 characters
Capacity of list: 1‑5 DB2 buffer pools per TSS command.

Authority

Administrators must have DB2BUFFP(OWN) authority.

Types

The DB2BUFFP keyword is used with the following ACID types: User, Profile, Department, Division, Zone, DCA, VCA, ZCA, LSCA, SCA, MSCA.

TSS PERMIT or REVOKE

Syntax

TSS PER(acid) DB2BUFFP(buffer pool,buffer pool)

Buffer pool: 1‑8 characters
Capacity of list: 1‑5 buffer pools per TSS command.

Accesses

The CA Top Secret Option for DB2 administrator can specify any or all of the following accesses: USE, ALL, NONE. The default access is USE.

Access Controls

The administrator can use any of the following methods to control access to buffer pools: Expiration, Facility, Time/Day, Actions.

Types

The DB2BUFFP keyword is used with the following ACID types: User, Profile, DCA, VCA, SCA, MSCA.

TSS ADMIN or DEADMIN

Syntax

TSS ADMIN(acid) DB2BUFFP(authority level(s))

Authority

Administrators can specify any or all of the following authority levels: OWN, XAUTH, AUDIT, INFO, REPORT, ALL.

Types

The DB2BUFFP keyword is used with the following ACID types: User, DCA, VCA, SCA, MSCA.

Examples

TSS ADDTO/REMOVE

To give the Operations Department (OPRDEPT) ownership of the buffer pool BP1, the administrator enters:

TSS ADD(OPRDEPT) DB2BUFFP(BP1)

Ownership of the buffer pool BP1 is removed by entering:

TSS REMOVE(OPRDEPT) DB2BUFFP(BP1)

TSS PERMIT/REVOKE

The administrator wants to authorize USRMARK to buffer pool BP1 with USE access so that this user can name BP1 in a CREATE INDEX or CREATE TABLESPACE statement. He enters:

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

To revoke USRMARK's authority to buffer pool BP1, he enters:

TSS REVOKE(USRMARK) DB2BUFFP(BP1)

TSS ADMIN/DEADMIN

To give administrator OPRDCA the ability to permit users to access buffer pools within his scope, he enters:

TSS ADMIN(OPRDCA) DB2BUFFP(XAUTH)

To remove OPRDCA's authority for buffer pools, the administrator enters:

TSS DEADMIN(OPRDCA) DB2BUFFP(XAUTH)

TSS WHOHAS

To determine who has access to the buffer pool BP1, the administrator enters:

TSS WHOHAS DB2BUFFP(BP1)

CA Top Secret will respond by displaying all of the ACIDs that have access to this particular buffer pool.

TSS WHOOWNS

To determine who owns the buffer pool BP1, the administrator enters:

TSS WHOOWNS DB2BUFFP(BP1)