Previous Topic: DB2COLLNext Topic: Examples


DB2DBASE

Description

Identifies DB2 databases.

TSS Commands

The following TSS commands can be used with the DB2DBASE keyword: CREATE, DELETE, ADDTO, REMOVE, PERMIT, REVOKE, ADMIN, DEADMIN, WHOOWNS, WHOHAS.

TSS ADDTO or REMOVE

Syntax
TSS ADD(acid) DB2DBASE(database,database,database,...)
Prefix length

2‑8 characters

Capacity of list

1‑5 DB2 database or prefixes per TSS command.

Authority

Administrators must have DB2DBASE(OWN) authority.

Masking

The DB2DBASE resource class supports all masking characters.

Types

The DB2DBASE 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) DB2DBASE(database)
Database name

2‑8 characters

Capacity of list

1‑5 databases or prefixes per TSS command.

Accesses

The administrator can specify any or all of the following accesses: DBADM, DBCTRL, DBMAINT, CRETAB, CRETS, DISPDB, DROP, IMAGCOPY, LOAD, RECOVDB, REORG, REPAIR, STARTDB, STATS, STOPDB, ALL, NONE. The default access is CRETAB.

Access Controls

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

Types

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

TSS ADMIN or DEADMIN

Syntax
TSS ADMIN(acid) DB2DBASE(authority level(s))
Authority 	

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

Types

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