Authorities and privileges for configuring DB2 for z/OS subsystems from IBM Data Studio

Ensure that you have the authorities and privileges that are required to configure a DB2® for z/OS® subsystem from IBM® Data Studio.
There are two sets of authorities and privileges that are required:

Authorities and privileges required to connect to and configure a DB2 for z/OS subsystem for tuning

Task Authorities or privileges required
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:

    basic 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

Authorities and privileges required to enable EXPLAIN function on a DB2 for z/OS subsystem

Task Authorities or privileges required
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

Feedback