Resources › DB2BUFFP Resource Class—Secure DB2 Buffer Pools › Examples: DB2BUFFP resource class

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)