Connect to a DB2 for z/OS subsystem |
All of the following authorities and privileges:- Underlying DB2 access
authority
- EXECUTE privilege on the following packages:
- DSN5OADM
- DSN5OEPJ (DB2 for z/OS Version 8)
- DSN5OEPK (DB2 for z/OS Versions 9 and 10)
- DSN5ONPT
- DSN5OPKG
|
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 |
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 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 table,
if the alias is for a table and the value of field DBADM CREATE AUTH
on installation panel DSNTIPP is YES
|