Authority changes for Db2 Mirror SQL services

The caller of the following Db2 Mirror views must be running under a user profile that has *IOSYSCFG special authority or have access to the QIBM_IOSYSCFG_VIEW function usage identifier.

  • MIRROR_CLUSTER_INFO view
  • MIRROR_INFO view
  • MIRROR_OBJECTCONNECT_INFO view
  • MIRROR_TAKEOVER_INFO view
  • NRG_INFO view
  • NRG_LINK_INFO view
  • RDMA_CONNECTION_INFO view
  • RDMA_LINK_INFO view

The caller of the following Db2 Mirror procedures must be running under a user profile that has *IOSYSCFG special authority.

  • ADD_MIRROR_TAKEOVER_ADDRESS procedure
  • CHANGE_MIRROR_TAKEOVER_GROUP procedure
  • CREATE_MIRROR_TAKEOVER_GROUP procedure
  • DELETE_MIRROR_TAKEOVER_GROUP procedure
  • REMOVE_MIRROR_TAKEOVER_ADDRESS procedure
  • SET_MIRROR_CLUSTER procedure
  • SETUP_MIRROR procedure
  • SWAP_MIRROR_TAKEOVER_GROUP procedure

An SQL error SQLCODE -443, SQLSTATE '42502' will be returned if the user has insufficient authority.

In prior releases, no authority was required to access the information in the views or to call the procedures.