SQL services changes to require *IOSYSCFG or QIBM_IOSYSCFG_VIEW

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

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

  • ASP_INFO
  • ASP_JOB_INFO
  • MEDIA_LIBRARY_INFO
  • NETSTAT_INFO
  • NETSTAT_INTERFACE_INFO
  • NETSTAT_JOB_INFO
  • NETSTAT_ROUTE_INFO
  • OBJECTCONNECT_INFO
  • RDB_ENTRY_INFO
  • SERVER_SBS_CONFIGURATION
  • SERVER_SHARE_INFO
  • TAPE_CARTRIDGE_INFO
  • TELNET_SERVER_ATTRIBUTES
  • TIME_PROTOCOL_INFO

In prior releases, no authority was required to access the information.