DB2TABSP

Description: Identifies DB2 table spaces.
TSS Commands: The following TSS commands can be used with the DB2TABSP keyword: CREATE, DELETE, ADDTO, REMOVE, PERMIT, REVOKE, ADMIN, DEADMIN, WHOOWNS, WHOHAS.

TSS ADDTO/REMOVE

Syntax

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

Prefix length: 2‑17 characters
Capacity of list: 1‑5 DB2 table spaces or prefixes per TSS command.

Authority

Administrators must have DB2TABSP(OWN) authority.

Masking

The DB2TABSP resource class supports all masking characters.

Types

The DB2TABSP 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) DB2TABSP(database.table space prefix(es))

Table space name: 2‑17 characters
Capacity of list: 1‑5 table spaces or prefixes per TSS command.

Accesses

The 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 table spaces: Expiration, Facility, Time/Day, Actions.

Types

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

TSS ADMIN or DEADMIN

Syntax

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

Authority

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

Types

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

Examples

TSS ADDTO/REMOVE

To give the Finance Department (FINDEPT) ownership of the table space TSPACE1 that resides on database ACCTING, the administrator enters:

TSS ADD(FINDEPT) DB2TABSP(ACCTING.TSPACE1)

Ownership of the table space TSPACE1 is removed by entering:

TSS REMOVE(FINDEPT) DB2TABSP(ACCTING.TSPACE1)

TSS PERMIT/REVOKE

The administrator wants to authorize USRMARK to access table space ACCTING.TSPACE1. He enters:

TSS PERMIT(USRMARK) DB2TABSP(ACCTING.TSPACE1)

To revoke USRMARK's authority to table space ACCTING.TSPACE1, he enters:

TSS REVOKE(USRMARK) DB2TABSP(ACCTING.TSPACE1)

TSS ADMIN/DEADMIN

To give FINVCA the ability to assign ownership of table spaces, to permit users to access table spaces within his scope, and audit the use of table spaces owned by the division, the administrator enters:

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

To remove FINVCA's authority for table spaces, the administrator enters:

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

TSS WHOHAS

To determine who has access to the table space ACCTING.TSPACE1, the administrator enters:

TSS WHOHAS DB2TABSP(ACCTING.TSPACE1)

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

TSS WHOOWNS

To determine who owns the table space ACCTING.TSPACE1, the administrator enters:

TSS WHOOWNS DB2TABSP(ACCTING.TSPACE1)