Db2 for z/OS as Target

Data Source Solutions DSS supports integrating changes into Db2 for z/OS location. This section describes the configuration requirements for integrating changes (using Integrate and Refresh) into Db2 for z/OS location.

For the list of supported Db2 for z/OS versions, into which DSS can integrate changes, see Integrate changes into location in Capabilities.

Grants for Integrate and Refresh

The following grants are required for integrating changes into Db2 for z/OS:

1. The DSS database User must be granted the <b>select</b>, <b>insert</b>, <b>update</b>, and <b>delete</b> privileges to read and change the replicated tables:

   grant select, insert, update, delete on table <em>myschema</em>.<em>mytable</em> to <em>username</em>;
   

2. The DSS database User must be granted the <b>createtab</b> privilege to create and drop DSS state tables:

   grant createtab on database <em>mydatabase</em> to <em>username</em>;
   

3. The DSS database User must be granted the <b>select</b> privilege for the following SYSIBM tables to fetch information about the Db2 for z/OS installation:

   grant select on table sysibm.sysauxrels to <em>username</em>;
   
   grant select on table sysibm.syscolauth to <em>username</em>;
   
   grant select on table sysibm.syscolumns to <em>username</em>;
   
   grant select on table sysibm.sysdatabase to <em>username</em>;
   
   grant select on table sysibm.sysforeignkeys to <em>username</em>;
   
   grant select on table sysibm.sysindexes to <em>username</em>;
   
   grant select on table sysibm.syskeys to <em>username</em>;
   
   grant select on table sysibm.sysparms to <em>username</em>;
   
   grant select on table sysibm.sysrels to <em>username</em>;
   
   grant select on table sysibm.sysroutines to <em>username</em>;
   
   grant select on table sysibm.syssynonyms to <em>username</em>;
   
   grant select on table sysibm.systabauth to <em>username</em>;
   
   grant select on table sysibm.systablepart to <em>username</em>;
   
   grant select on table sysibm.systables to <em>username</em>;
   

Intermediate Directory

{% partial file="dss6/requirements/source-and-target-requirements/intermediate-directory.template.md" /%}

Intermediate Directory is Local

{% partial file="dss6/requirements/source-and-target-requirements/intermediate-directory-local.template.md" /%}