Repository Database in Db2 for Linux, Unix and Windowslink
Fivetran HVR allows you to create a repository database in Db2 for Linux, Unix and Windows (LUW).
Grants for Repository Databaselink
The following grant is required for the repository database in Db2 for LUW:
- The repository User should have permission to create and drop HVR repository tables.
grant createtab on database to user username
Repository Database Connectionlink
This section describes the details required for connecting to the repository database in Db2 for LUW:
Field | Description | Equivalent Location Property |
---|---|---|
INSTHOME | When using "Db2 client or Db2 server or Db2 Connect" the directory path of the Db2 installation must be specified. When using "IBM Data Server Driver for ODBC and CLI" the directory path of the IBM Data Server Driver for ODBC and CLI installation on HVR machine (e.g. /distr/db2/driver/odbc_cli/clidriver) must be specified. Example: /db2/9.7 | Db2_INSTHOME |
DB2INSTANCE | When using "Db2 client or Db2 server or Db2 Connect", the name of the Db2 instance must be specified. When using "IBM Data Server Driver for ODBC and CLI" this field must be left blank/empty. Example: db2instl | Db2_DB2INSTANCE |
DATABASE | Name of the DB2 database. Example: mytestdb | Database_Name |
USER | Username for connecting HVR to the Db2 database. Example: hvruser | Database_User |
PASSWORD | Password for the USER. | Database_Password |