Resources › DB2TABSP Resource Class—Secure DB2 Table Spaces

DB2TABSP Resource Class—Secure DB2 Table Spaces

Valid on z/OS.

Use DB2TABSP to secure DB2 table spaces.

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

TSS ADDTO(acid) DB2TABSP(database.table space,...)

Prefix length

Two to 17 characters

Capacity of list

One to five DB2 table spaces or prefixes per TSS command

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

TSS PERMIT(acid) DB2TABSP(database.table space prefix(es))

Prefix length

Two to 17 characters per prefix

Full name

Two to 17 characters

Capacity of list

One to five table spaces or prefixes per TSS command

The DB2TABSP resource class supports all masking characters.

DB2TABSP is used with:

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

Administrators can specify:

• Any or all of the following levels: OWN, XAUTH, AUDIT, INFO, REPORT, ALL.
• The administrator can specify the accesses: USE, NONE, and ALL. The default is USE.

Examples: DB2TABSP resource class

This example gives the Finance Department (FINDEPT) ownership of the table space TSPACE1 that resides on database ACCTING:

TSS ADDTO(FINDEPT) DB2TABSP(ACCTING.TSPACE1)

This example removes ownership of the table space TSPACE1:

TSS REMOVE(FINDEPT) DB2TABSP(ACCTING.SPACE1)

This example authorizes USRMARK to access table space ACCTING.TSPACE1:

TSS PERMIT(USRMARK) DB2TABSP(ACCTING.TSPACE1)

This example revokes USRMARK's Authority to table space ACCTING.TSPACE1:

TSS REVOKE(USRMARK) DB2TABSP(ACCTING.TSPACE1)

This example gives FINVCA the ability to assign ownership of table spaces, to PERMIT user to access table spaces within his scope, and to audit the use of table spaces owned by the division:

TSS ADMIN(FINVCA) DB2TABSP(OWN,XAUTH,INFO)

This example removes FINVCA's Authority for table spaces:

TSS DEADMIN(FINVCA) DB2TABSP(OWN,XAUTH,INFO)