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:
    • 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

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 tables, if the alias is for tables and the value of field DBADM CREATE AUTH on installation panel DSNTIPP is YES

Feedback