Connect to a DB2 for z/OS subsystem |
- To connect to the subsystem,
you must have access authority on
underlying DB2 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
- BINDADD privilege
if required packages do not exist, and CREATEIN
privilege on the schema
- ALTERIN privilege on the schema if
the required packages exist
- BIND privilege on the required
packages if they exist
|
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 |
Both
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 required packages
- Ownership of the packages
- SYSADM
authority
|
Create
EXPLAIN tables |
If you want to create
the EXPLAIN tables in
a new database, one or more of the following privileges or authorities
for creating the database:- 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
|