Connect to a DB2® for z/OS subsystem |
All of the following authorities and privileges:- To connect to the subsystem, you must have access authority on
underlying subsystem.
- To execute tuning functions, you must have EXECUTE privilege on
the following packages:
- AOC5OADM
- AOC5OEPJ (DB2 for z/OS® Version 8)
- AOC5OEPK (DB2 for z/OS Versions 9 and 10)
- AOC5ONPT
- AOC5OPKG
|
Bind packages |
One of the following authorities and privileges: - SYSADM or DBADM authority
- If the required packages do not exist, BINDADD and CREATEIN privileges
on the schema
- If the required packages exist, ALTERIN and BIND privileges on
the schema
|
Free packages |
One of the following authorities and privileges: - Ownership of the packages
- BINDAGENT privilege that is granted by the owner of the packages
- SYSCTRL authority
- SYSADM authority
- PACKADM authority for the collection or for all collections
|
Browse subsystem parameters |
All of the following authorities and privileges:- EXECUTE privilege on the SYSPROC.DSNWZP stored procedure
- At least MONITOR1 system privilege
|
Manage users |
One of the following privileges or authorities: - The privilege WITH GRANT OPTION on the required packages
- Ownership of the packages
- SYSADM authority
|
Create EXPLAIN tables |
For creating the database, one or more of the
following privileges or authorities:- CREATEDBA privilege
- CREATEDBC privilege
- SYSADM or SYSCTRL authority
For creating the table space, one or more of the following privileges
or authorities:- CREATETS privilege for the database
- DBADM, DBCTRL, or DBMAINT authority for the database
- SYSADM or SYSCTRL authority
For creating the tables, one or more of the following privileges
or authorities:- CREATETAB privilege for the database
- DBADM, DBCTRL, or DBMAINT authority for the database
- SYSADM or SYSCTRL authority
|
Create aliases for existing EXPLAIN tables |
One of the following privileges or authorities: - The CREATEALIAS privilege
- SYSADM or SYSCTRL authority
- DBADM or DBCTRL authority on the database that contains the tables,
if the aliases are for tables and the value of field DBADM CREATE
AUTH on installation panel DSNTIPP is YES
|