Db2 Requirements - ironstream_for_servicenow_discovery_1 - 7.5

Ironstream™ Software for ServiceNow® Discovery for IBM Z® Installation
Product type
Software
Portfolio
Integrate
Product family
Ironstream™ software
Product
Ironstream™ software > Ironstream™ software for ServiceNow® Discovery
Version
7.5
ft:locale
en-US
Product name
Ironstream™ Software for ServiceNow® Discovery for IBM Z®
ft:title
Ironstream™ Software for ServiceNow® Discovery for IBM Z® Installation
First publish date
2007
ft:lastEdition
2026-02-03
ft:lastPublication
2026-02-03T14:17:18.347000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Ironstream
L4_Investment_Segment
Log Data Integration
L5_Product_Group
LDI - Ironstream
L6_Product_Name
Ironstream for ServiceNow

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

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

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)