Db2 for z/OS as Target

Fivetran HVR 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 HVR 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 HVR database User must be granted the select, insert, update, and delete privileges to read and change the replicated tables:

   grant select, insert, update, delete on table myschema.mytable to username;
   

2. The HVR database User must be granted the createtab privilege to create and drop HVR state tables:

   grant createtab on database mydatabase to username;
   

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

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