Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see DASD MANAGER PLUS for DB2 13.1.

Having authority to collect statistics

If you want to run BMCSTATS, BMCUPRS, and BMCCPRS, you must have one of the types of authority shown in the following table.

If using Db2 security exits for authorization, the programs invoke the exit to verify access.

Authorization requirements

Authority

Specification

SYSADM

SYSUSERAUTH.SYSADMAUTH = G or Y

SYSCTRL

SYSUSERAUTH.SYSCTRLAUTH = G or Y

SDBADM

SYSUSERAUTH.SYSADMAUTH = G or Y

SQLADM

SYSUSERAUTH.SYSSQLADMAUTH = G or Y

STATS for the database

SYSDBAUTH.STATSAUTH = G or Y

DBADM

SYSDBAUTH.DBADMAUTH = G or Y

DBCTRL

SYSDBAUTH.DBCTRLAUTH = G or Y

DBMAINT

SYSDBAUTH.DBMAINTAUTH = G or Y

Be aware of the following items:

  • When OPNDB2ID = Y in the installation options module, users with STATS authority can collect statistics even if their logon IDs do not have Resource Access Control Facility (RACF) authority to read the data set.

    BMCSTATS uses RACF to check secondary authorizations. If the user ID submitting the BMCSTATS job does not have Db2 authority to run BMCSTATS against the object, BMCSTATS uses the RACF authority to process the objects in the utility.

  • Users with Execute authority for the DASD MANAGER PLUS statistics collection plan can view and update the Db2 catalog online.
  • For more information about the plans, see the BMC Products and Solutions for DB2 Customization Guide.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*