Db2 Requirements - ironstream_for_servicenow_discovery_1

Db2 Requirements - ironstream_for_servicenow_discovery_1 - 7.5

Ironstream for ServiceNow® Discovery for IBM Z® Installation

Product type

Software

Portfolio

Integrate

Product family

Ironstream

Product

Ironstream > Ironstream for ServiceNow® Discovery

Version

7.5

Language

English

Product name

Ironstream for ServiceNow® Discovery for IBM Z®

Title

Ironstream for ServiceNow® Discovery for IBM Z® Installation

First publish date

2007

Last updated

2024-08-08

Published on

2024-08-08T06:53:53.282000

General

The DB2 SDSNLOAD dataset must be added to the agent STEPLIB and that if multiple DB2 versions are running on the same LPAR, the latest version of the dataset should be used.

In addition, the DB2 subsystem must have the DSNREXX plan bound to each subsystem to be discovered.

RACF Permissions

Each Db2 subsystem that will be discovered will need to grant DISPLAY authority to the user or group that the Ironstream job is running under as described below:

Commands Issued	RACF General Resource	Native or RACF Security Configuration Requirements
`SubsystemPrefix DISPLAY DDF`	DSNR	With native Db2 security: Grant authority to DISPLAYAUTH group Class = DSNR Profile = *DB2SSID*.BATCH with Authority READ
`SubsystemPrefix DISPLAY DDF`	MDSNSM	With RACF/DB2 security: Grant authority to DISPLAYAUTH group Class = DSNR Profile = *DB2SSID.BATCH with Authority READ Class = MDSNSM Profile = DB2SSID*.DISPLAY with Authority READ
`SubsystemPrefix DISPLAY GROUP`	DSNR	With native DB2 security: Grant authority to DISPLAYAUTH group Class = DSNR Profile = *DB2SSID*.BATCH with Authority READ
`SubsystemPrefix DISPLAY GROUP`	MDSNSM	With RACF / DB2 security: Grant authority to DISPLAYAUTH group Class = DSNR Profile = *DB2SSID.BATCH with Authority READ Class = MDSNSM Profile = DB2SSID*.DISPLAY with Authority READ
`SELECT * FROM SYSIBM.LOCATIONS;` `SELECT * FROM SYSIBM.SYSDATABASE;` `SELECT * FROM SYSIBM.SYSTABLESPACE;`	DSNR	With native DB2 security: Grant authority to DISPLAYAUTH group Class = DSNR Profile = *DB2SSID*.BATCH with Authority READ
	MDSNTB	With RACF / DB2 security: Grant authority to DISPLAYAUTH group Class = DSNR Profile = *DB2SSID.BATCH with Authority READ Class = MDSNTB Profile = DB2SSID.OWNER.TABLE.ACTION with Authority READ e.g.: Profile = DB2SSID...SELECT or Profile = DB2SSID.SYSIBM..SELECT or Profile = *DB2SSID*.SYSIBM.LOCATIONS.SELECT (access required must be granted to the most specific RACF rule defined)