Resources › DB2STOGP Resource Class—Secure DB2 Storage Groups

DB2STOGP Resource Class—Secure DB2 Storage Groups

Valid on z/OS.

Use DB2STOGP to secure DB2 storage groups.

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

TSS ADDTO(acid) DB2STOGP(storage group, storage group,storage group,...)

Prefix length

One to eight characters

Capacity of list

One to five DB2 storage groups or prefixes per TSS command

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

TSS PERMIT(acid) DB2STOGP(storage group prefix(es))

Prefix length

One to eight characters per prefix

Full name

One to eight characters

Capacity of list

One to five storage groups or prefixes per TSS command

DB2STOGP is used with:

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

The administrator can:

• Specify the accesses ALL and USE.
• The following methods to control access to storage groups: Expiration, Facility, Time/Day, and Actions.

Examples: DB2STOGP Resource Class

This example gives the Operations Department (OPRDEPT) ownership of the storage group TESTDASD:

TSS ADDTO(OPRDEPT) DB2STOGP(TESTDASD)

This example removes ownership of the table TESTDASD:

TSS REMOVE(OPRDEPT) DB2STOGP(TESTDASD)

This example authorizes USRMARK to access storage group TESTDASD:

TSS PERMIT(USRMARK) DB2STOGP(TESTDASD)

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

TSS REVOKE(USRMARK) DB2STOGP(TESTDASD)